Forum Stats

  • 3,750,412 Users
  • 2,250,174 Discussions
  • 7,866,971 Comments

Discussions

pool named |apex|rt| is not authorized to proxy to the schema named APEX_PUBLIC_USER

hob
hob Member Posts: 15 Bronze Badge

Hi,

we use ORDS 19.1 with Tomcat for Apex 20.2 in Oracle 19.

catalina.out shows errors like

2021-07-16 11:01:21 WARNUNG : Der Datenbankbenutzer für den Verbindungspool namens |apex|rt| ist nicht autorisiert, das Schema APEX_PUBLIC_USER als Proxy zu verwenden

oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: Der Datenbankbenutzer für den Verbindungspool namens |apex|rt| ist nicht autorisiert, das Schema APEX_PUBLIC_USER als Proxy zu verwenden

       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)

...

Caused by: oracle.dbtools.common.ucp.ConnectionLabelingException: Error occurred when attempting to configure url: unknown with labels: {oracle.dbtools.jdbc.label.schema=APEX_PUBLIC_USER}

       at oracle.dbtools.common.ucp.LabelingCallback.handle(LabelingCallback.java:147)

       at oracle.dbtools.common.ucp.LabelingCallback.proxyToSchema(LabelingCallback.java:210)

...

Caused by: java.lang.NullPointerException

       at oracle.net.ns.NIOPacket.writeToSocketChannel(NIOPacket.java:293)



We don't use Restful Services.

The Apex applications work fine, so it's not a major issue.

I'm just interested: Why does the error occur?

It seems, APEX_REST_PUBLIC_USER (apex_rt) need to connect through APEX_PUBLIC_USER. Why is that?

Thanks a lot.

Regards

Holger

Answers