Re: Rename Oracle User

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=131321.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: 
  INET: Brian_P_MacLean_at_eFunds.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).