Hi all,
- RAC 11.2.0.2.3 version, 5 nodes cluster on Redhat Linux 5.5
- Database in dedicated mode not shared mode.
Developers are getting the following error when trying to connect to the database.
[oracle@app01 admin]$ sqlplus APP_USER@APP_WEB
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 13 17:17:43 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12516: TNS:listener could not find available handler with matching protocol
stack
Enter user-name:
I have checked MOS and I have found that the cause could be the number of PROCESSES or SESSIONS are reached so I checked the parameters and I can't see those values reached ... ; Any idea what could be the cause of these ORA-12516 errors...?
-bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 13 17:43:16 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select count(*) from gv$process;
COUNT(*)
----------
376
SQL> select count(*) from gv$session;
COUNT(*)
----------
348
SQL> show parameter session
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
...
sessions integer 1528
SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
...
processes integer 1000
SQL>