Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g5T7NtI11489 for ; Sat, 29 Jun 2002 03:23:55 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id QAA59039; Fri, 28 Jun 2002 16:15:36 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0048BF0A; Fri, 28 Jun 2002 14:38:22 -0800 Message-ID: Date: Fri, 28 Jun 2002 14:38:22 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Michael P Sale" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Michael P Sale" Subject: RE: Uninstall 9i DB Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001E_01C21EB9.4C8D8000" ------=_NextPart_000_001E_01C21EB9.4C8D8000 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Friday, June 28, 2002 10:38 AM 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 ------=_NextPart_000_001E_01C21EB9.4C8D8000 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
On=20 windows you also need to delete the db service as well. In the registry = delete=20 the key for the db. Something like "OracleServiceORCL" where ORCL is = your db's=20 SID. You'll find the key in the following=20 location:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services<= /SPAN>
 
 

Regards,

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

-----Original Message-----
From: = root@fatcity.com=20 [mailto:root@fatcity.com] On Behalf Of Richard = Huntley
Sent:=20 Friday, June 28, 2002 2:14 PM
To: Multiple recipients of = list=20 ORACLE-L
Subject: RE: Uninstall 9i DB

Ken,
 
How=20 about changing the services for both DBs to MANUAL start instead of = automatic,=20 bouncing (reboot) the XP box.  At that point, no DBs will be up, = you=20 can
delete the datafiles, param. file, control = file(s),=20 etc...from the DB you don't want, then just startup the demo DB and = you're=20 down to one DB.  Logging into the DB
to=20 find the location of the files shouldn't be necessary as you created = the DB,=20 right (so you'd have some method to the madness of where physical Db=20 objects
reside)?
 
-----Original Message-----
From: KENNETH JANUSZ=20 [mailto:kjanusz@att.net]
Sent: Friday, June 28, 2002 3:24=20 PM
To: Multiple recipients of list = ORACLE-L
Subject: Re:=20 Uninstall 9i DB

Melissa:
 
Nice idea but I can't logon to either of my = DB's.  So=20 that is why I am deinstalling the second one so I can get back to the = original=20 setup with just the demo DB.  Then hopefully I can logon to at = leas the=20 demo DB. 
 
Thanks,
 
Ken
----- Original Message -----
From:=20 Godlewski, Melissa =
Sent: Friday, June 28, 2002 = 10:38=20 AM
Subject: RE: Uninstall 9i = DB

Ken,
 
Select file_name from dba_data_files and = filename=20 from dba_temp_files for database files to drop off your hard = disk. =20 This will give you a list of files to delete manually if your not = using the=20 Oracle Manage files (OMF).  Remove the ora process from the = startup=20 menu also, so the instance won't start. 
 
Check the init.ora for = any directories to=20 remove.  Check the alert log file location and remove the = alert.log as=20 well as the directory.
 
select * From v$parameter and look for = the control=20 files and redo log files to remove off the hard disk.  You will = also=20 want to remove the init.ora and spfile if you created=20 one.
 
 
 
-----Original Message-----
From: KENNETH JANUSZ = [mailto:kjanusz@att.net]
Sent: Friday, June 28, 2002 = 10:28=20 AM
To: Multiple recipients of list = ORACLE-L
Subject:=20 Uninstall 9i DB

I have 9.0.1 installed on my Dell 8200 using = XP=20 Prof.   Not networked.
 
I have two DB installed on this machine and I = want to=20 uninstall one of them.
 
I will use Oracle's Universal Installer to = de-install=20 the software.
 
What else should I be doing to make this work=20 properly?  I want to keep the demo DB only.
 
Thanks,
Ken=20 Janusz
------=_NextPart_000_001E_01C21EB9.4C8D8000-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael P Sale INET: Michael.Sale@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@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).