The SID name is the ORACLE_SID value and point to the init<SID>.ora file. You can, at any time, shutdown the database, change the value of ORACLE_SID, rename the init<SID>.ora file to init<newSID>.ora and restart --- voila your SID name has changed ! [You would also need to update the listener.ora for the new SID name]. Changing the databse name requires the CREATE CONTROLFILE SET DATABASE <newname> and the new name as the "db_name=" in the init<SID>.ora file.
Hemant K Chitale ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, 25 May, 2002 3:08 AM > I saw a post on MetaLink (Note 15390.1) about changing db_name and > oracle_sid without recreating the db's. > > my question is if I want to change the db_name, do I first need to change > the SID? Or can I do it in one fell swoop, as follows: > > backup controlfile to trace > edit file to create new controlfile using "set database <newdbname>" > rename init<sid>.ora with new sid > edit init.ora file with new controlfile names and new sid, db_name, etc. > create new password file > > startup db with ORACLE_SID env variable set to new sid > create new controlfile > > ...also > > can I rename datafiles and logfiles in the process by putting their new > names in the create controlfile script? > > thanks > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Magaliff, Bill > 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: Hemant K Chitale 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).
