-
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!
-
I'm stmontgo and I approve of this message
-
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
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.
__________________________________
PVKDBA
-
"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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|