sqlplus /nolog can't manage instance

Hi, all

Because I didn't resolve the problem, so I repost it for help, sorry.

My server is Oracle 8.16+win2000 advance server. And I create a instance oratest. If I use service to start the service, the service can be started and sqlplus can login normally. But if the instance is not start up, and I use sqlplus /nolog to login，it will failed as below:

E:\NTDDK\src\general\portio>sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on 星期五 8月 9 19:49:59 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
ERROR：
ORA-12560: TNS: 协议适配器错误(adapter error)

SQL> connect sys/change_on_install as sysdba ERROR：
ORA-12560: TNS: 协议适配器错误(adapter error)

svrmgrl will get the same error. And I create another instance, it also is so.
It quite confused me.

And I think in this situation, the sqlplus know which instance it should connect to
and use Bequeath protocol to connect to oracle service and tnsname.ora is not used(I had try stop the listener service, and if the oracle instance is started, the sqlplus can connect to it).

And my question is: ORA-12560 error means the oracle instance is not started(?).
But while connect sys/change_on_install as sysdba under sqlplus /nolog condition,
it seems the instance need not has been started. Bacause in normal case, startup
commmand will be used to start the instance. So what may be the problem?

Another insteresting question is : since the instance has not been started, how the
username/password is verified? The sqlplus(svrmgrl) problem read the user table
itself? It seems be so, isn't it?

thanks,
PanTao

BTW: my registry setting is below:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"inst_loc"="D:\\Program Files\\Oracle\\Inventory"
"ORACLE_HOME"="F:\\oracle\\ora81"
"ORACLE_HOME_NAME"="OraHome81"
"API"="F:\\oracle\\ora81\\dbs"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280"
"OLEDB"="F:\\oracle\\ora81\\oledb\\mesg"
"VOBHOME2.0"="F:\\oracle\\ora81"
"OO4O"="F:\\oracle\\ora81\\oo4o\\mesg"
"oracle_sid"="oratest"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES]
"HOME_COUNTER"="1"
"DEFAULT_HOME"="OraHome81"
"LAST_HOME"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\ID0]
"NAME"="OraHome81"
"PATH"="F:\\oracle\\ora81"
"NLS_LANG"="NA"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome81"
"ORACLE_HOME_NAME"="OraHome81"
"ORACLE_HOME"="F:\\oracle\\ora81"
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280"
"ORACLE_HOME_KEY"="Software\\ORACLE\\HOME0"
"SQLPATH"="F:\\oracle\\ora81\\dbs"
"MSHELP_TOOLS"="F:\\oracle\\ora81\\MSHELP"
"ORACLE_SID"="oratest"
"ORACLE_BASE"="F:\\oracle"
"RDBMS_CONTROL"="F:\\oracle\\ora81\\DATABASE"
"RDBMS_ARCHIVE"="F:\\oracle\\ora81\\DATABASE\\ARCHIVE"
"ORA_ORATEST_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_ORATEST_PFILE"=hex(2):63,00,3a,00,5c,00,6f,00,72,00,61,00,63,00,6c,00,6
5,\
  00,5c,00,69,00,6e,00,69,00,74,00,2e,00,6f,00,72,00,61,00,00,00
"ORA_ORATEST_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_ORATEST_SHUTDOWNTYPE"=hex(2):69,00,00,00
"ORA_ORATEST_SHUTDOWN_TIMEOUT"=hex(2):33,00,30,00,00,00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OLEDB]
"CacheType"="Memory"
"ChunkSize"="100"
"DistribTX"="1"
"FetchSize"="100"
"OSAuthent"="0"
"PLSQLRSet"="0"
"PwdChgDlg"="1"
"SchRstLng"="10000"
"UserDefFn"="0"
"DisableRetClause"="1"
"TraceCategory"="0"
"TraceFileName"="c:\\OraOLEDB.trc"
"TraceLevel"="0"
"TraceOption"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OO4O]
"CacheBlocks"="20"
"FetchLimit"="100"
"FetchSize"="4096"
"HelpFile"="F:\\oracle\\ora81\\MSHELP\\oracleo.hlp"
"PerBlock"="16"
"SliceSize"="256"
"TempFileDirectory"="c:\\temp"
"OO4O_HOME"="F:\\oracle\\ora81\\oo4o"
Received on Mon Aug 12 2002 - 20:45:38 CDT