Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-LReceived on Tue Mar 26 2002 - 09:23:35 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).