Printable View
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?
Possibility may be the listner not started.Dont think it is database error
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)
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.
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.
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???
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
ok I have service pack 5 installed .I will try to install service pack 6 and see.
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.