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: Richard Huntley <rhuntley_at_mindleaders.com>
Date: Fri, 28 Jun 2002 12:13:43 -0800
Message-ID: <F001.0048BCBD.20020628121343@fatcity.com>


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: Richard Huntley
  INET: rhuntley_at_mindleaders.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 - 15:13:43 CDT

Original text of this message

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