4 Replies Latest reply: Dec 11, 2012 9:15 AM by sb92075 RSS

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

    596937
      Hi,

      I am getting this error since 2 or 3 days "TNS-12502: TNS:listener received no CONNECT_DATA from client". I have checked my tnsnames.ora and sqlnet.ora files, bot are fine with correct CONNECT_DATA.

      I have set the parameter to SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora on client machine but i am not very much sure where should i put this parameter on client machine or server machine?

      Please advice me to solve this error...

      Regards,
      Puneet Pradhan

      Edited by: Puneet_19 on Dec 6, 2012 11:18 AM
        • 1. Re: TNS-12502: TNS:listener received no CONNECT_DATA from client
          sb92075
          Puneet_19 wrote:
          Hi,

          I am getting this error since 2 or 3 days "TNS-12502: TNS:listener received no CONNECT_DATA from client". I have checked my tnsnames.ora and sqlnet.ora files, bot are fine with correct CONNECT_DATA.

          I have set the parameter to SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora on client machine but i am not very much sure where should i put this parameter on client machine or server machine?

          Please advice me to solve this error...

          Regards,
          Puneet Pradhan

          Edited by: Puneet_19 on Dec 6, 2012 11:18 AM
          most likely cause is buggy client code.
          I saw this from flawed Java code.

          listener.log will contain this error & show originating client
          • 2. Re: TNS-12502: TNS:listener received no CONNECT_DATA from client
            Satishbabu Gunukula
            In $ORACLE_HOME/network/log/listener.log you should be able to see which client is throwing this error...

            Also refere below link
            http://krishanjaglan.blogspot.ca/2010/09/tns-12502-tnslistener-received-no.html
            TNS-12502: TNS: listener Received no CONNECT_DATA from client

            Hope this helps,

            Regards,
            http://www.oracleracexpert.com
            You want to participate in Oracle Beta program or Exam?
            http://www.oracleracexpert.com/2012/01/you-want-to-participate-in-oracle-beta.html
            How to STOP and START processes in Oracle RAC and Log Directory Structure
            http://www.oracleracexpert.com/2012/01/how-to-stop-and-start-processes-in.html
            • 3. Re: TNS-12502: TNS:listener received no CONNECT_DATA from client
              596937
              Hi,

              I have set this parameter SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora file on client side and i know which client is thowring this error. but still not able to understand how to resolve this error?

              Daily i am getting this error. Is this the Bug as i am using 11.1.0.7.0 on Windows server 2007 enterprise edition.

              Regards,
              Puneet Pradhan
              • 4. Re: TNS-12502: TNS:listener received no CONNECT_DATA from client
                sb92075
                Puneet_19 wrote:
                Hi,

                I have set this parameter SQLNET.INBOUND_CONNECT_TIMEOUT in sqlnet.ora file on client side and i know which client is thowring this error. but still not able to understand how to resolve this error?
                If you unplug this client, then errors will no longer be logged to the DB Server.

                The client is doing bad thing.
                Change client to provide all necessary details to connect successfully to the DB.