3 Replies Latest reply: Jan 11, 2013 11:23 AM by Osama_Mustafa RSS

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

    969526
      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
          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
            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
              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]