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:[EMAIL PROTECTED]] > 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: [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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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).
