3 Replies Latest reply: Oct 26, 2012 12:45 PM by 970929 RSS

    TNS-12518: TNS:listener could not hand off client connection

    970929
      I can´t access to my database. De connection are refused.

      SERVICE
      LSNRCTL> service
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=extproc)))
      Services Summary...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Handler(s):
      "DEDICATED" established:0 refused:0
      LOCAL SERVER
      Service "XE" has 1 instance(s).
      Instance "XE", status READY, has 1 handler(s) for this service...
      Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
      LOCAL SERVER
      Service "XEXDB" has 1 instance(s).
      Instance "XE", status READY, has 1 handler(s) for this service...
      Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
      DISPATCHER <machine: CONVERSION, pid: 8829>
      (ADDRESS=(PROTOCOL=tcp)(HOST=CONVERSION.site)(PORT=40903))
      The command completed successfully


      and in my log

      <msg time='2012-10-26T17:31:21.576+02:00' org_id='oracle' comp_id='tnslsnr'
      type='UNKNOWN' level='16' host_id='CONVERSION'
      host_addr='127.0.0.2'>
      <txt>TNS-12518: TNS:listener could not hand off client connection
      TNS-12547: TNS:lost contact
      TNS-12560: TNS:protocol adapter error
      TNS-00517: Lost contact
      Linux Error: 32: Broken pipe
      </txt>
      </msg>

      I read that the solution is crealizar: "alter system set processes = 300 SCOPE = SPFILE;" but i can´t access to sqlplus and i don´t know what can i do to restore the service.

      Thanks

      Edited by: user10707428 on 26-oct-2012 9:58
        • 1. Re: TNS-12518: TNS:listener could not hand off client connection
          Udo
          Hello, and welcome to the OTN forums!

          Please provide some additional information on your system: OS (exact version, if possible), DB version, system parameters (memory, ...)
          From a first glance at the error message you receive, this could be an issue with your network configuration... Could you outline some details like how server and client (if different) are connected?
          host_addr='127.0.0.2'
          ... is a little odd. Did you configure this somewhere?
          Has the system been broken since install or did it stop suddenly? ...

          -Udo
          • 2. Re: TNS-12518: TNS:listener could not hand off client connection
            clcarter
            Assuming you're on 11g since you've posted an xml flavoured alert log entry, and the
            Linux Error: 32: Broken pipe
            means you're on linux, which distro? Something doesn't seem quite right with the network configuration, with an (almost) loopback/local host IP 127.0.0.2.

            Verify your hostname and IP address. Ensure your listener.ora entry has either 1) the correct hostname or 2) your IP address for HOST=... stanza in your listener.ora.

            $ ifconfig -a
            ... how many interfaces? en0? en1?
            $ hostname
            ...<hostname>
            $ nslookup <hostname>
            ... <IP address>
            $ nslookup <ipaddress>
            ... <hostname>[.domain name]

            The loopback 127.0.0.1 IP is only useful for verifying that TCP is configured on the host, or in the case of the Apex server, the http://127.0.0.1... browser connection when remote apex access is disabled.

            Another possible fix, if your hostname and IP is set up correctly, stop the listener and move the listener.ora file out of the way, and start it. An empty listener.ora file gets you a default listener on port 1521- try a system connection `alter system register;` and check the `lsnrctl status` and `lsnrctl services` output and see if symptoms are any different.
            • 3. Re: TNS-12518: TNS:listener could not hand off client connection
              970929
              Ok i.m resolve the proble. someone configured a new bond interface and created problem wuth oracle.

              Thank's for all.