RE: Rename Oracle User

Sorry, I should have specified the backup was first. Thanks for the sanity check Brian!

Todd

-----Original Message-----
Sent: Tuesday, March 26, 2002 12:06 PM
To: ORACLE-L_at_fatcity.com
Cc: tcarlson_at_tripos.com

Surprised to not see a backup of the DB and $ORACLE_BASE after #2.

You can combine #3 & #4 with "find / -user oracle2 -exec chown oracle:dba
{} \;" as long as oracle2 is the only member of the dba2 group and you're
not using the "oinstall" as oracle2's default group.

I think #4 should be "-group dba2" not "-user dba2".

Not sure what #5 means.

To be safe #6 should be a recompile of the Oracle executables. Something like the following, but see ->
http://metalink.oracle.com/metalink/plsql/ml2_documents.showNot?p_id=131 321.1&p_font

 (Note:131321.1 Subject: How to Relink Oracle Database Software on Unix)
for details:

---THIS IS A SOLARIS KSH SHELL EXAMPLE--- export PATH=/usr/ccs/bin:${PATH}
which ld #should return '/usr/ccs/bin/ld' export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH} #If using 64bit Oracle, LD_LIBRARY_PATH should also include $ORACLE_HOME/lib64.
cd $ORACLE_HOME/bin
relink all        

                    "Todd Carlson"

                    <tcarlson_at_trip       To:     Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>               
                    os.com>              cc:

                    Sent by:             Subject:     Rename Oracle User

                    root_at_fatcity.c

                    om

 

 

                    03/26/02 08:23

                    AM

                    Please respond

                    to ORACLE-L

 

 

Solaris 5.8 Oracle 8.1.7.2
Has anyone successfully renamed the Oracle user on a solaris box? At the moment I don't a test box and this is a rarely used development system. The current Oracle user and group are oracle2 and dba2. We have to change it to match our standards, i.e. oracle & dba.

The plan is to (after a full system backup):

1) Create the correct local user & group with the same home directory.
2) Shutdown all Oracle processes.
3) Find . -user oracle2 -exec chown oracle {} \;
4) Find . -user dba2 -exec chgrp dba {} \;
5) Modify all scripts to use the correct group & user.
6) Pray.
7) Start the database and listener.
8) Check for functionality & errors.
9) Shut everything down and take a full system backup.

Am I missing anything? Is there any problems with the method?

Thanks,
Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Todd Carlson
  INET: tcarlson_at_tripos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Todd Carlson
  INET: tcarlson_at_tripos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).