Static Application Images / Static Workspace Images Not Displaying after Moving from Oracle HTTP Server to ORDS (Doc ID 2473539.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Symptoms

1. Apex 5.0.3 in 11.2.0.4 DB with no invalids.

2. APEX_LISTENER and APEX_REST_PUBLIC_USER schemas in place.

3. ORDS 18.3 and ORDS related schemas exist.

4. Moved from OHS to ORDS 18.3 on Tomcat and application working fine but no images.

5. Regular apex images show up okay and http://machine:port/i/apex_version.txt shows - 5.0.3.

6. ords log shows:
14-Nov-2018 11:18:28.416 WARNING [http-nio-8080-exec-9] . The database user for the connection pool named |apex|rt|, is not authorized to proxy to the schema named <USER>
oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The database user for the connection pool named |apex|rt|, is not authorized to proxy to the schema named <USER>
      at oracle.dbtools.common.jdbc.ConnectionPoolExceptions.from(ConnectionPoolExceptions.java:46)

7. View source of the page shows ->

<link rel="shortcut icon" href="revstream/static-files-not-configured/104/files/static/v48Y/favicon.ico"> <link rel="icon" sizes="16x16" href="revstream/static-files-not-configured/104/files/static/v48Y/favicon.ico"> <link rel="icon" sizes="32x32" href="revstream/static-files-not-configured/104/files/static/v48Y/favicon.ico"> <link rel="apple-touch-icon" sizes="180x180" href="revstream/static-files-not-configured/104/files/static/v48Y/favicon.ico"

which matches the problem described in <Note 2004672.1> Receive "There are Issues with the Configuration of The Static Files..." After Upgrading to APEX 5.0

However, all steps in in the note fail to resolve the issue.

Changes

 Moved from OHS to ORDS.

Cause

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