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



Share this article :

Out of sudden, you screen keep prompting below notification while logging to Oracle using SQLplus.

sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Apr 3 23:44:53 2014

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

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

Solution

Determine the current value of PROCESSES parameter.

SHOW PARAMETER PROCESSES

Increase the parameter value (below example is for spfile)

ALTER SYSTEM SET PROCESSES=NEW_VALUE SCOPE=spfile

Tags:

Related posts

Oracle Database Auditing
Find Current Logged Oracle User
How to Start, Stop & Check the Status Oracle Enterprise Manager Console
How to Find / List Available Schema in Oracle
© 2018 ITsiti. All Rights Reserved
Powered by KEEM