ORA-12518, TNS:Listener could not handoff client connection
652974Mar 12 2009 — edited Mar 12 2009Hi
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)
)
)