I am using Windows 2000. I installed a Oracle database and then delete it. Then I installed a database once again using the same SID. But it is not allowed for me to use the same SID. What happen? What is missing when I delete the previous database? How can I delete the SID?
I'm stmontgo and I approve of this message
oradim -Delete SID
if i remember it right ..
otheriwse go ORACALE_HOME and type oradim it will show you the various options ..
Hacking the windows registry is yet another options..
TRY this on command prompt:
ORADIM -DELETE sidname;
I have tried it but
In the comand prompt, it displayed something I can't recognise. Like below:
Do I need to have some language setting?
Also, How can I know whether the SID is deleted and any command can show the list of SID I have?
Try to remove the SID which is already present from the Registry Editor from all the places, whereever you find the address of this Particular SID.
This will solve your problem and can be recreate the database afresh.
"oradim -delete -sid
" will remove the service that runs the instance.
If you search in the registry for keys like 'LEGACY%' you will see all kinds of crap including old oracle homes, services, the works. Delete these (it is safe to do this) and retry.
Click Here to Expand Forum to Full Width