Sunday, January 8, 2012

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

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

In a shared server environment .


Shutdown the dispatcher and add new dispatchers.
SQL> show parameter dispatchers
SQL> select name from v$dispatcher;
SQL> alter system shutdown immediate 'D001';
Add new dispatcher
SQL> alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=4)';


In dedicated Server.


PGA is fully allocated for all processes.Check PGA memory allocation.
SQL> SELECT * FROM V$PROCESS ORDER BY PGA_ALLOC_MEM DESC

Kill unnecessary Sessions for freed PGA memory



Cheers...!!!

7 comments:

  1. what about in a LOCAL Machine based database like Local XE? Am having the same problem ORA-12518 Tns: Listener could not hand off client conenction. I am able to access other databases in a servers using SQL DEVELOPER but cannot access local XE database because of the error ORA-12518 Tns: Listener could not hand off client conenction

    ReplyDelete
    Replies
    1. what about tnsping utility result.

      Check also LSNRCTL status too..

      Delete
    2. What do you mean by LSNRCTL status?
      Where I can find that status information?

      Delete
  2. It has working to me..Thank You lot...

    ReplyDelete