ora-12560

[drishti]

hello,
ora-12560 -tns protocol adapter error,is this a network or db error. occasionally I get this error,on restarting the service it again works.what might be the case .my db is oracle 8.1.5 on win nt -4.0.I reinstalled tcp/ip .still the same,is this network card prob or what?

[raghucharan]

Possibility may be the listner not started.Dont think it is database error

[aracnid]

this is network problem. So your db is not affected, but your listener is not working fine. Causes may be that a protocol es. TCP don't work fine. I had a similar problem (only the error) traced in my listerner.log and i went mad until i found the problem. My db was accessed in telnet on the port 1521, and tcp protocol in the listener didn't work for a while(telnet time)

[drishti]

my listener is running even when sql*plus not getting connected due to this error.lsnr status is ok.trace file of listener donot have entries even alert log donot show any trace messages.

[TerryD]

run:

tnsping ALIAS or tnsping80 ALIAS

from command line (where ALIAS is the Database you want to connect to)...

This may reveal a lower level error which is masked program levels.

[drishti]

nserror: nsres: id=6, op=72, ns=12560, ns2=0; nt[0]=530, nt[1]=0, nt[2]=0
nserror: nsres: id=6, op=72, ns=12560, ns2=0; nt[0]=530, nt[1]=0, nt[2]=0
this is extract of listener.trc,
can anybody tell???

[aji.thm]

HAI,
What is the current service pack of your windows NT..? I had a similar problem and it got rectified by upgrading the service pack to 6

try this
all the best

...Thomas

[drishti]

ok I have service pack 5 installed .I will try to install service pack 6 and see.

[fraze]

This is taken from a UNIX utility that helps diagnose Oracle errors. May help:

12560, 00000, "TNS:protocol adapter error"

// *Cause: A generic protocol adapter error occurred.
// *Action: 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 reexecute the
// operation. Turn off tracing when the operation is complete.