Database name already exists
Running 18.104.22.168 on NT4
Created a DB using the DB Configuration Assistant, then deleted it with same.
I've checked and it has deleted:
All reference to any datafiles created.
All references in the registry.
However, when I try to create another DB with the same name I get an error that the name is in use by an existing DB.
Where else can I look to find references to this DB and delete them as I need to use this name.
>>However, when I try to create another DB with the same name I get an error that the name is in use by an existing DB.
Are you getting the error with the Configuration Assistant?
If so, you just need to go out and delete the FOLDERS that the config assistant created for you.
So if you created a db called FRED, go out and delete all the FRED folders. I believe they are located in the ORACLE_HOME directory.
Not a very techy reason !!!!
When you create a new DB you're prompted for a location for the pfile.
The first time I did it - it creates a folder in NT for the parameter file.
When you try the 2nd time, it realises the folder already exists and assumes that the database also exists.
I renamed the NT folder and could then create the DB again.
Make sure that all entries in the registry are deleted.
1. From Dos prompt regedit- HKEY_LOCAL_MACHINE then SOFTWARE Delete all entries regarding to the deleted Database.
2. From Dos prompt regedit- HKEY_LOCAL_MACHINE then SYSTEM -CurrentControlSet- Services .Delete all the services about deleted database.
In addition to sri_purna's contribution, delete all oracle related files/folders from the registry. Shutdown and restart.
Playing with registry might cost u very much.......
Be sure wat u r deleting in registry.....
Before u delete try checking this in registry.....
ckeck if u still have the ORACLE_SID set as ur DB name in this path.
also remove from environmental variables if Oracle_SID was set......
check if the OracleServiceYOUR_DB_Name still exists in the services.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Click Here to Expand Forum to Full Width