RE: Rename Oracle User

2002-03-29 Thread Todd Carlson
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

RE: Rename Oracle User

2002-03-28 Thread Anderson, Brian
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

Re: Rename Oracle User

2002-03-26 Thread Brian_P_MacLean
Surprised to not see a backup of the DB and $ORACLE_BASE after #2. You can combine #3 #4 with find / -user oracle2 -exec chown oracle:dba {} \; as long as oracle2 is the only member of the dba2 group and you're not using the oinstall as oracle2's default group. I think #4 should be -group

RE: Rename Oracle User

2002-03-26 Thread Todd Carlson
Sorry, I should have specified the backup was first. Thanks for the sanity check Brian! Todd -Original Message- Sent: Tuesday, March 26, 2002 12:06 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Surprised to not see a backup of the DB and $ORACLE_BASE after #2. You can combine #3

Re: Rename Oracle User

2002-03-26 Thread Stephane Faroult
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