RE: Changing numeric ID for the oracle UID and the GID
Date: Mon, 6 Jun 2011 20:20:36 -0400
Message-ID: <304F58144267C5439E733532ABC9A3A111C6428D_at_USA0300MS02.na.xerox.net>
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_at_yahoo.com]
Sent: Monday, June 06, 2011 5:45 PM
To: Guillermo Alan Bort
Cc: Hameed, Amir; oracle-l_at_freelists.org
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_at_gmail.com>
To: oratune_at_yahoo.com
Cc: Amir.Hameed_at_xerox.com; oracle-l_at_freelists.org
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_at_yahoo.com> 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_at_xerox.com>
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 06 2011 - 19:20:36 CDT