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

6 comments:

  1. Thanks for pointing this out.

    Regards,

    ReplyDelete
  2. After editing oratab, it is now working fine. Many thanks!

    ReplyDelete
  3. worked fine with your solution.
    Thanks a lot for this post.

    ReplyDelete
  4. where is this oratab file. I'm installing oracle 12c.
    Thanks in advance

    ReplyDelete
  5. verry helpfull for me... thanks.

    ReplyDelete