Delete SID

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?

Thanks!

boot the box

Hi

Try

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..

regards
Hrishy

TRY this on command prompt:

ORADIM -DELETE sidname;

Sunil Bhutani

I have tried it but
In the comand prompt, it displayed something I can't recognise. Like below:
DIM-00003: ░ùçùåùéùø|Ñóñ@¡ùõñ▐ùåùé

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?

Thanks!

Hi,

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.

-B