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/test@mydb

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.

SiteGround Black Friday Sale Below Banner

Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed

The following two tabs change content below.
Anil Kumar
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

  • 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

    • I am not familiar with PeopleSoft Seed database.

Siteground SALE
70% OFF SiteGround WordPress Hosting – $2.95/month (Exclusive Offer !!!)