Dear Team,
I had initiated and earlier question
https://asktom.oracle.com/pls/apex/asktom.search?tag=apex-202-ords-and-apache-tomcat-windows-2016-getting-it-ready-for-production It was very thoroughly answered and explained. Just as we launched this I am getting error
503 Service Unavailable
The connection pool named: |apex|rt| is not correctly configured, due to the following error(s): Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use
It was my earlier concerned that when the setup will be tested under a load how I can configured it for Production. So far I have updated the Apache Tomcat server.xml file to have 1000 threads it was 10 by default but still after sometimes the error appears.
Upon further reading I came across ORDS configuration files and look for JDBC parameters like below:
<entry key="jdbc.InitialLimit">50</entry>
<entry key="jdbc.MinLimit">1</entry>
<entry key="jdbc.MaxLimit">300</entry>
I have made these entries in the default.xml file.
My Question is whether it is enough to be add these parameter at default xml level or I have to also put these in apex_rt or apex_pu files as well. Furthermore if restarting of ords services is necessary or not.
I will appreciate the help in this regard.
The OS is 2016 Windows Datacenter, 30 GB RAM, 8 Cores, Oracle 12C, Apex 20.2 , ORDS 19.3 , Apache Tomcat 9.0
Best Regards,
Junaid.
Best Regards,
Changing in defaults.xml will take care of all pool, eg I added:
<entry key="jdbc.InitialLimit">5</entry>
<entry key="jdbc.MaxConnectionReuseCount">1000</entry>
<entry key="jdbc.MaxLimit">12</entry>
<entry key="jdbc.MinLimit">4</entry>
and then started ords
2021-03-17T01:38:00.902Z INFO Configuration properties for: |apex||
database.api.enabled=true
db.hostname=localhost
db.port=1519
db.servicename=pdb1
feature.sdw=true
jdbc.InitialLimit=5
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=12
jdbc.MinLimit=4
jdbc.auth.enabled=true
jdbc.maxRows=1000
restEnabledSql.active=true
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
security.verifySSL=false
db.password=******
db.username=APEX_PUBLIC_USER
resource.templates.enabled=true
2021-03-17T01:38:01.276Z INFO Configuration properties for: |apex|al|
database.api.enabled=true
db.hostname=localhost
db.port=1519
db.servicename=pdb1
feature.sdw=true
jdbc.InitialLimit=5
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=12
jdbc.MinLimit=4
jdbc.auth.enabled=true
jdbc.maxRows=1000
restEnabledSql.active=true
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
security.verifySSL=false
db.password=******
db.username=APEX_LISTENER
resource.templates.enabled=true
2021-03-17T01:38:01.401Z INFO Configuration properties for: |apex|pu|
database.api.enabled=true
db.hostname=localhost
db.port=1519
db.servicename=pdb1
feature.sdw=true
jdbc.InitialLimit=5
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=12
jdbc.MinLimit=4
jdbc.auth.enabled=true
jdbc.maxRows=1000
restEnabledSql.active=true
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
security.verifySSL=false
db.password=******
db.username=ORDS_PUBLIC_USER
resource.templates.enabled=true
2021-03-17T01:38:01.530Z INFO Configuration properties for: |apex|rt|
database.api.enabled=true
db.hostname=localhost
db.port=1519
db.servicename=pdb1
feature.sdw=true
jdbc.InitialLimit=5
jdbc.MaxConnectionReuseCount=1000
jdbc.MaxLimit=12
jdbc.MinLimit=4
jdbc.auth.enabled=true
jdbc.maxRows=1000
restEnabledSql.active=true
security.requestValidationFunction=wwv_flow_epg_include_modules.authorize
security.validationFunctionType=plsql
security.verifySSL=false
db.password=******
db.username=APEX_REST_PUBLIC_USER
resource.templates.enabled=true
2021-03-17T01:38:02.591Z INFO Oracle REST Data Services initialized
Oracle REST Data Services version : 20.3.0.r3011819
Oracle REST Data Services server info: jetty/9.4.30.v20200611