Re: sqlplus /nolog can't manage instance

"Pan Tao" <pantao_fz_at_21cn.com> wrote in message news:aj9o8r$1mop$2_at_mail.cn99.com...
> 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).

You say you are using the bequeath protocol. The error message indicates something is wrong with your protocol adapter. (See http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920 /a96525/tnsus.htm#1002462 [warning, that link will wrap!!]... you'll have to be a member of technet first (but it's free).)

That description of the error states that you should "Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete."

>
> 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?
>

Sort out your networking components (just a daft question, but why do you insist on the bequeath protocol?).

> 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?

Asked and answered regularly. Privileged users (which is what the 'as sysdba' means you are) are authenticated either by a password file, or by you, the machine user, having logged onto the Windows box, and thus acquired membership of the ORA_DBA local group.

Regards
HJR
>
> 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 - 21:43:46 CDT