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

Hi,

Yes, SP2 is installed on that server. I think default firewall enabling in SP2 we have disable. I'll check that too.

Thanks for response,
Praveen

Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<ckg4hi$ar9$3_at_news1.zwoll1.ov.home.nl>...
> 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...
Received on Wed Oct 13 2004 - 01:15:53 CDT