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

You try to connect with Oracle database and get Ora-12518 listener could not hand off client connection error.

Now what action is to be taken to get rid of above error? Follow below steps to resolve the issue.

Connect with oracle database:

C:\>sqlplus / as sysdba

SQL>conn testuser/[email protected]

And you got the ERROR: ORA-12518: TNS: listener could not hand off client connection

Solution-1:

First check your database whether it is in start mode or not.

SQL> shutdown immediate;

SQL> Startup;

Solution-2: If first is not working 

You have to increase PROCESSES initialization parameter in Oracle database.

First use the following command to check the existing value of the PROCESSES.

show parameter processes

As we have already started our database normally or using spfile, then run following command to alter system processes to 450.

alter system set processes=450 scope=spfile;

If you have started your database using pfile, process parameter must be set in pfile.

Solution-3: If both the above solutions are not working.

If you are getting ORA-12518 because of a shared server issue then you first need to use the below command to shutdown the dispatcher.

SQL> alter system shutdown immediate 'D001';

Then add on new dispatchers.

SQL> alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=3)';

Resolving ORA-12518 requires you to evaluate the syntax depending on your dispatcher value in the Spfile.ora or init.ora files.  When you increase DISPATCERS to resolve ORA-12518 you should also keep an eye on the shared server ratio.

Resolved ORA-12541: TNS no listener error

ORA-28001: The Password Has Expired

I hope you have successfully resolved your Ora-12518 issue.

2 thoughts on “Fixed ORA-12518: TNS:listener could not hand off client connection”

  1. Hi there,

    I am still unable to solve, hope you can help

    Environment: Windows 7 Ultimate 64 bit -> Oracle 11r2 –> attempting to install PeopleSoft Seed database.

    my initHRDEMO.ora file

    Listner.log
    —————————————————————————
    (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=HRDEMO)(UR=A)(CID=(PROGRAM=C:\PT8.53\bin\client\winx86\psdmt.exe)(HOST=JRPS)(USER=a_ravi))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.201)(PORT=49290)) * establish * HRDEMO * 12518
    TNS-12518: TNS:listener could not hand off client connection
    —————————————————————————

    —————————————————————————
    System parameters with non-default values:
    processes = 450
    memory_target = 1G
    control_files = “C:\APP\A_RAVI\PRODUCT\11.2.0\HCMDEMO\ORADATA\HRDEMO”
    db_block_size = 8192
    compatible = “11.2.0”
    db_recovery_file_dest = “C:\app\a_ravi\product\11.2.0\HCMDEMO\recovery\HRDEMO”
    db_recovery_file_dest_size= 2G
    undo_tablespace = “PSUNDOTS”
    remote_login_passwordfile= “EXCLUSIVE”
    db_domain = “JRPS”
    dispatchers = “(PROTOCOL=TCP)(dispatchers=3)”
    audit_file_dest = “C:\APP\A_RAVI\PRODUCT\11.2.0\HCMDEMO”
    audit_trail = “DB”
    db_name = “HRDEMO”
    open_cursors = 300
    diagnostic_dest = “C:\APP\A_RAVI\PRODUCT\11.2.0\HCMDEMO\DIAGNOSTICS\HRDEMO”
    —————————————————————————

    Ravi Jaganathan

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Scroll to Top