This discussion is archived
3 Replies Latest reply: Jan 11, 2013 9:23 AM by Osama_Mustafa RSS

ORA-12518: TNS:listener could not hand off client connection

969526 Newbie
Currently Being Moderated
Hi,

I am getting the the following error again and again.

ORA-12518: TNS:listener could not hand off client connection


i checked the process parameter its set to 800
when i check select count(*) from v$process; its shows value 805

now i an trying to set the process parameter to 900

ALTER SYSTEM SET processes=900 SCOPE=spfile;

but its shows error Ora-02095- specified initialization parameter can't modified...


please suggest some solution.


Regards...
Asit...
  • 1. Re: ORA-12518: TNS:listener could not hand off client connection
    moreajays Pro
    Currently Being Moderated
    Hi,

    Check if memory utilization on server & number of process from v$resource_limit has reached, you need to set scope=spfile for process parameter
    As a workaround set DIRECT_HANDOFF_TTC_LISTENER=OFF & restart listener

    Thanks,
    Ajay More
    http://moreajays.blogspot.com
  • 2. Re: ORA-12518: TNS:listener could not hand off client connection
    Niket Kumar Pro
    Currently Being Moderated
    for changing number of processes you need to instance restart
    SQL> select
      2    resource_name,
      3    current_utilization,
      4    max_utilization,
      5    limit_value
      6  from
      7    v$resource_limit
      8  where
      9    resource_name in ( 'sessions', 'processes');
    
    RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION
    ------------------------------ ------------------- ---------------
    LIMIT_VALUE
    ----------------------------------------
    processes                                       29              34
           100
    
    sessions                                        30              38
           172
    
    
    SQL> set linesize 300
    SQL> /
    
    RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
    ------------------------------ ------------------- --------------- ----------------------------------------
    processes                                       29              34        100
    sessions                                        30              38        172
    
    SQL> alter system set processes=200 scope=spfile;
    
    System altered.
    
    SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL>
    SQL>
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area  644468736 bytes
    Fixed Size                  1385488 bytes
    Variable Size             184552432 bytes
    Database Buffers          452984832 bytes
    Redo Buffers                5545984 bytes
    Database mounted.
    Database opened.
    SQL> select
      2    resource_name,
      3    current_utilization,
      4    max_utilization,
      5    limit_value
      6  from
      7    v$resource_limit
      8  where
      9    resource_name in ( 'sessions', 'processes');
    
    RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
    ------------------------------ ------------------- --------------- ----------------------------------------
    processes                                       27              31        200
    sessions                                        26              31        322
    
    SQL>
  • 3. Re: ORA-12518: TNS:listener could not hand off client connection
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Refer to MOS
    New Connections to the Database lead to ORA-12518 or TNS-12518 [ID 340089.1]
    OERR: ORA-12518 TNS:listener could not hand off client connection [ID 71928.1]

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points