1 2 Previous Next 17 Replies Latest reply: Oct 1, 2010 12:20 PM by user568681 RSS

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

    user568681
      after making the change by inbound connection timed out (ORA-3136) problem ,
      I shutdown the server and database, later users connect with no problem at least for an hour and after that period appear a message in the lister.log
      the message "30-SEP-2010 11:07:05 * 12502
      TNS-12502: TNS: listener Received no CONNECT_DATA from client "
      and the client "30-SEP-2010 11:07:05 * 12502
      TNS-12502: TNS: listener Received no CONNECT_DATA from client "and if they can not connect it was succeeded with some users not all;
      In alert log not found error message only a trc file with line message (
      *** 2010-09-30 09:45:19.736
      tkcrrxmp: Stopping ARC3 to reduce ARCH processes from 4 to 3
      kcrrwkx: nothing to do (end))

      I have 10g (10.2.0.1.0) in windows 32 using 12 GB of ram; and SGA 5 GB; using /PAE AND /3G in boot.ini
        • 1. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
          sb92075
          TNS-12502: TNS: listener Received no CONNECT_DATA from client "
          Oracle RDBMS is the victim; not the culprit.
          The culprit is the application which needs to be fixed.

          It does *NOT* matter than no errors occurred with previous DB version.
          Errors occur now & needs to be corrected.
          • 2. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
            user568681
            OK;
            However the owner of the application is installed with the many other client an oracle 10g and they have not problem
            What others setting i can do?
            please help me my database is now in producction
            • 3. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
              sb92075
              SQLNET.INBOUND_CONNECT_TIMEOUT =0;
              • 4. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                user568681
                ok , yesterday i set SQLNET.INBOUND_CONNECT_TIMEOUT =110; now i should changed it to 0?
                • 5. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                  sb92075
                  yesterday i set SQLNET.INBOUND_CONNECT_TIMEOUT =110
                  Did this change solve the problem?
                  • 6. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                    user568681
                    ok i am changing to 0 and shutdowun my database? later confirm;
                    • 7. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                      sb92075
                      SQLNET.INBOUND_CONNECT_TIMEOUT
                      sqlnet.ora is CLIENT file; not a DB server file.
                      • 8. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                        user568681
                        but i add it in the database server? should eliminate it
                        • 9. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                          sb92075
                          but i add it in the database server?
                          To what is the DB server connecting & why?

                          post current timestamp of sqlnet.log
                          post last 100 lines from sqlnet.log

                          post results from following SQL

                          SELECT MACHINE, PROGRAM, COUNT(*) FROM V$SESSION
                          HAVING COUNT(*) > 1
                          GROUP BY MACHINE, PROGRAM ORDER BY 1,2

                          Edited by: sb92075 on Sep 30, 2010 11:05 AM
                          • 10. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                            user568681
                            hi my sqlnet.log of database ...


                            ***********************************************************************
                            Fatal NI connect error 12570, connecting to:
                            (LOCAL=NO)

                            VERSION INFORMATION:
                                 TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                 Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                 Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                            Time: 30-SEP-2010 08:40:26
                            Tracing not turned on.
                            Tns error struct:
                            ns main err code: 12570
                            TNS-12570: TNS:packet reader failure
                            ns secondary err code: 12560
                            nt main err code: 0
                            nt secondary err code: 0
                            nt OS err code: 0
                            • 11. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                              sb92075
                              12570, 00000, "TNS:packet reader failure"
                              // *Cause: An error occurred during a data receive.
                              // *Action: Not normally visible to the user. For further details, turn
                              // on tracing and reexecute the operation. If error persists, contact
                              // Oracle Customer Support.

                              WHEN did this error occur?
                              To what DB was this connection attempted?

                              in some/many/most cases this flavor of error results from OS/Networking misconfiguration.
                              Oracle is victim; not culprit.

                              if you choose to not provide ALL requested details then my ability to assist is limited
                              • 12. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                                user568681
                                ok these
                                sqlnet.log later send the others file
                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 11:02:21
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 11:02:22
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 11:02:22
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 11:02:22
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 11:02:22
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 11:21:30
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12170.

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 13:44:39
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12535
                                TNS-12535: TNS:operation timed out
                                ns secondary err code: 12606
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0
                                Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.7.239)(PORT=1422))


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 15:07:02
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 15:07:02
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 15:07:02
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 15:07:02
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 16:19:32
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0


                                ***********************************************************************
                                Fatal NI connect error 12637, connecting to:
                                (LOCAL=NO)

                                VERSION INFORMATION:
                                     TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                     Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
                                Time: 29-SEP-2010 16:19:32
                                Tracing not turned on.
                                Tns error struct:
                                ns main err code: 12637
                                TNS-12637: Packet receive failed
                                ns secondary err code: 12570
                                nt main err code: 0
                                nt secondary err code: 0
                                nt OS err code: 0
                                • 13. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                                  sb92075
                                  based upon posted details I conclude a networking problem exists.
                                  12637, 00000, "Packet receive failed"
                                  // *Cause:  A process was unable to receive a packet from another process.
                                  //          Possible causes are:
                                  //          1. The other process was terminated.
                                  //          2. The machine on which the other process is running went down.
                                  //          3. Some other communications error occurred.
                                  // *Action: If the cause is not obvious, contact Oracle Customer Support.
                                  • 14. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
                                    user568681
                                    SELECT MACHINE, PROGRAM, COUNT(*) FROM V$SESSION
                                    HAVING COUNT(*) > 1
                                    GROUP BY MACHINE, PROGRAM ORDER BY 1,2
                                    and it the output

                                    MACHINE      PROGRAM COUNT(*)
                                    CRISTOBAL\OPS-TERM-ASSIST          2
                                    CRISTOBAL\TOF-ASSIGN-6          2
                                    PPC\CLIENT-HP     PLSQLDev.exe 2
                                    PPC\TIMEOFFI-1          2
                                    1 2 Previous Next