Home » RDBMS Server » Server Administration » ORA-12518: TNS:listener could not hand off client connection
ORA-12518: TNS:listener could not hand off client connection [message #154836] Tue, 10 January 2006 21:23 Go to next message
cuongtv
Messages: 34
Registered: August 2005
Location: Vi�t Nam
Member

I install Oracle9i and Oracle8i on Win2000 Server. I used Listener of 9i. My database based on Oracle8i. I found this error:ORA-12518: TNS:listener could not hand off client connectionwhen I logged on database. If I restarted database and listener it run but a few minutes it failed. Can u help me???
Re: ORA-12518: TNS:listener could not hand off client connection [message #154857 is a reply to message #154836] Wed, 11 January 2006 00:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you usting MTS?
First start the listener and then the database ( both the databases).
Now check the status of listener.
if nothing works, try
DIRECT_HANDOFF_TTC_<listener name> = OFF in listener.ora.
Re: ORA-12518: TNS:listener could not hand off client connection [message #154896 is a reply to message #154857] Wed, 11 January 2006 03:32 Go to previous messageGo to next message
cuongtv
Messages: 34
Registered: August 2005
Location: Vi�t Nam
Member

No, I don't use MTS. I don't see DIRECT_HANDOFF_TTC_<listener name> = OFF in listener.ora
# LISTENER.ORA Network Configuration File: F:\oracle\ora91\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tdt-srv)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = KT38i)
(ORACLE_HOME = F:\oracle\ora81)
(SID_NAME = KT38i)
)
(SID_DESC =
(GLOBAL_DBNAME = TDTKB)
(ORACLE_HOME = F:\oracle\ora81)
(SID_NAME = TDTKB)
)
)
Re: ORA-12518: TNS:listener could not hand off client connection [message #154900 is a reply to message #154896] Wed, 11 January 2006 03:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Then set
DIRECT_HANDOFF_TTC_<listener name> = OFF in listener.ora and try again.
Re: ORA-12518: TNS:listener could not hand off client connection [message #235140 is a reply to message #154836] Fri, 04 May 2007 03:04 Go to previous messageGo to next message
manish.wadhwa
Messages: 1
Registered: May 2007
Junior Member
Hi,

I got the similar error. It got resolved when I started the DB listener through services.

As in your case, since there are multiple DBs, try stopping the listener of the old version DB. Though this step is not required in case the DBs are installed on different ports, but still one can try.

rgds,
Manish.
Re: ORA-12518: TNS:listener could not hand off client connection [message #235146 is a reply to message #235140] Fri, 04 May 2007 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think he is interested in an answer 5 months after.

Regards
Michel
Re: ORA-12518: TNS:listener could not hand off client connection [message #235401 is a reply to message #235146] Sat, 05 May 2007 08:58 Go to previous messageGo to next message
cuongtv
Messages: 34
Registered: August 2005
Location: Vi�t Nam
Member

My problem is solved, so I didn't comeback for a long time
Re: ORA-12518: TNS:listener could not hand off client connection [message #235406 is a reply to message #235401] Sat, 05 May 2007 09:41 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


May i know how to solve your problem ????

Re: ORA-12518: TNS:listener could not hand off client connection [message #235408 is a reply to message #154836] Sat, 05 May 2007 10:07 Go to previous messageGo to next message
cuongtv
Messages: 34
Registered: August 2005
Location: Vi�t Nam
Member

I reconfiged listener, corrected tnsname.ora . It was ok, but it's only my problem, I don't know exactly your problem.
Re: ORA-12518: TNS:listener could not hand off client connection [message #235411 is a reply to message #235408] Sat, 05 May 2007 10:24 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>>It was ok, but it's only my problem, I don't know exactly your problem.

Just i know your problem. And how to you solve that one. And i am not tel me problem..

Razz

Babu
Re: ORA-12518: TNS:listener could not hand off client connection [message #235414 is a reply to message #235411] Sat, 05 May 2007 10:44 Go to previous messageGo to next message
cuongtv
Messages: 34
Registered: August 2005
Location: Vi�t Nam
Member

gentlebabu wrote on Sat, 05 May 2007 22:24



Just i know your problem. And how to you solve that one. And i am not tel me problem..

Razz

Babu


I reconfiged listener, corrected tnsname.ora . It's not good way
Re: ORA-12518: TNS:listener could not hand off client connection [message #419237 is a reply to message #154836] Thu, 20 August 2009 11:18 Go to previous messageGo to next message
whathappen
Messages: 1
Registered: August 2009
Junior Member
this problem almost root cause of limited server resources or configuration. try to check these

1. database server memory were enough for new connection
2. database connection parameters such as

2.1 dedicated server, pls checked processes parameter or query from v$resource_limit where resource_name='processes'; checked max_utilization must less than Limit_value or
2.2 shared server, pls verify large_pool_size or check dispatcher were enough for all connection.

3. you may check related log such as listener.log, alert log, trace file, etc

reference: blogitknowledge.u-indy.com/database-services/oracle-troubleshoot/oracle-troubleshoot-ora-12518-tnslistener-could-not-hand-off-client- connection/

[Updated on: Thu, 20 August 2009 11:19]

Report message to a moderator

Re: ORA-12518: TNS:listener could not hand off client connection [message #419287 is a reply to message #154836] Thu, 20 August 2009 23:06 Go to previous messageGo to next message
cuongtv
Messages: 34
Registered: August 2005
Location: Vi�t Nam
Member

Oh, thank you whathappen, friend.
Your solution is the suitable method to examine problems
Re: ORA-12518: TNS:listener could not hand off client connection [message #420811 is a reply to message #154836] Wed, 02 September 2009 06:31 Go to previous messageGo to next message
DBAbba
Messages: 1
Registered: September 2009
Junior Member
We just killed some users and then shutdown and restarted the instance.
Re: ORA-12518: TNS:listener could not hand off client connection [message #420875 is a reply to message #420811] Wed, 02 September 2009 22:02 Go to previous message
cuongtv
Messages: 34
Registered: August 2005
Location: Vi�t Nam
Member

It's a temporary solution, DBAbba, but it's fine.
Previous Topic: ORA-01562: failed to extend rollback segment
Next Topic: Need Guidline for deploying server,
Goto Forum:
  


Current Time: Sat Oct 01 04:11:01 CDT 2016

Total time taken to generate the page: 0.11638 seconds