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
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
Thanks for pointing this out.
ReplyDeleteRegards,
After editing oratab, it is now working fine. Many thanks!
ReplyDeleteGlad it helped
Deleteworked fine with your solution.
ReplyDeleteThanks a lot for this post.
where is oratab please help me
Deletewhere is this oratab file. I'm installing oracle 12c.
ReplyDeleteThanks in advance
Default location on Unix is /etc/oratab
Deleteverry helpfull for me... thanks.
ReplyDeletewhere is oratab
ReplyDeleteThanks for your help, great post.
ReplyDeleteTHANK YOU!
ReplyDeleteResolved my issue. I was also getting sid already exist.Thanks
ReplyDelete