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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Uninstall 9i DB

RE: Uninstall 9i DB

From: Michael P Sale <Michael.Sale_at_oracle.com>
Date: Fri, 28 Jun 2002 14:38:22 -0800
Message-ID: <F001.0048BF0A.20020628143822@fatcity.com>


On windows you also need to delete the db service as well. In the registry delete the key for the db. Something like "OracleServiceORCL" where ORCL is your db's SID. You'll find the key in the following location:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services    

Regards,

Michael Sale
Consulting Technical Specialist
PLBDE
Oracle Corporation
Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626

-----Original Message-----

Huntley
Sent: Friday, June 28, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L

Ken,  

How about changing the services for both DBs to MANUAL start instead of automatic, bouncing (reboot) the XP box. At that point, no DBs will be up, you can
delete the datafiles, param. file, control file(s), etc...from the DB you don't want, then just startup the demo DB and you're down to one DB. Logging into the DB
to find the location of the files shouldn't be necessary as you created the DB, right (so you'd have some method to the madness of where physical Db objects
reside)?  

-----Original Message-----

Sent: Friday, June 28, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L

Melissa:  

Nice idea but I can't logon to either of my DB's. So that is why I am deinstalling the second one so I can get back to the original setup with just the demo DB. Then hopefully I can logon to at leas the demo DB.  

Thanks,  

Ken

Ken,  

Select file_name from dba_data_files and filename from dba_temp_files for database files to drop off your hard disk. This will give you a list of files to delete manually if your not using the Oracle Manage files (OMF). Remove the ora process from the startup menu also, so the instance won't start.  

Check the init.ora for any directories to remove. Check the alert log file location and remove the alert.log as well as the directory.  

select * From v$parameter and look for the control files and redo log files to remove off the hard disk. You will also want to remove the init.ora and spfile if you created one.      

-----Original Message-----

Sent: Friday, June 28, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L

I have 9.0.1 installed on my Dell 8200 using XP Prof. Not networked.  

I have two DB installed on this machine and I want to uninstall one of them.  

I will use Oracle's Universal Installer to de-install the software.  

What else should I be doing to make this work properly? I want to keep the demo DB only.  

Thanks,
Ken Janusz

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael P Sale
  INET: Michael.Sale_at_oracle.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Fri Jun 28 2002 - 17:38:22 CDT

Original text of this message

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