ORA-12516: TNS: listener cocould not find available handler with matching protocol stack

Application connection test database times ORA-12516: TNS: listener cocould not find available handler with matching protocol stack

Check the listening log file and find a large number of TNS-12516 errors

Cd/u01/app/oracle/product/10.2.0/db_1/network/log

More listener. log

TNS-12516: TNS:listener could not find available handler with matching protocol stack

13-MAY-2014 14:49:35 * (CONNECT_DATA=(SERVICE_NAME=xxx)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=GET08C0058)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.xxx.xxx)(PORT=4594)) * establish * xxx * 12516

The ORA-01012: not logged on appears when logging on to the database and checking the parameter session

[oraescm@lnxtest ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 13 14:29:57 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected.

SQL> show parameter session;

ERROR at line 1:

ORA-01012: not logged on

The solution is to modify the processes parameter value, but the database cannot be connected at this time. You can solve the problem by using the following methods:

1: Stop the listening service and log on again when the number of database access connections decreases.
Lsnrctl stop

2: After sqlplus "/as sysdba" is logged on, modify the processes value.

Because it is a test database, you can try it out. If you do not want to modify the processes value, you can solve the problem through the following temporary solution:

1: restart the listening service.

Lsnrctl reload

2: After logging on to sqlplus "/as sysdba"
Shutdonwn abort

Startup

3: ps-ef | grep ora_dbw0 _ $ Oracle_SID

Kill-9 pid;

Startup -- restart the database

References:

Http://blog.csdn.net/kellyseeme/article/details/8935208
Http://blog.csdn.net/dingli312/article/details/11394753
Http://blog.csdn.net/newhappy2008/article/details/6557662