RE: Changing numeric ID for the oracle UID and the GID
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: "David Fitzjarrell" <oratune@xxxxxxxxx>
- Date: Mon, 6 Jun 2011 20:20:36 -0400
Thanks David. The link was really useful. I have also opened an SR with
Oracle to find out the "supported" way of changing these entities. The
initial response from the analyst was to reinstall the entire stack,
which is simply not an option.
From: David Fitzjarrell [mailto:oratune@xxxxxxxxx]
Sent: Monday, June 06, 2011 5:45 PM
To: Guillermo Alan Bort
Cc: Hameed, Amir; oracle-l@xxxxxxxxxxxxx
Subject: Re: Changing numeric ID for the oracle UID and the GID
Please read the entire link I supplied as it answers all of your UNIX
questions. Additionally the GID is stored in /etc/group and the UID is
stored in /etc/passwd but you shouldn't edit those files directly as
there are likely corresponding shadow files which also need to be
changed. UNIX offers utilities to change these values which should be
used to ensure success. Again, all of this is provided in the link.
David Fitzjarrell
________________________________
From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
To: oratune@xxxxxxxxx
Cc: Amir.Hameed@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Sent: Mon, June 6, 2011 2:17:02 PM
Subject: Re: Changing numeric ID for the oracle UID and the GID
Hmm, they need to be the same on all the nodes, I'm not sure if they are
stored somewhere. I would certainly stop the entire cluster, do the
change, fix the file ownership, and then start everything back up again,
and do it on a testing server first. Also, it would be a good idea to
open a SR with Oracle and have an "official" answer.
hth
Alan.-
On Mon, Jun 6, 2011 at 6:03 PM, David Fitzjarrell <oratune@xxxxxxxxx>
wrote:
You'll want to read here:
http://www.ibm.com/developerworks/aix/library/au-satuidgid/index.html
David Fitzjarrell
________________________________
From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Mon, June 6, 2011 1:56:10 PM
Subject: Changing numeric ID for the oracle UID and the GID
Folks,
I need to change the numeric IDs for the UID and the GID of the oracle
account which owns the RDBMS and the Grid infrastructure. This is a
two-node RAC (11.2.0.2) running on Solaris. The current id looks like:
$ id
uid=89488(oracle) gid=6001(oinstall)
The future id would look like:
uid=202(oracle) gid=200(oinstall)
Has anyone done this before? Any feedback will be appreciated.
Thanks
Amir
Other related posts:
