DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, January 15, 2017

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

No comments: