Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to drop a database?

Re: how to drop a database?

From: Van Messner <vmessner_at_bestweb.net>
Date: Thu, 25 Oct 2001 21:46:18 -0400
Message-ID: <tthgbbggaajq1a@corp.supernews.com>


8189

Removing Oracle from NT.
1) First run the installer and allow it to uninstall anything that it can. If the installer itself won't run see if you have a version earlier than around January of 2000. Those versions are non-Y2K compliant and will no longer work. Follow the rest of the instructions but be aware you'll need a compliant installer to install anything after you have wiped out the old Oracle pieces.

2) In ControlPanel/Services shut down all the Oracle services and set them to disabled.

3) Go to any Oracle folders and put everything into the trash that you can.  (Remember to check your C drive - Oracle puts things there even if you install to another drive)

4) Clean out the registry. Some people like to back up the registry first. I use regedit for this work. Under the edit menu choose find and check the boxes for keys and values only. Where it says find what put in the letters ora. Press find next. You will get everything relating to Oracle that you need to get rid of. You will also get anything else that has the letters ora in it - Eudora, storage, etc. Get rid of everything you can identify as Oracle (except the Microsoft Oracle odbc keys). If you have any doubts, and there are very few ambiguous cases, then leave the key or value alone. I delete the Oracle keys and leave the Oracle values but set them to an empty string instead of whatever Oracle information they contained. Oracle will also appear in Microsoft's legacy keys which you are not permitted to delete. Don't worry about these. After you have worked through the registry go back and start over with find. This time uncheck keys and values and check data. There will be a lot fewer hits this time through. Note that values which have to do with environmental settings such as PATH and CLASSPATH may have information in them for both Oracle and other applications. Remove just the parts that have to do with Oracle.

5) If there were any Oracle folders you could not get rid of in step 3, try again. You may still not be able to trash everything.

6) Reboot. Now you should be able to trash any pieces that were left over and you should see no Oracle services remaining. Check your environmental variables. They too should be Oracle free.

7) You are ready for a clean new install. "Yifat" <zorakani_at_hotmail.com> wrote in message news:61f7b40c.0110250922.243681de_at_posting.google.com...
> How drop I drop a database in NT?
>
> I can only mount the database but not open it.
>
> Thanks.
Received on Thu Oct 25 2001 - 20:46:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US