This discussion is archived
3 Replies Latest reply: Oct 26, 2012 10:45 AM by 970929 RSS

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

970929 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Ok i.m resolve the proble. someone configured a new bond interface and created problem wuth oracle.

    Thank's for all.

Legend

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