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...!!!
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...!!!
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
ReplyDeletewhat about tnsping utility result.
DeleteCheck also LSNRCTL status too..
What do you mean by LSNRCTL status?
DeleteWhere I can find that status information?
It has working to me..Thank You lot...
ReplyDeleteWelcome My friend .
DeleteThank you very much, it works!
ReplyDeleteYou are most welcome .
Delete