The database user for the connection pool named |apex|pu|, is not able to proxy to the schema named <schem_user>.
(Doc ID 2810884.1)
Last updated on OCTOBER 04, 2021
Applies to:Oracle REST Data Services - Version 18.1 and later
JDBC - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
ORDS is installed in 19c DB and when attempting to test RESTFul Services, we get below error:
oracle.dbtools.url.mapping.TargetNotAvailableException: The database user for the connection pool named |apex|pu|, is not able to proxy to the schema named <schem_user>. This could be a configured restriction on the maximum number of database sessions or an authorization failure.
... 78 more
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
We can connect on <schema_user> using ORDS_PUBLIC_USER as proxy from SQPLUS and SQLDEV
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document