Delete SID
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Delete SID

  1. #1
    Join Date
    Nov 2003
    Posts
    48

    Question 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!

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    boot the box
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    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

  4. #4
    Join Date
    Nov 2003
    Posts
    5
    TRY this on command prompt:

    ORADIM -DELETE sidname;

    Sunil Bhutani
    Sunil Bhutani

  5. #5
    Join Date
    Nov 2003
    Posts
    48
    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!

  6. #6
    Join Date
    Mar 2003
    Posts
    38
    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

  7. #7
    "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
  •  


Click Here to Expand Forum to Full Width