Re: svrmgrl question

Thanks for posting the final update.

: )

Pat.

Aaron wrote:

> 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 Mon May 08 2000 - 00:00:00 CDT