This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Oct 1, 2010 10:20 AM by user568681 RSS

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

user568681 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    SQLNET.INBOUND_CONNECT_TIMEOUT =0;
  • 4. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
    user568681 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    but i add it in the database server? should eliminate it
  • 9. Re: TNS-12502: TNS: listener Received no CONNECT_DATA from client
    sb92075 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points