Re: svrmgrl question

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 Received on Wed Mar 29 2000 - 00:00:00 CST