Sunday, August 14, 2005

Uninstalling Oracle 10g Manually from Windows XP

Oracle's installation utility has a nasty habit of leaving a lot of items behind.  I wrote this up to document what I've found you need to do to uninstall Oracle 10g manually.  This is specific to 10g and Windows XP.  Removing 9i is very similar if I remember right, but who's using 9i anymore? ;-)

The first thing you should do, is go ahead and run the installation tool to do an uninstall.  It probably will leave some things behind, but it's worth running.  Then go through this list and remove anything it missed.  This list is detailed enough though, that I believe even if you did not run the uninstallation tool, this would fully uninstall Oracle.

The most commonly missed item is to make sure you remove everything from the GAC because the uninstaller doesn't appear to.  I get to that later, but if you wanted to know the largest source of uninstallation problems, it's libraries remaining in the GAC.

After running the supplied Oracle uninstallation utility (which may or may not do some or all of the following):

  • Stop any Oracle services that have been left running.
    Start->Settings->Control Panel->Services
    Look for any services with names starting with 'Oracle' and stop them.

  • Run regedit and delete the following keys (some may have slightly different names in your registry):
    HKEY_CURRENT_USER\SOFTWARE\ORACLE
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\Oracle.oracle
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleDBConsole
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle10g_home
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OraclService

    Note that the services control panel will still show the old services until you reboot.

  • Delete the Oracle home directory
    C:\Oracle

  • Delete the Oracle Program Files directory:
    C:\Program Files\Oracle

  • Delete the Oracle Start Menu shortcuts directory:
    C:\Documents and Settings\All Users\Start Menu\Programs\Oracle*
    Where * indicates the name of your install.  Look for and remove all Oracle directories from that location.

  • Remove Oracle refereces from the path.  To edit your path go to:
    Start->Settings->Control Panel->System->Advanced->Environment Variables
    Edit both of the environment variables user PATH and system PATH.  Remove any Oracle references in them.

  • Remove Oracle.DataAccess and any Polic.Oracle files from the GAC which is at:
    C:\Windows\assembly\



  • There, now your system is Oracle free.  If you are installing a new instance of Oracle (and not just an additional DB) I recommend you do this before any new Oracle installation.
    Note: I used several other websites and searches as references when developing these steps, but I was unable to find any steps that covered all of the items for Oracle 10g so I assembled them here.

    81 comments:

    1. Thanks a ton. This really helped.

      ReplyDelete
    2. Thanks for the help!!! I've done what you said and it worked. I just ran into one problem: I can't delete the oci.dll (Oracle Call Interface) in C:\oracle\product\10.2.0\db_1\BIN directory. Do you have some tip for this?

      ReplyDelete
    3. thank you for writing these instructions. they are very helpful.

      ReplyDelete
    4. Thanks. That was really helpful!

      ReplyDelete
    5. Thanks but most of the things were already removed after running the deinstallation.

      Anyway thanks again ! and keep writing ...

      ReplyDelete
    6. I had to delete quite a few more registry items before I could delete the C:\Oracle folder, but you put me on the right track.
      Thank you, what a helpful post!

      ReplyDelete
    7. I had to delete quite a few more registry items before I could delete the C:\Oracle folder, but you put me on the right track.
      Thank you, what a helpful post!

      ReplyDelete
    8. Helped a lot!

      Thanx man!

      ReplyDelete
    9. Thanks for the article - you saved me loads of time!

      ReplyDelete
    10. Anonymous4:09 PM

      Hi,
      I tried this but one file in OraHome_1 folder is not deleting. File name is oci.dll when I tried to delete manually, it gives some error. Called Write disk full, file is in use, blah blah....
      Can you help me with this?

      ReplyDelete
    11. Hi..
      I was following the notes given and in the last found its not "C:\Windows\assembly\"
      but

      C:\Windows\prefetch\

      Rgds
      Geeta

      ReplyDelete
    12. The reason I deleted the Oracle DB is to reinstall it. However, after I installed it again, something behaved really strange. The DB should be be automatically star-up, but it did not. I tried to start the DB, it just kept complaining that I gave wrong credential though everything I typed in was correct. Help!!!

      ReplyDelete
    13. Does the uninstallation notes work for MS Vista?

      ReplyDelete
    14. Thanks its been really helpful; even on vista; but i cant stop the Oracle.DataAccess, any views on this

      ReplyDelete
    15. Thanks a lot. That helped me fix some installation issues with 10g. You rock!!

      ReplyDelete
    16. you really helped me to fix my problem...keep rocking

      ReplyDelete
    17. On a 64-bit system, you should also delete the following registry key if you installed the 32-bit Oracle client:

      HKEY_LOCAL_MACHINE\Software\Wow6432Node\Oracle

      ReplyDelete
    18. Thanks a lot. It really helped

      ReplyDelete
    19. Thanks a lot. It really helped.

      ReplyDelete
    20. thanks alot
      its really work . i was trying to install 11g and its helps me a lot to uninstall 10g.thanks a lot

      ReplyDelete
    21. thanks a lot for providing such a usefull information.

      ReplyDelete
    22. Truly nice work. It really helped me

      ReplyDelete
    23. Anonymous12:26 AM

      really helpfull. thanx

      ReplyDelete
    24. Hi, Thanks. Very helpful.

      But I still couldn't uninstall 11 items still stuck in C:\Windows\Assembly\. Access denied.

      I have to use safe mode now cos' after I've installed on Vista Biz, my C drive was frozen and became inaccessible. Each time I used program or internet, error message kept popping up saying "Temp file creation failed" or "Browser memory full".

      I couldn't change the alloted memory for temp files in Tools >> Internet options >> Browsing history >> Settings >> Dispace to use >> ...MB

      Somebody help me out???

      ReplyDelete
    25. Thanks a lot
      its really very helpful..

      ReplyDelete
    26. i have done all the steps that you told me except that. i cannot locate the c:\windows\assembly folder.

      also, before i installed oracle i had 17.8 of free space.
      now, after uninstalling it and following the steps. i only have 17.2 of free space. so there is about 600mb of missing space. this also happened to me with the 9i version.

      ReplyDelete
    27. Thanks a lot !! was useful

      ReplyDelete
    28. Anonymous2:35 AM

      Nice one. Thank you for the help!

      ReplyDelete
    29. Anonymous3:34 AM

      It's such a pain uninstalling Oracle 10g. Thanks for this, it was very helpful. =)

      ReplyDelete
    30. Hey Aric. thanks for the posting on the removal of Oracle from the computer. Saved me a lot of problems. You're a lifesaver.

      ReplyDelete
    31. Thank you so much! Its an amazing remedy which solved hell of a problem. Once again thanks and I appreciate your knowledge.

      ReplyDelete
    32. Dear Aric's

      The best thing about you blog instruction on uninstalling the Oracle 10g is that they are complete. There is nothing missing in it. Most of the instructions in regards to the oracle 10g are incomplete by other authors. I needed on more. To install oracle 10g database and developer suite along with patch on Vista 32 bit. Can you do that with screen shots.

      regards
      and thanks paras

      ReplyDelete
    33. Dear Aric's

      The best thing about you blog instruction on uninstalling the Oracle 10g is that they are complete. There is nothing missing in it. Most of the instructions in regards to the oracle 10g are incomplete by other authors. I needed on more. To install oracle 10g database and developer suite along with patch on Vista 32 bit. Can you do that with screen shots.

      regards
      and thanks paras

      ReplyDelete
    34. Anonymous2:18 AM

      This comment has been removed by a blog administrator.

      ReplyDelete
    35. Thanks a lot. It was really helpful.

      ReplyDelete
    36. Anonymous1:16 PM

      You are the man...
      Thanks,
      Abrar

      ReplyDelete
    37. Thank You so much !! It saved me a lot of time :)

      ReplyDelete
    38. That was a really detailed and useful post! I have come across a number of posts on the same subject but none as detailed as this. I have bookmarked this page and shall post a link to it on my soon-to-be-launched websites as well.

      Keep up the good work.

      ReplyDelete
    39. Thank you tons....saved my time.. i can only think of formatting my whole system before this. Thanks so much

      ReplyDelete
    40. Thanks a lot. This was really helpful.

      For the people who are having problems with deleting oci.dll restart your machine after doing all the deletes and you should now be able to delete the folder C:\Oracle without any errors.

      ReplyDelete
    41. If you did everything as described and still can't remove oci.dll, and are running apache server, turn it off and try again.

      ReplyDelete
    42. to delete oci.dll :
      stop the "Distributed Transaction Coordinator" service and delete the DLL. Restart the service.

      ReplyDelete
    43. Remove Oracle.DataAccess and any Polic.Oracle files from the GAC which is at:
      C:\Windows\assembly\


      hey above step i'm unable to complete .. access denied warning is coming when i'm trying to uninstall

      ReplyDelete
    44. Hallelujah! Used your instructions to uninstall 9 on an old Windows 2000 machine. Had to restart the machine after first steps in order to FINALLY delete the last remnants. Much appreciated!

      ReplyDelete
    45. This comment has been removed by the author.

      ReplyDelete
    46. After wasting 5hrs of my life before finding these instructions...THIS ACTUALLY WORKED FOR VISTA!!! Thank you!

      ReplyDelete
    47. I had to delete Oracle from my system so as to install the newer version. I followed all the steps and uninstalled it without facing difficulty. Last time when I uninstalled the older version lots of things remained in my system so was looking for the exact steps that will do this process properly. Thanks for sharing the whole process step by step.
      sap support pack

      ReplyDelete
    48. I had to delete Oracle from my system so as to install the newer version. I followed all the steps and uninstalled it without facing difficulty. Last time when I uninstalled the older version lots of things remained in my system so was looking for the exact steps that will do this process properly. Thanks for sharing the whole process step by step.
      sap support pack

      ReplyDelete
    49. thank you sir..........

      ReplyDelete
    50. This still works for 11g on Windows Server 2008 R2 - at least for a guide. Some of the locations are different, but aren't difficult to figure out. (2012-08-01)

      ReplyDelete
    51. Anonymous1:59 AM

      Diablo 3 http://d3.gameguyz.de
      Diablo 3 Video http://d3.gameguyz.de/videos.html
      Diablo 3 Bilder http://d3.gameguyz.de/pictures.html
      Diablo 3 News http://d3.gameguyz.de/news.html

      ReplyDelete
    52. Anonymous2:01 AM

      WOW Pandaria http://wow.gameguyz.de/
      Mists of Pandaria http://wow.gameguyz.de/news/all.html
      World of Warcraft Wallpaper http://wow.gameguyz.de/pictures
      World of Warcraft Video http://wow.gameguyz.de/videos/videos.htm

      ReplyDelete
    53. Anonymous2:15 AM

      Dota2 Artwork http://dota2.gameguyz.de/bilder.html
      Dota2 Video http://dota2.gameguyz.de/video.html
      Dota2 Forum http://dota2.gameguyz.de
      Dota 2 Release http://dota2.gameguyz.de/news.html

      ReplyDelete
    54. Anonymous2:15 AM

      LoL S3 http://lol.gameguyz.de
      LoL S3 Masteries http://lol.gameguyz.de/news.html
      LoL Champions http://lol.gameguyz.de/champions.html
      League of Legends Cosplay http://lol.gameguyz.de/bilder.html

      ReplyDelete
    55. Anonymous2:16 AM

      Guild Wars 2 http://gw2.gameguyz.de
      Guild Wars 2 News http://gw2.gameguyz.de/news.html
      Guild Wars2 Fan Art http://gw2.gameguyz.de/bilder.html
      Guild Wars2 Videos http://gw2.gameguyz.de/videos.html

      ReplyDelete
    56. Anonymous2:18 AM

      Blade and Soul News http://bns.gameguyz.de
      Blade and Soul Skills http://bns.gameguyz.de/news/news.html
      Blade and Soul Guide http://bns.gameguyz.de/strategien/strategien.html
      Blade and Soul Artwork http://bns.gameguyz.de/bilder/bilder.html

      ReplyDelete
    57. Anonymous2:18 AM

      Starcraft 2 http://sc2.gameguyz.de/
      Starcraft 2 Heart of the Swarm http://sc2.gameguyz.de/artikel.html
      Starcraft 2 GSL http://sc2.gameguyz.de/videos.html
      Starcraft 2 Comics http://sc2.gameguyz.de/bilder.html

      ReplyDelete
    58. Anonymous2:19 AM

      besten mmorpg Spiele http://www.gameguyz.de/
      Spiele News 2013 http://www.gameguyz.de/news.html
      top Game 2013 http://www.gameguyz.de/spielliste.html
      Game Cosplay http://www.gameguyz.de/bilder.html

      ReplyDelete
    59. Anonymous2:20 AM

      Seid ihr auf der Suche nach Diablo 3? Geile Diablo 3 Video, schöne Diablo 3 Bilder und die neueste Diablo 3 News könnt ihr bei Diablo 3 Fanseite finden.

      ReplyDelete
    60. Anonymous2:21 AM

      Hey, Leute! Ich habe viele schöne World of Warcraft Wallpaper und geile World of Warcraft Video gesammelt. WOW Pandaria ist am meisten. Natürlich ist Mists of Pandaria mein Best!

      ReplyDelete
    61. Anonymous2:22 AM

      Hey, Leute! Ich bin ein Fan von Dota 2. Habt ihr schöne Dota 2 Artwork, tolle Dota 2 Video und die neueste News von Dota 2 Release? Dann können wir sie beim Dota 2 Forum diskutieren..

      ReplyDelete
    62. Anonymous2:22 AM

      Wisst ihr alle News von LoL S3, LoL S3 Masteries und LoL Champions? Alles könnt ihr bei der LoL Webseite finden und da gibt es das schöne League of Legends Cosplay.

      ReplyDelete
    63. Anonymous2:23 AM

      Hallo, Guild Wars 2Fans! Ich habe eine offizielle Webseite gefunden. Da gibt es die neueste Guild Wars 2 News, Guild Wars 2 Videos und die cooleste Guild Wars 2 Fan Art!

      ReplyDelete
    64. Anonymous2:25 AM

      Ich habe Starcraft 2 schon lang gespielt. Alles News von Starcraft 2 Heart of the Swarm und Starcraft 2 GSL beachte ich. Und die Starcraft 2 Comics sammle ich gerne.

      ReplyDelete
    65. Anonymous2:25 AM

      Welche sind die besten mmorpg Spiele in top Game 2013? Wollt ihr die neueste Spiele News 2013 und Game Cosplay wissen? Alles sind bei Gameguyz!

      ReplyDelete
    66. Anonymous2:28 AM

      Hier haben wir ein paar tolle Diablo 3 Video, wunderschöne Diablo 3 Bilder und die neueste Diablo 3 News aus dem Web zu Diablo 3 zusammengestellt. In der Übersicht findet ihr generelle Guides zum Spiel!

      ReplyDelete
    67. Anonymous2:28 AM

      Ich bin ein Fan von Mists of Pandaria. Ich habe viele schöne World of Warcraft Wallpaper und kostenlose World of Warcraft Video gesammelt. WOW Pandaria ist sehr viel.

      ReplyDelete
    68. Anonymous2:29 AM

      Bei der Fanseite Dota 2 Forum können wir die neueste Dota 2 Artwork, Dota 2 Video und News von Dota 2 Release teilzunehmen.

      ReplyDelete
    69. Anonymous2:30 AM

      Wisst ihr die neueste Information von LoL S3 Masteries und LoL Champions in LoL S3? Ich mag das schöne League of Legends Cosplay.

      ReplyDelete
    70. Anonymous2:30 AM

      Ich glaube, dass Guild Wars 2 beliebter in der Welt wird. Ich habe eine neue Webseite von Guild Wars 2 News gefunden. Da gibt es coole Guild Wars 2 Fan Art und Guild Wars 2 Videos.

      ReplyDelete
    71. Anonymous2:32 AM

      Ich glaube, dass Guild Wars 2 beliebter in der Welt wird. Ich habe eine neue Webseite von Guild Wars 2 News gefunden. Da gibt es coole Guild Wars 2 Fan Art und Guild Wars 2 Videos.

      ReplyDelete
    72. Anonymous2:33 AM

      Das neueste beliebte Spiel ist BNS. Es ist sehr interessant und wunderschön. Bei mir könnt ihr offizielle Blade and Soul News, Blade and Soul Skills, lustige Blade and Soul Artwork und die neueste Blade and Soul Guide bekommen.

      ReplyDelete
    73. Anonymous2:33 AM

      Bei der Starcraft 2 Fanseite gibt es die neueste News von Starcraft 2 Heart of the Swarm, offzielle Starcraft 2 GSL und gute Starcraft 2 Comics. Versuch einfach mal!

      ReplyDelete
    74. Anonymous2:34 AM

      Wollt ihr die neueste Spiele News 2013, das top Game 2013, die besten mmorpg Spiele und das neueste Game Cosplay wissen? Klick einfach mal!

      ReplyDelete
    75. Thanks for Information Oracle 10g/11g Database Administration In this course, you will explore how an Oracle Database applies ‘grid computing’ to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. You will learn how to install, administer, and maintain an Oracle 10g or 11g database in an effective and efficient manner. You will cover the interaction among Oracle components, Oracle’s architecture, and user management. Performance monitoring, database security, and backup and recovery techniques are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.Oracle 10g / 11g DBA Online Training

      ReplyDelete