ORA 12560 - TNS protocol adapter error

From: Tom Chow <cmc3232_at_yahoo.com>
Date: Sun, 07 Jan 2001 23:33:37 GMT
Message-ID: <3A58FDB9.C7A7B8E8@yahoo.com>

I am using 8.1.6 with NT 4.0 workstation. Whenever I try to use svrmgrl to startup the local instance, I got following message:

My questions are:
1. Why do I need SQLNET if my instance is local? 2. I turned on the trace on SQLNET.ORA but not much on the log file, here is part of the listing:

niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)
(ARGV0=oracleTOR2EDBS)
(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))
(CONNECT_DATA=(SID=TOR2EDBS)
(CID=(PROGRAM=C:\Oracle\Ora81\bin\SVRMGRL.EXE)
(HOST=TCHOW)(USER=Administrator))))

nscall: entry

nsmal: entry
nsmal: 140 bytes at 0x42c200
nsmal: normal exit

nscall: connecting...
. . .
nsmal: 1712 bytes at 0x19f3f40
nsmal: normal exit
nsopenmplx: normal exit

nsopen: opening transport...
ntpcon: entry
ntpcon: toc = 1

sntpcall: entry
snlpcss: entry
ntpcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=2, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport

Note: I have SQLNET 2.3 installed in the same machine because I have to use some application that can only work with old version of SQLNET to connect with Oracle 7.1.3 Any chance this clobber up the setting? I did try to uninstall this old version of SQLNET but did not resolve my problem?

Any help appreciated.
Tom Received on Sun Jan 07 2001 - 17:33:37 CST