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]
Thanks a bunch Vasudev… Can you explain why this value shld not be the original value…
It was 20 initially, but after changing it to 150 it worked for me….
Hi Satya,
I can’t say why the value of your PROCESSES parameter was set to 20. Perhaps another DBA meant to set it to 200? 150 is the default I’ve seen in most databases I’ve worked with, but the Oracle Database 11g documentation puts the default value at 100: http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams199.htm