We get the following error message, when connecting to APEX through ORDS Standalone:
The database user for the connection pool named |default|lo|, is not able to proxy to the schema named APEX_PUBLIC_USER. This could be a configured restriction on the maximum number of database sessions or an authorization failure.
Same message is sometimes mentioning APEX_PUBLIC_ROUTER instead of APEX_PUBLIC_USER
Our Config:
1 VM running 23ai FREE on OL9
1 VM running ORDS 25.2.2.204.0103 and nginx as reverse proxy on Ubuntu 24.04.3 LTS
One detail I noticed is, that from time to time the APEX_PUBLIC_USER account get locked.
All the fixes I found in the internet didn't change anything on that behaviour.
Has someone an idea how to step forward to identify the issue and fix it?
Thx in advance.
