TNS error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNS error

  1. #1
    Join Date
    Apr 2006
    Posts
    2

    TNS error

    Hello,
    I am running 10G xe on windows 2003 server. Everything seems to work pretty smoothly for a few hours and then it bombs. The listener.log file shows this error:

    TNS-12516: TNS:listener could not find available handler with matching protocol stack

    There are some things in this log that I wonder about. In the piece of the log below you can see that the port number is incremented in every entry in the listener.log. Is this normal? Does this mean that my app is not closing connections? Any help would be greatly appreciated.

    12-APR-2006 11:11:26 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo r))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2852)) * establish * XE * 0
    12-APR-2006 11:11:26 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo r))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2853)) * establish * XE * 0
    12-APR-2006 11:11:26 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo r))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2854)) * establish * XE * 0
    12-APR-2006 11:11:26 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo r))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2855)) * establish * XE * 0
    12-APR-2006 11:11:26 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo r))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2856)) * establish * XE * 0
    12-APR-2006 11:11:26 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=M4)(USER=smo r))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.5)(PORT=2857)) * establish * XE * 12516
    TNS-12516: TNS:listener could not find available handler with matching protocol stack



    thanks
    Jason

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what is the status of the listener at this point (plus xe questions are best handled on the xe forum on otn)

  3. #3
    Join Date
    Apr 2006
    Posts
    2
    It is still running if that is what you mean?

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