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

Report message to a moderator

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: 10708
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.

Report message to a moderator

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

Report message to a moderator

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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Then set
DIRECT_HANDOFF_TTC_<listener name> = OFF in listener.ora and try again.

Report message to a moderator

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.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't think he is interested in an answer 5 months after.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 1736
Registered: December 2005
Location: NJ
Senior Member

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

Report message to a moderator

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.

Report message to a moderator

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: 1736
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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: ORA-01562: failed to extend rollback segment
Next Topic: Need Guidline for deploying server,
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 17:02:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.