RE: Changing Oracle gid and uid?

>> Might be 'safer' to un-install / reinstall the software
Man I hope not.... :o|

>>you would also have to reset the setuid permission on the oracle executable

But I *think* this is covered by these instructions?

cd $ORACLE_HOME/rdbms/lib
vi config.[cs]
...be sure you are using the group defined in this file relink the Oracle executable as below. rm config.o
make -f ins_rdbms.mk config.o ioracle  

I found this (above) in an Oracle doc, but really as part of another subject. Can not find the "Change oracle gid-uid" doc I'm looking for on Metalink?

Thanks,

Chris Marquez
Oracle DBA

-----Original Message-----
From: David Sharples [mailto:davidsharples_at_gmail.com] Sent: Wed 10/5/2005 12:32 PM
To: Marquez, Chris
Cc: oracle-l_at_freelists.org
Subject: Re: Changing Oracle gid and uid?  

you would also have to reset the setuid permission on the oracle executable as it would be lost with a chown
 Might be 'safer' to un-install / reinstall the software and changing the ID's in between

 On 10/5/05, Marquez, Chris <cmarquez_at_collegeboard.org> wrote:
>
>

RHEL3ES
Oracle 9205  

OK, I have a new nfs mount on 3 db servers; dbA, dbB, dbC. All the these server need to fully share the files. 2 of the 3 servers (dbA, dbB) oracle OS users has the same gid and uid numbers and the other server (dbC) is different.  

So when I use the nfs from servers dbA and dbB they see the files as owned by oracle, but from server dbC the files are owned by another user (the use with that uid in the local passwd / group file). And the opposite happens when pushing a file from dbC, when dbA and dbB look at it.  

What is my work-around?  

The SA came up with the idea of changing Oracle's gid and uid on dbC.  

I have been in this situation before, when someone broke oracle by changing the oracle gid and uid, but I just changed it back to what is was. However, during my debugging I found this (but did not have to use it);  

 The DBA group is compiled into the 'oracle' executable....  The actual group being used as this DBA group can be checked thus:   cd $ORACLE_HOME/rdbms/lib
  cat config.[cs]
 ...be sure you are using the group defined in this file relink the Oracle executable as below.   rm config.o
  make -f ins_rdbms.mk config.o ioracle  

So I guess if I change the oracle gid and uid then I would do the process above? I'm sure I would also have to $> chown -R oracle.dba *.* for all the oracle files as they would have the old gid and uid number showing and not the new gid and uid numbers?  

This sound correct.
Anybody done this?...got any notes instructions?  

Thanks,  

Chris Marquez
Oracle DBA

>
>
> Chris Marquez
> Oracle DBA
>

--
http://www.freelists.org/webpage/oracle-l