Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

TNS-12502: TNS:listener received no CONNECT_DATA from client

CAS_2
Valued Contributor

TNS-12502: TNS:listener received no CONNECT_DATA from client

Hi

Some days ago, the clients connecting to my DB suddenly got hung for 15 minutes aprox... After those 15 min, all clients were alive back with no intervention.

No error message is found in alert log. No error message is found in syslog.log. No process died.

I scanned the listener.log and found a low connection rate: 3, 4 or 7 connections per minute (usually there are 50 connections per minute).

I also found the following error message in those 15 minutes period:

26-JUN-2006 12:14:56 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client


I guess there might be a LAN problem but network team says no net problem was found.

What does that message mean ?
What do you think about this issue ?
2 REPLIES
Peter Godron
Honored Contributor

Re: TNS-12502: TNS:listener received no CONNECT_DATA from client

CAS,
you don't specify what version of oracle you are running.
TNS-12502 means thta your listener received a connect_string from a connection, which it did not understand.

Check your tnsnames.ora file.

Is there another program trying to use your listener port?
CAS_2
Valued Contributor

Re: TNS-12502: TNS:listener received no CONNECT_DATA from client

I tested the following:

telnet

After establishing connection, I close it.

This event causes the TNS-12502 error message in listener.log.