Hello everyone,
While i was working on a new APEX applciation ORDS suddenly stopped working after i run a query from a view that fetches data from multiple remote databases and i get this error when i run my report.
ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|rt| had the following error(s): Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use - [ 10, 10, 60, 50, 0, 10, 1, 0, 9 ]