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@trip To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> os.com> cc: Sent by: Subject: Rename Oracle User [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).