RE: how to rename a database SID

[udaycb]

Title: how to rename a database SID

Hear are the steps (on Unix),

 

Correct me if i am wrong.

 

1. Connect to svrmgrl,

2. Execute "alter database backup controlfile to trace;"

3. Find the trace file in udump directory. Edit the file and remove all unwanted lines i.e up to line "create control file...."

4. Change the database name save the file as .sql.

5. Shutdown the database.

6. Rename init.ora and config.ora also change the db_name parameters.

7. Connect to svrmgrl and run script which you have save as .sql in step 4.

Hope this info is helpful for you.

Note. Take a backup of your database before doing any off the above steps...

 

Good luck

Uday

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrey Bronfin
Sent: Monday, June 18, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
Subject: how to rename a database SID

HI !
How can i rename a database on NT / UNIX ?
Thanks a lot in advance !