Re: svrmgrl question

From: Aaron <asentell_at_my-deja.com>
Date: 2000/03/29
Message-ID: <8bt772$16q$1@nnrp1.deja.com>#1/1

Billy,

Thanks for your help. Your suggestions pointed me in the right direction -- the registry. In case you're interested, here's what I had to do (from documentation I wrote this morning)...

Correcting problems with using svrmgrl on NT:

---

In order for svrmgrl to work, the OracleService<SID> service must be started. However, this service by default also creates an instance and mounts the database, not an ideal setting when a database needs to be recovered. To prevent this service from automatically creating the instance and mounting the database when it is started, change the following registry entry:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx\ORA_<SID>AUTOSTART from "TRUE" to "FALSE"

In this way, when the service is started, the instance is not created nor the database mounted giving the dba freedom to recover the database as needed. See "Appendix C: Oracle 8i Configuration Parameters and the Registry" in "Oracle8i Enterprise Edition for Windows NT Getting Started Release 8.1.5 for Windows NT" for more information about registry settings.

Aaron

In article <8bshi2$3rs$1_at_ctb-nnrp1.saix.net>, "Billy Verreynne" <vslabs_at_onwe.co.za> wrote:
> Aaron wrote in message <8br8e7$sfm$1_at_nnrp1.deja.com>...
> >I'm new to Oracle and have a question. I've installed Oracle 8i on my
> >NT workstation, including Net8. When I type svrmgrl at the command
> >line and try to startup the instance, I get the following messages:
> >---------------------------------------------------------------------
 -
> >C:\>svrmgrl
> >Oracle Server Manager Release 3.1.5.0.0 - Production
> >(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
> >ORA-12560: TNS:protocol adapter error
> >SVRMGR> startup;
> >LCC-00161: Message 161 not found; product=RDBMS; facility=MGR
> >ORA-12560: TNS:protocol adapter error
> >SVRMGR>
> >---------------------------------------------------------------------
 -
>
> My guess is that the ORACLE_SID environment variable is not, or set
> incorrectly in that NT shell, resulting in the above error. In
 addition, it
> seems that the ORACLE path is also missing as it is not picking up
 the right
> message file.
>
> Try:
> C:\> set ORACLE_SID=<your database's system id>
> C:\> svrmgrl
> SVRMGR> startup;
> .. etc..
>
> If this does work, you may want to set the ORACLE_SID (and other
 ORACLE
> environment variables) globally as part of the NT environment. Use the
> environment variables option in MY COMPUTER|PROPERTIES|ENVIRONMENT.
>
> regards,
> Billy
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 29 2000 - 00:00:00 CST