Home » RDBMS Server » Server Administration » listener could not hand off client connection (HPUX: Version 11.2.0.2.0 )
listener could not hand off client connection [message #526653] Wed, 12 October 2011 04:49 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

HI Expert,

I am getting error "ORA-12518: TNS:listener could not hand off client connection". This is for dedicated server.

I have check process paratere and that is with value 1000. Also i have checked few other dynamics view. Please suggest on further.

Thanks.


SQL> show parameter process

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
aq_tm_processes                      integer                          1
cell_offload_processing              boolean                          TRUE
db_writer_processes                  integer                          6
gcs_server_processes                 integer                          0
global_txn_processes                 integer                          1
job_queue_processes                  integer                          1000
log_archive_max_processes            integer                          4
processes                            integer                          1000
SQL> select * from v$resource_limit where resource_name='processes';

RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
------------------------------ ------------------- --------------- ---------- ----------
processes                                      160             519       1000       1000
Re: listener could not hand off client connection [message #526655 is a reply to message #526653] Wed, 12 October 2011 05:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12518: 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.


Most of the time this is because of insufficient memory or processes at OS level.

Regards
Michel
Re: listener could not hand off client connection [message #526665 is a reply to message #526655] Wed, 12 October 2011 05:59 Go to previous message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Michel.

I have started looking for any finding in listener log.
Previous Topic: TEMP tablespace estimation
Next Topic: subpartition template view
Goto Forum:
  


Current Time: Fri Apr 26 00:40:43 CDT 2024