Tuesday 8 November 2016

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


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

No comments:

Post a Comment