Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12518, TNS:Listener could not handoff client connection

652974Mar 12 2009 — edited Mar 12 2009
Hi

I keep getting ORA-12518, TNS:Listener could not handoff client connection error. I have done a bit of research on this and they all seem to suggest that
DIRECT_HANDOFF_TTC_LISTENER=OFF should be added to the listener.ora file. I have done that but I still keep getting this error. I was wondering if some one could help me. My listener.ora and tnsnames.ora have been added. Is there anything that I am doing wrong or are these files wrong? Any help will be greatly appreciated.

Listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ASDB)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = ASDB)

)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEVPSTEXP)(PORT = 1521))
(DIRECT_HANDOFF_TTC_LISTENER=OFF)
)
)


TNSNAMES.ora

ASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEVPSTEXP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ASDB)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2009
Added on Mar 12 2009
12 comments
2,230 views