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).
