DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ora-12560

  1. #1
    Join Date
    Jun 2000
    Posts
    104
    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?

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Possibility may be the listner not started.Dont think it is database error

  3. #3
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    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)

  4. #4
    Join Date
    Jun 2000
    Posts
    104
    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.

  5. #5
    Join Date
    Sep 2000
    Posts
    128
    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.

  6. #6
    Join Date
    Jun 2000
    Posts
    104
    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???

  7. #7
    Join Date
    Nov 2000
    Posts
    20

    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

  8. #8
    Join Date
    Jun 2000
    Posts
    104
    ok I have service pack 5 installed .I will try to install service pack 6 and see.

  9. #9
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    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
  •  


Click Here to Expand Forum to Full Width