-
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???
-
Service pack
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
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|