Received: (qmail 19546 invoked from network); 6 Jun 2011 19:22:45 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 6 Jun 2011 19:22:21 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CFA6CE2939F; Mon, 6 Jun 2011 20:22:14 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1307406134; bh=guYgjEM5vMEdhrFI2MO6S6jn00D7nbJ80XMt+AlV 5sk=; h=MIME-Version:Content-Type:Subject:Date:Message-ID: In-Reply-To:References:From:To:Cc:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=TtslwH83WkESAYh1trJYR0oY5goMc5gnNcXGSdPnjQWG+p/Wdy rUSzSbrnvQMxsOWJSTNG+Tbk0NnW34EmAhqNfjOq0qfVcFEzvjRIbI3Mh9zhlWGcvHO PFl/zE1y2QQUoMxosVHTRt89KwRnk1fKntqKwa/YjPjFw8mjkIrhq4= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id J8O6vk6WTKkr; Mon, 6 Jun 2011 20:22:14 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 77483E292C5; Mon, 6 Jun 2011 20:21:31 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 06 Jun 2011 20:20:50 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C5A4DE29242 for ; Mon, 6 Jun 2011 20:20:49 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qJYDc4Mc7ICb for ; Mon, 6 Jun 2011 20:20:49 -0400 (EDT) Received: from USA7109MR003.ACS-INC.COM (usa7109mr003.acs-inc.com [63.101.151.12]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BAE35E29219 for ; Mon, 6 Jun 2011 20:20:43 -0400 (EDT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnIAABFu7U0Nh9IPmWdsb2JhbABTglKUXQ+OWRQBAQEBAQYNCwcUJcojgyqCdwSVWIQqhl8 Received: from usa0300gw002.na.xerox.net ([13.135.210.15]) by USA7109MR003.ACS-INC.COM with ESMTP; 06 Jun 2011 19:20:40 -0500 Received: from usa0300ms02.na.xerox.net ([13.135.234.15]) by USA0300GW002.na.xerox.net with Microsoft SMTPSVC(6.0.3790.4675); Mon, 6 Jun 2011 20:20:40 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CC24A8.BB0B8940" Subject: RE: Changing numeric ID for the oracle UID and the GID Date: Mon, 6 Jun 2011 20:20:36 -0400 Message-ID: <304F58144267C5439E733532ABC9A3A111C6428D@USA0300MS02.na.xerox.net> In-Reply-To: <218385.86476.qm@web65404.mail.ac4.yahoo.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Changing numeric ID for the oracle UID and the GID References: <304F58144267C5439E733532ABC9A3A111C641AB@USA0300MS02.na.xerox.net> <64753.79521.qm@web65413.mail.ac4.yahoo.com> <218385.86476.qm@web65404.mail.ac4.yahoo.com> From: "Hameed, Amir" To: "David Fitzjarrell" Cc: X-OriginalArrivalTime: 07 Jun 2011 00:20:40.0162 (UTC) FILETIME=[BB413420:01CC24A8] X-archive-position: 36603 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Amir.Hameed@xerox.com Precedence: normal Reply-To: Amir.Hameed@xerox.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l ------_=_NextPart_001_01CC24A8.BB0B8940 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 From: David Fitzjarrell [mailto:oratune@yahoo.com]=20 Sent: Monday, June 06, 2011 5:45 PM To: Guillermo Alan Bort Cc: Hameed, Amir; oracle-l@freelists.org Subject: Re: Changing numeric ID for the oracle UID and the GID =20 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. =20 David Fitzjarrell =20 =20 =20 ________________________________ From: Guillermo Alan Bort To: oratune@yahoo.com Cc: Amir.Hameed@xerox.com; oracle-l@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 wrote: You'll want to read here: =20 http://www.ibm.com/developerworks/aix/library/au-satuidgid/index.html =20 David Fitzjarrell =20 =20 =20 ________________________________ From: "Hameed, Amir" To: oracle-l@freelists.org Sent: Mon, June 6, 2011 1:56:10 PM Subject: Changing numeric ID for the oracle UID and the GID =20 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: =20 $ id uid=3D89488(oracle) gid=3D6001(oinstall) =20 The future id would look like: uid=3D202(oracle) gid=3D200(oinstall) =20 Has anyone done this before? Any feedback will be appreciated. =20 Thanks Amir =20 =20 ------_=_NextPart_001_01CC24A8.BB0B8940 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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@yahoo.com]
Sent: Monday, = June 06, 2011 5:45 PM
To: Guillermo Alan Bort
Cc: = Hameed, Amir; oracle-l@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@gmail.com>
To: = oratune@yahoo.com
Cc: Amir.Hameed@xerox.com; = oracle-l@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@yahoo.com> = wrote:

You'll want to read = here:

 

http://www.ibm.com/developerwork= s/aix/library/au-satuidgid/index.html
 

David Fitzjarrell

 

 

 

From:= = "Hameed, Amir" <Amir.Hameed@xerox.com>
To: oracle-l@freelists.org
Sent: Mon, June = 6, 2011 1:56:10 PM
Subject: Changing numeric ID for the oracle = UID and the GID

 

Folks,<= /o:p>

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:

 <= /o:p>

$ = id

uid=3D89488(= oracle) gid=3D6001(oinstall)

 <= /o:p>

The future = id would look like:

uid=3D202(or= acle) gid=3D200(oinstall)

 <= /o:p>

Has anyone = done this before? Any feedback will be appreciated.

 <= /o:p>

Thanks<= /o:p>

Amir

 <= /o:p>

 

------_=_NextPart_001_01CC24A8.BB0B8940-- -- http://www.freelists.org/webpage/oracle-l