RE: how to rename a database SID

Hear are the
steps (on Unix),
<FONT color=#0000ff

size=2> 
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...
<SPAN

class=839570917-18062001> 
Good
luck
<SPAN

class=839570917-18062001>Uday

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Andrey BronfinSent:   Monday, June 18, 2001 12:56 PMTo: Multiple recipients of list   ORACLE-LSubject: how to rename a database SID   HI ! How can i
  rename a database on NT / UNIX ? Thanks a   lot in advance ! Received on Mon Jun 18 2001 - 12:59:50 CDT