I have a 12c DB running on Linux and a separate machine running Tomcat with ORDS 3.0.4 on Linux as well service several APEX apps.
Everything worked fine until yesterday when the load increased to several hundreds of users with demanding needs
It looks like a configuration issue that is set probably to defaults
Any idea where the connection max limit configurations may be?
Correct. This is an configuration issue, mainly the JDBC Configuration issue for ORDS.
Refer the following links how you can optimize your JDBC Configuration for ORDS:
- Kris' blog: Apex Listener jdbc/security setup
- ORA-00001: Unique constraint violated: Installing Oracle XE, ORDS and Apex on CentOS - Part Three: Additional configurat…
NOTE: See the "Optimizing ORDS" section
Also the following blog post series can help you how to set up optimized configuration for ORDS:
I believe you should focus on this error message: ORA-12516, TNS listener could not find available handler with matching protocl stack
Check the status of the listener:
'lsnrctl status LISTENER'
Also, a restart of the listener might help.
If you find this answer helpful / correct please mark the thread accordingly.
>>Everything worked fine until yesterday when the load increased to several hundreds of users with demanding needs
Did you check your connection pool sizes? The default is 10.