Maximum value of Processes in Oracle 11g
Hi,
In our application, we do get the following error frequently.
ORA-12516, TNS:listener could not find available handler with matching protocol stack
When i searched about it, I learnt that the processes /sessions used might be exceeded.
So, I'm trying to alter the values of the system parameters - Processes & sessions for my DB.
The following link says the maximum value for PROCESSES is 'operating system dependent'
http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams188.htm#REFRN10175
The DB Host machine is Windows Server Enterprise and its 32-bit machine.
The DB is *"Oracle Database 11g Enterprise Edition Release 11.2.0.1.0"*
Can you please help me find out the maximum value of the PROCESSES parameter that we can set for this OS?
Let me know if my understanding of the issue is wrong.
Regards,
Tamil