Hi,
We have Oracle Fusion Middleware Infrastructure (Oracle Forms & Reports) 12.2.1.4.0 environment and on top of it we have deployed Oracle Rest Data Services (ORDS) 21.4 version and we have APEX installed on Oracle Data base server 19c.
Application team has created their Restful API services on apex 22.1 version for Production environment. After they created their Restful API services, Application team is not able to connect to their Rest API services and they getting an error “Failure of Web Server bridge”.
We checked the ORDS and APEX related user status, all are in open state.
Below is the error we got in ORDS logs
Caused By: oracle.dbtools.url.mapping.TargetNotAvailableException: The database user for the connection pool named |user|pu|, is not able to proxy to the schema named <schema name> This could be a configured restriction on the maximum number of database sessions or an authorization failure.
We tried to fix the issue, but still issue remains the same.
Any suggestions on this issue ?