My Oracle Support Banner

Intermittent 503 Service Unavailable - The database user for the connection pool named |apex|pu| is not authorized to proxy to the schema named <schema> (Doc ID 2770463.1)

Last updated on MAY 10, 2022

Applies to:

Oracle REST Data Services - Version 20.4.1 and later
Information in this document applies to any platform.

Symptoms

ERROR
-----------------------

503 Service Unavailable
The database user for the connection pool named |apex|pu| is not authorized to proxy to the schema named <schema>


<22-Mar-2021 10:43:27,515 o'clock GMT> <Warning> <oracle.dbtools> <BEA-000000> <The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named <schema>
oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named <schema>
at oracle.dbtools.common.jdbc.ConnectionPoolExceptions.from(ConnectionPoolExceptions.java:46)
at oracle.dbtools.common.jdbc.ConnectionPoolExceptions.from(ConnectionPoolExceptions.java:53)
at oracle.dbtools.common.jdbc.DataSourceConnection.getPooledConnection(DataSourceConnection.java:233)
at oracle.dbtools.common.jdbc.DataSourceConnection.getPooledConnection(DataSourceConnection.java:192)
at oracle.dbtools.common.jdbc.DataSourceConnection.getDefaultConnection(DataSourceConnection.java:145)
Truncated. see log file for complete stacktrace
Caused By: oracle.dbtools.common.ucp.ConnectionLabelingException: Error occurred when attempting to configure url: jdbc:oracle:thin:@//<IP>:<PORT>/clover with labels: {oracle.dbtools.jdbc.label.schema=<schema>}
at oracle.dbtools.common.ucp.LabelingCallback.handle(LabelingCallback.java:147)
at oracle.dbtools.common.ucp.LabelingCallback.proxyToSchema(LabelingCallback.java:210)
at oracle.dbtools.common.ucp.LabelingCallback.configure(LabelingCallback.java:76)
at oracle.ucp.common.UniversalConnectionPoolImpl.getAvailableConnectionHelper(UniversalConnectionPoolImpl.java:711)
at oracle.ucp.common.UniversalConnectionPoolImpl.getAvailableConnection(UniversalConnectionPoolImpl.java:650)
Truncated. see log file for complete stacktrace
Caused By: java.sql.SQLRecoverableException: IO Error: An existing connection was forcibly closed by the remote host
at oracle.jdbc.driver.T4CConnection.closeProxySession(T4CConnection.java:2250)
at oracle.jdbc.driver.PhysicalConnection.openProxySession(PhysicalConnection.java:2711)
at oracle.dbtools.common.ucp.LabelingCallback$ProxySchemaTask.call(LabelingCallback.java:283)
at oracle.dbtools.common.ucp.LabelingCallback$ProxySchemaTask.call(LabelingCallback.java:271)
at oracle.dbtools.common.concurrent.RetryStrategy.execute(RetryStrategy.java:45)
Truncated. see log file for complete stacktrace
Caused By: java.io.IOException: An existing connection was forcibly closed by the remote host
at sun.nio.ch.SocketDispatcher.write0(Native Method)
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:51)
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)
at sun.nio.ch.IOUtil.write(IOUtil.java:65)
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:469)
Truncated. see log file for complete stacktrace
>
Mar 22, 2021 10:43:27 AM  
SEVERE: The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named <schema>
oracle.dbtools.url.mapping.TargetNotAvailableException: The database user for the connection pool named |apex|pu|, is not authorized to proxy to the schema named <schema>

 

Environment checks:

Changes

When the user calls the URL after a period of inactivity, the 503 Service Unavailable is generated.

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.