Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Rename Oracle User

Rename Oracle User

From: Todd Carlson <tcarlson_at_tripos.com>
Date: Tue, 26 Mar 2002 07:23:35 -0800
Message-ID: <F001.0043345C.20020326072335@fatcity.com>


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).
Received on Tue Mar 26 2002 - 09:23:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US