Re: ORA 12560 - TNS protocol adapter error

In article <3A590F39.D179FE57_at_yahoo.com>,   cmc3232_at_yahoo.com wrote:
> 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:
>
> ORA 12560 - TNS protocol adapter error
>
> 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.3.4 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
>

Probably you just didn't set ORACLE_SID. Try
SET ORACLE_SID = <your sid>
before you start svrmgrl

Two versions of sqlnet can cause problems especially if you didn't set TNS_ADMIN (which will be taken from the registry)

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/