RE: Rename Oracle User

T

Todd

-----Original Message-----
Brian
Sent: Thursday, March 28, 2002 6:53 PM
To: Multiple recipients of list ORACLE-L

If you haven't already done this, the find's are unneeded.

How about replacing 1,3,4 with:
create dba group
usermod -l oracle -g dba oracle2

Since the ownership's in UNIX are by UID, if the username is changed then all the files are now owned by the new username(same UID).

shutdown
BACKUP
usermod
update scripts
startup

> -----Original Message-----
> From: Todd Carlson [mailto:tcarlson_at_tripos.com]
> Sent: Tuesday, March 26, 2002 10:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Rename Oracle User
>
>
> 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: Anderson, Brian
  INET: andersob_at_mail.dartnet.peachnet.edu

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