Re: Rename Oracle User

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