Hi Support,
I am using oracle 12c database and application deployed on EBS weblogic 12.2
while I tried to access my application today, I faced an issue as "Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack".
Verified the process parameter limit which was almost near the max limit so I altered the process value and increment it to 1400 using the below alter command:
alter system set processes=1400 scope=spfile;
Now, everything is fine. But I provided the process count on a vague idea.
We are not using shared server configuration
My question is:
- How do I decide the processes count. Is that based on my user count?
- Do oracle have any calculation method for this or any other dependency?
- Is processes/session count depends on RAM on the server?
Thank you for all the experts supporting us