Forum Stats

  • 3,874,172 Users
  • 2,266,676 Discussions


Encountering ORA-12518.

Npareek Member Posts: 1 Green Ribbon

I am new to Oracle sql. Just installed oracle 21c and sql developer on my 64 bit, windows pro pc. I really tried my best to make a new database connection. Reinstalled sqldeveloper and Oracle21c multiple times and many more ways. But this error just don't go away. Please Please Please someone help me out.


  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,945 Red Diamond

    12518, 00000, "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 problem persists, call Oracle Support.

    // *Comment: The problem can be worked around by configuring dispatcher(s)

    // to specifically handle the desired presentation(s), and connecting

    // directly to the dispatcher, bypassing the listener.

    You (SQL-Developer) connects to the Listener, requesting a connection to a database service.

    If valid, the Listener hands off your connection (e.g. tcp socket) to a database server process to service.

    This hand off failed. There can be a number of reasons for this to fail. Listener tracing is typically needed to determine the cause.