SID is already exist

I tried to create database, but I've got an error message that "SID is already exist". 

Window OS:-

just remove old sid by

$ oradim -delete -sid sidname

ORADIM is an Oracle utility that exists only on Windows: you cannot use it on UNIX systems such as AIX.


Cause: You have probably previously created database with the same name and have removed it but the traces of it still remain 

Linux OS :-

Open /etc/oratab file in edit mode and remove the line containing SID that is causing an error message.

 Another place to look would be $ORACLE_BASE/oraInventory/ContentsXML/inventory.xml - this file could also contain an entry with the offending SID..




No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...