RE: how to rename a database SID

<SPAN

class=288123018-18062001>Uday:
<SPAN

class=288123018-18062001> 
<SPAN

class=288123018-18062001>You forgot one important step.  In the 'create controlfile' command
<SPAN

class=288123018-18062001>line, where you change the database SID you must add the word 'SET'.
<SPAN

class=288123018-18062001> 
<SPAN

class=288123018-18062001>For example, if the trace file was created as...
<SPAN

class=288123018-18062001>CREATE CONTROLFILE REUSE DATABASE "OLDSID" NORESETLOGS ARCHIVELOG
<SPAN

class=288123018-18062001> 
<SPAN

class=288123018-18062001>...then the new line must be changed to...
<SPAN

class=288123018-18062001>
<SPAN

class=288123018-18062001>CREATE CONTROLFILE REUSE SET DATABASE "NEWSID" RESETLOGS ARCHIVELOG
 
<SPAN

class=288123018-18062001>HTH,
<SPAN

class=288123018-18062001>Mike
<SPAN

class=288123018-18062001> 

---


<FONT color=#0000ff face="Courier New" 

size=2>===========================================================================
Michael P. 
Vergara              
| I’ve got a PBS mind in an MTV world
Oracle 
DBA                      
|
Guidant 
Corporation             
|

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: udaycb 
  [mailto:udaycb_at_trwasp.com]Sent: Monday, June 18, 2001 11:22 
  AMTo: Multiple recipients of list ORACLE-LSubject: 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 !