Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maximum value of Processes in Oracle 11g

Tamilselvi-OracleAug 30 2012 — edited Aug 30 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2012
Added on Aug 30 2012
3 comments
3,425 views