Application connectivity Test database times ORA-12516 Error

Application connectivity Test database times Ora-12516:tns:listener could 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

Log on to the database, check the parameter session, and Ora-01012:not logged on

[Oraescm@lnxtest ~]$ Sqlplus/as SYSDBA

Sql*plus:release 10.2.0.4.0-production on Tue 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 to the problem is to modify the processes parameter value, but the database is not connected at this time. You can resolve the following:

1: Stop the listening service, such as database access to the number of users to login.

Lsnrctl stop

2:sqlplus "/As SYSDBA" after landing, modify the processes value.

Because it is a test database, you can toss it, if you do not want to modify the value of processes, you can solve the problem by the following temporary workaround

1: Restart the listening service

Lsnrctl Reload

2:sqlplus "/As SYSDBA" after landing

Shutdonwn Abort

Startup

3:ps-ef|grep Ora_dbw0_$oracle_sid

Kill-9 pid;

Author: The Hermit of Xiaoxiang

Source: http://www.cnblogs.com/kerrycode/

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/