Home » Infrastructure » Unix » ORACLE SID
ORACLE SID [message #97942] Tue, 01 July 2003 13:42 Go to next message
Messages: 1
Registered: July 2003
Junior Member
does anyone know the procedure to change an ORACLE SID.
Re: ORACLE SID [message #97944 is a reply to message #97942] Thu, 03 July 2003 00:12 Go to previous messageGo to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Go to .profile in the oracle home directory.
Edit it & change the value of ORACLE_SID there.

That's it.

Re: ORACLE SID [message #97948 is a reply to message #97942] Thu, 03 July 2003 07:16 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
-- FIRST IDENTIFY THE CORRECT SID by querying v$instance
1. do a clean / normal shutdown ( NO shutdown abort / immediate)
2. take a complete cold backup.
3. change the entries for ORACLE_SID in all .profile variables in any env settings
4. in unix goto $ORACLE_HOME/dbs and rename or create a new init< new_sid >.ora
   in windows , i beleieve it will be in $ORACLE_HOME/database or whereever the
   init file is.
   Make sure,all the entries in this new inti< new_sid >.ora are pointing
   to the new_sid.
   take care, if you are using spiles or oracle password files.
5. now mount and open the database using the new init_sid.file
   Check the functionality.
   u will see that, still the oracle files will be in old_sid as per OFA ( if u have used it)
   optionally, rename the datafile to point to a OFA structre for new oracle_sid


Previous Topic: Clean Up File
Next Topic: semaphores configuration
Goto Forum:

Current Time: Thu Sep 28 16:40:33 CDT 2023