Hi...

-bash-3.00$ id -a
uid=1004(oracle) gid=101(oinstall) groups=101(oinstall),100(dba)


How to change gid from oinstall group to dba group??

Not sure on which OS you are, but usually you can just edit the /etc/passwd and the /etc/group to your needs.

Hi

I'm using Solaris 10

I'm afraid if i simply change the group, it will effect my oracle database

As long as oracle will be in the group dba, all will be ok, I think. If you just want to change the primary group, to dba, I see no problem. If you create a file or directory, it will have the users primary group, so you should know if that's what you want. To make sure everything is still accessable, you can keep oracle in the group orainstall.

On Solaris, I think you can just go on and edit the /etc/passwd and /etc/group. There is also some administration interface that you could use instead which's name I can't recall

Tq zaxxon

It's better if i stick with oinstall group.

Hi,

I think u can change the group

by using chgrp command

chgrp oinstall dba

Regards,
JeganR