Tag Archives: ORA-12518

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

Posted by on March 27, 2012 2 comments

Problem:

Unable to connect to SQL:

F:oracleVIS12dbtech_st11.1.0>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 27 11:31:04 2012

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

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

Solution:

Increase PROCESSES initialization parameter.

Use the following command to check the value of the PROCESSES initialization parameter in SQL*Plus:

show parameter processes

If the database was started using an spfile, then the following command can be used to change the PROCESSES initialization parameter to 500:

alter system set processes=500 scope=spfile;

If the database was started using a pfile, then the value of the processes parameter must be changed in the pfile and the database bounced.

[amazon asin=0071780262&template=iframe image&chan=default]     [amazon asin=1565922379&template=iframe image&chan=default]     [amazon asin=1430236620&template=iframe image&chan=default]