Error: The database SID you have specified,orcl, is Already present on this Host. Please specify a SID that is unique on this Host

When we create the database with the same name we are creating he below error.

Error: The database SID you have specified,orcl, is Already present on this Host. Please specify a SID that is unique on this Host

                                             

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

  • January 15, 2017 | 13 views
  • Comments