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:

    RacingForIndia said...

    Thanks a ton. This really helped.

    despot said...

    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?

    Ivana said...

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

    S m i t h a said...

    Thanks. That was really helpful!

    Uchi said...

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

    Anyway thanks again ! and keep writing ...

    Mell said...

    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!

    Mell said...

    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!

    Unknown said...

    Helped a lot!

    Thanx man!

    Dillon Coetzer said...

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

    Anonymous said...

    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?

    Unknown said...

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

    C:\Windows\prefetch\

    Rgds
    Geeta

    Unknown said...

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

    suguna said...

    Does the uninstallation notes work for MS Vista?

    Unknown said...

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

    S G said...

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

    Wilson said...

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

    Mostafa Salem. said...

    thanks alot

    Surendran R said...

    Thank you!!

    Mahmoud Abdelaziz said...

    Thanks a lot.

    Bill Menees said...

    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

    Unknown said...

    Thanks a lot. It really helped

    Unknown said...

    Thanks a lot. It really helped.

    priya said...

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

    AB said...

    thanks a lot for providing such a usefull information.

    Unknown said...

    Truly nice work. It really helped me

    Anonymous said...

    really helpfull. thanx

    Cocoon said...

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

    Dharmendra Maharshi said...

    Thanks a lot
    its really very helpful..

    Unknown said...

    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.

    vivekbharathi said...

    Thanks a lot !! was useful

    krakaj said...

    thx mate !

    Anonymous said...

    Nice one. Thank you for the help!

    Anonymous said...

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

    jayfla said...

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

    alagu said...

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

    paras said...

    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

    paras said...

    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

    Anonymous said...
    This comment has been removed by a blog administrator.
    Yasmine M. Gaber said...

    Thanks a lot. It was really helpful.

    Anonymous said...

    You are the man...
    Thanks,
    Abrar

    Unknown said...

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

    Tony G said...

    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.

    Unknown said...

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

    ss said...

    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.

    kherien said...

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

    Bubu said...

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

    keshav reddy said...

    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

    jg said...

    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!

    Unknown said...
    This comment has been removed by the author.
    Unknown said...

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

    Unknown said...

    Thanks To All.

    Betty said...

    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

    Betty said...

    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

    siddaram said...

    thank you sir..........

    Unknown said...

    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)

    WOWGuyz said...

    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

    WOWGuyz said...

    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

    WOWGuyz said...

    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

    WOWGuyz said...

    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

    WOWGuyz said...

    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

    WOWGuyz said...

    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

    WOWGuyz said...

    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

    WOWGuyz said...

    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

    WOWGuyz said...

    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.

    WOWGuyz said...

    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!

    WOWGuyz said...

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

    WOWGuyz said...

    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.

    WOWGuyz said...

    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!

    WOWGuyz said...

    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.

    WOWGuyz said...

    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!

    WOWGuyz said...

    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!

    WOWGuyz said...

    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.

    WOWGuyz said...

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

    WOWGuyz said...

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

    WOWGuyz said...

    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.

    WOWGuyz said...

    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.

    WOWGuyz said...

    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.

    WOWGuyz said...

    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!

    WOWGuyz said...

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

    Unknown said...

    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

    Oceanapart Technologies said...

    appreciated your efforts.
    Computer software | technical support | software install or uninstall | Computer training