Todd Carlson wrote:
>
> 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
>
There is one additional thing at least you should check, namely
$ORACLE_HOME/rdbms/admin/config.c which contains (hard-coded) the
expected group name. If 'dba2' was chosen during install, then you'll
probably find it inside config.c. You should then run
cc -c config.c -o config.o
and relink oracle (make -f ins_rdbms.mk install should do the trick).
You should take the backup as step 3, not step 9.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
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).
