Thanx for valueble information.It's working fine now.
Regards,
Anand.
-----Original Message-----
[EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 7:00 AM
To: Multiple recipients of list ORACLE-L
If you're on NT/2000 you'll have to edit the registry, make sure you're not
using terminal services, and about 42 other things I discovered about
Windoze this past weekend. I've reproduced a little checklist novicedba
posted here a while ago that helped me clean out my 4 installs. You MUST
install from the server or terminal services console. The install MUST
have gone through to completion. You MAY have to delete and recreate your
tnsnames.ora file due to unspecified corruption (Oracle Note). You CAN'T
use svrmgrl from a machine other than the server as the bequeath protocol
doesn't function properly on NT/2000 over the network. You SHOULD be on
UNIX. I don't like this NT/2000 for much of anything besides test stuff.
We're putting a 6,000 user app on it an I don't feel very good today. Oh
yeah, you're going to have problems with the listener too. And if you have
written a .bat file since the late '80s, brush up on your DOS commands.
Gee this is fun.
Hi,
We run our databases on NT and we face this problem once in a while. For
the
benefit of our consultants working on the client side I had prepared a
document.
This has worked perfectly for me as well as for our consultants on the
client side.
I am aware that the present problem is removing one version of Oracle and
not cleaning up the entire oracle installation. My document deals with
removing all oracle products or as the heading says clearing up the system
(of ORALCE?)
============================================================================
=================================
Clearing up the System after an incomplete or improper installation of
Oracle
----------------------------------------------------------------------------
-
Database Installation involves a set of procedures which need to be
followed
in order to have a proper working installation. If we follow these
procedures the Installation will be fine and usually problems related to
improper installation do not arise. But it is not always possible to get a
proper installation for the first time. This document is a troubleshooting
guide which would help to clear off the mess created by an improper
installation in a WindowsNT system.
First we need to know that During installation Oracle writes into certain
directories (which we would have specified during installation) and also
into the WindowsNT registry. WindowsNT registry is a repository of
information about all the installed products and configurations on that
system. When we are installing Oracle a directory is created in the
registry
which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/
In the case of an improper installation the problems faced are
· We may not be able to uninstall the incomplete installation
· We may succeed in uninstalling the incomplete installation but yet face
problems with WindowsNT Services.
· Every time we log into WindowsNT we may get an error 'at least one system
service failed to start' which may be an Oracle service from the earlier
installation.
· We may get an error while creating a database 'the database with the name
you specified already exists please chose another name' which again may be
attributed to an improper un-installation.(I am not pretty comfortable
with
the Oracle's Un-installation utility because I feel it does not uninstall
everything)
Keeping the above points in mind it would be better if we know where
exactly
to look in case we are faced with such problems. When oracle is installed
it
makes entries in the following places
1. The first and the foremost- the directory in which we install the Oracle
database (say D:\Ora8i)
2. The second is the inventory it maintains in the directory c:\program
files\oracle
3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry
4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there
are three nodes controlset1,controlset2 and currentcontrolset. These nodes
in turn have 4 nodes out of which 2 are important to us. They are Enum and
Services. The Enum node has got two nodes out of which the 'root' node is
of
great interest to us because it stores details about all the services that
are running on a WindowsNT system. The other node of interest from the
controlsets is Services. The services node has got a list of services
running on a WindowsNT system.
In case we need to clean up the system after an incomplete installation we
can follow the following steps
Delete the home directory where Oracle is installed
Delete the folder C:\program files\oracle Note:- This clears off
information
about any other Oracle utility installed on that system.
Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This
clears off information about any other Oracle utility installed on that
system and you may not be able to run those programs again.
Delete the Oracle Related services from
HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with
a
prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke
registry editor and not regedit. You will have to use the security menu and
give permissions to yourself before deleting these entries. Else it will
not
work . It is to be noted that there are three control sets and all the
three
(in reality any 2) need to be cleared off these un-necessary entries.
Delete the Oracle Related services from
HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/SERVICES . They will have a prefix
'Oracle'.
============================================================
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Anand"
<karhadkar@rol To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
ta.com> cc:
Sent by: Subject: Urgent
[EMAIL PROTECTED]
om
08/01/2001
01:02 PM
Please respond
to ORACLE-L
Hi Guru's,
I was having Oracle 8.1.6 Server on my server initially.Due to some reason
I
deinstalled it.
But after installing it again,after installation i am not able to start
'SVRMGRL'
It's giving me error ORA-12560 TNS:protocol adapter error.So i can't up my
database.
can anybody help me.
Thanks in advance.
Regards,
Anand
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
