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

From: Praveen <spraveen2001_at_yahoo.com>
Date: 8 Oct 2004 23:45:29 -0700
Message-ID: <98d8ec76.0410082245.3af0f0d9@posting.google.com>

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

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

///////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////
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

///////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////
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

Received on Sat Oct 09 2004 - 01:45:29 CDT