SID is already exist

I tried to create database, but I've got an error message that "SID is already exist". 

Window OS:-

just remove old sid by

$ oradim -delete -sid sidname

ORADIM is an Oracle utility that exists only on Windows: you cannot use it on UNIX systems such as AIX.


Cause: You have probably previously created database with the same name and have removed it but the traces of it still remain 

Linux OS :-

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:

How to set the schema session limit in Oracle 23 AI Database.

  In Oracle, to set a session limit per schema (user)—i.e., control how many concurrent sessions a specific user can have. You use profiles ...