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:

java.sql.SQLSyntaxErrorException: Access was denied to the user in MySQL 8.4.

 java.sql.SQLSyntaxErrorException: Access denied for user 'SIT'@'%' to database 'SIT' means the MySQL user SIT does ...