Re: ORA-12518: TNS:listener could not hand off

Praveen wrote:

> Hi,
>
> Thanks for the response.
> Today i turned on the trace level to admin and trace file says the
> following which converted thru trcasst tool. In this trace output it
> has not shown error number 12518 instead it is showing protocol
> adopter error.
>
> If i restart the lisnter then we are able to connect and after
> sometime same problem.
>
> Java programmer are getting this error:
>
> hrowable: (java.sql.SQLException: Io exception: Connection
> refused(DESCRIPTION
> =(ERR=12518)(VSNNUM=168821248)(ERROR_STACK=(ERROR=(CODE=12518)(EMFI=4))(ERROR=(C
> ODE=12560)(EMFI=4)))))
> at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
>
>
> Trace Assistant Utility: Version 10.1.0.2.0 Production on October 9,
> 2004 11:59:18 AM
>
> (c) Copyright 2001, 2003 Oracle. All rights reserved.
>
>
> *************************************************************************
> * Trace Assistant
> *
> *************************************************************************
>
> ///////////////////////////////////////////////////////////////
> Error found. Error Stack follows:
> id:8
> Operation code:72
> NS Error 1:12586
> NS Error 2:0
> NT Generic Error:0
> Protocol Error:0
> OS Error:0
> NS & NT Errors Translation
>
> TNS-04315: Trace Assistant Internal error: Can't find resource for
> bundle oracle.net.trcasst.mesg.TnsError, key 12586
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> ///////////////////////////////////////////////////////////////
>
> ///////////////////////////////////////////////////////////////
> Error found. Error Stack follows:
> id:8
> Operation code:72
> NS Error 1:12586
> NS Error 2:0
> NT Generic Error:0
> Protocol Error:0
> OS Error:0
> NS & NT Errors Translation
>
> TNS-04315: Trace Assistant Internal error: Can't find resource for
> bundle oracle.net.trcasst.mesg.TnsError, key 12586
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> ///////////////////////////////////////////////////////////////
>
> ///////////////////////////////////////////////////////////////
> Error found. Error Stack follows:
> id:8
> Operation code:72
> NS Error 1:12586
> NS Error 2:0
> NT Generic Error:0
> Protocol Error:0
> OS Error:0
> NS & NT Errors Translation
>
> TNS-04315: Trace Assistant Internal error: Can't find resource for
> bundle oracle.net.trcasst.mesg.TnsError, key 12586
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> ///////////////////////////////////////////////////////////////
>
> ///////////////////////////////////////////////////////////////
> Error found. Error Stack follows:
> id:8
> Operation code:72
> NS Error 1:12560
> NS Error 2:0
> NT Generic Error:0
> Protocol Error:0
> OS Error:0
> NS & NT Errors Translation
> 12560, 00000 "TNS:protocol adapter error"
> // *Cause: A generic protocol adapter error occurred.
> // *Action: Check addresses used for proper protocol specification.
> Before
> // reporting this error, look at the error stack and check for lower
> level
> // transport errors.For further details, turn on tracing and
> reexecute the
> // operation. Turn off tracing when the operation is complete.
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> 00000, 00000 "Not An Error"
> // *Cause: Everything is working as it should.
> // *Action: Dont worry: Be happy.
> /
> ///////////////////////////////////////////////////////////////
>
>
> ----------------------
> Trace File Statistics:
> ----------------------
> Total number of Sessions: 0
>
> DATABASE:
> Operation Count: 0 OPENS, 0 PARSES, 0 EXECUTES, 0
> FETCHES
>
>
> ORACLE NET SERVICES:
> Total Calls : 0 sent, 0 received, 0 oci
> Total Bytes : 0 sent, 0 received
> Average Bytes: sent per packet, received per packet
> Maximum Bytes: 0 sent, 0 received
>
> Grand Total Packets: 0 sent, 0 received
>
>
> *************************************************************************
> * Trace Assistant has completed
> *
> *************************************************************************
>
>
>
> Hans Forbrich <news.hans_at_telus.net> wrote in message news:<3KC9d.11$Ia5.3_at_edtnps89>...
>

>>Praveen wrote:
>>
>>
>>>Hi All,
>>>
>>>I'm using oracle 10g in window XP system. java programmers will be
>>>accessing the database. Frequently they will get "ORA-12518:
>>>TNS:listener could not hand off" error and through sqlplus also i'll
>>>get this error. But, after sometime it works fine. I checked
>>>tnsnames.ora and listner.ora files entry. they seems to be ok. i have
>>>used system name itself for HOST flag instead of IP address. But still
>>>i'm getting this error.
>>>
>>>Can anybody tell me what might be the problem?
>>>
>>>Thanks,
>>>Praveen
>>
>>From Oracle's error messages docco, we see
>>
>>--------
>>TNS-12518 TNS:listener could not hand off client connection
>>
>>    Cause: The process of handing off a client connection to another process
>>failed.
>>
>>    Action: Turn on listener tracing and re-execute the operation. Verify
>>that the listener and database instance are properly configured for direct
>>handoff. If the problem persists, contact Oracle Support Services.
>>--------
>>
>>So what does the listener trace indicate?
>>
>>/Hans

Did you by any chance upgrade with SP2? If so, you could be running into firewall problems - 1521 is open, the initial contact made, but the handoff to a random (blocked!) port fails...

-- 

Regards,
Frank van Bortel