Removing Database from 9i on NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Removing Database from 9i on NT

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    Removing Database from 9i on NT

    I have 3 database running on NT and I would like to remove one of database. Can you tell me how to do this and what to look out for? If I just remove all the datafiles from Operating System, would it remove the database?

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    no, with NT you got to be clean on the service removal since it's a pain in the ... to do it later.

    stop the instance and use oradim : oradim -delete -sid my_instance

    check that the service OracleServiceMy_instance has been deleted, and you can then safely delete the datafiles.

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    To remove dead services from services do not play with the registry. Search for the "delsrv.exe" in the forum uploaded by one of the forum member. You can use this to delete the dead service.. It works quite fine for NT. Well this is not a real pro solution.. but it works out

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Sameer
    To remove dead services from services do not play with the registry. Search for the "delsrv.exe" in the forum uploaded by one of the forum member. You can use this to delete the dead service.. It works quite fine for NT. Well this is not a real pro solution.. but it works out
    Sameer:

    delsrv.exe the one u gave me?????...
    its pritty good....


    Abhay.
    funky...

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

  5. #5
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Yes, Though its not a real solution, fine as long as its works

  6. #6
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    In register:
    section --> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE --> delete all
    section --> HKEY_LOCAL_MACHINE\SOFTWARE\ODBC --> delete positions for Oracle (ORACLE, and ODBCINST.INI)
    section --> HKEY_LOCAL_MACHINE\SOFTWARE\Classes --> delete all positions with name Oracle
    section --> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services --> delete all Oracle services that
    still alive after oradim -delete
    section --> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application -->
    delete all positions with name Oracle
    section --> HKEY_CURRENT_USER \Software\ORACLE --> delete whole section

    system path (Control Panel-Environment-Path) remove Oracle\...\Bin,...\Program Files\Oracle\jre\1.1.7\bin

    delete all positions with name Oracle from Common Files\Odbc\Datasources

    I always glad to delete Oracle from Windows.

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by Shestakov delete all
    Shestakov,

    He will never see this forum again, he z talking about removing one SID outta 3 SIDs on NT.
    Reddy,Sam

  8. #8
    Join Date
    Jan 2003
    Posts
    141
    Hi sammer,
    Where can i fine the delsrv.exe in the forum..

    Thanks,

  9. #9
    Join Date
    May 2001
    Posts
    736
    Here it is

    Attachment :
    Attached Files Attached Files

  10. #10
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    Deinstalling Oracle Components and Services

    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

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