Friday, January 4, 2013

The Oracle system identifier '' already exists, specify another SID

The Oracle system identifier '' already exists, specify another SID error occurs during database creation via dbca utility.

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

Solution: 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

12 comments: