How to delete and create oracle SID

Published on Author bloggereightLeave a comment

Oracle SID deletion and creation on Linux (RHEL) server.

The Oracle System ID (SID) is used to uniquely identify a particular database on a server.
Reason is one SID can not have more than one database when using RAC, all instances belonging to the same database must have unique SID’s.

. Delete oracle SID
. Create oracle SID

Step #1: Deletion oracle SID ” ORA10R2 “

Switch user to oracle

 su - oracle 

Delete SID using dbca

 dbca -silent -deleteDatabase -sourceDB ORA10R2 

Chek the log:

 tail -f /usr/local/oracle/10gR2/cfgtoollogs/dbca/ORA10R2.log

Step #2: Create new oracle SID ” ORA10R2 “

 dbca -silent -createDatabase -templateName ORA10R2_PERF.dbt -gdbname ORA10R2 -sid ORA10R2 -datafileJarLocation /usr/local/oracle/10gR2/assistants/dbca/templates -datafileDestination /usr/local/oracle/10gR2/oradata -responseFile NO_VALUE

Check the log:

 tail -f /usr/local/oracle/10gR2/cfgtoollogs/dbca/ORA10R2/ORA10R2.log



Leave a Reply

Your email address will not be published. Required fields are marked *