ORDS access APEX but Static Images do Not Display and in log "Failed to create initialPoolSize connections while starting a pool"

(Doc ID 2364059.1)

Last updated on FEBRUARY 26, 2018

Applies to:

Oracle REST Data Services - Version 3.0.12 and later
Information in this document applies to any platform.
* The apex_rest_config.sql script was run from the correct APEX version directory.
* This is a new ORDS install and all the configuration files are correct.
* Testing the Restful Services from demo HR/EMP/GET gives 404 / not found error.

Symptoms

When running APEX / ORDS, the static images do not display when running an APEX application.

When attempting to access an APEX RESTFul Service, a  404 error error, and the following error is sent to the logs:


WARNING: Could not complete operation because expected a connection of type: ORACLE, but got a connection of type: OTHER
oracle.dbtools.common.pools.UnsupportedConnectionType: Could not complete operation because expected a connection of type: ORACLE, but got a connection of type: OTHER
  at oracle.dbtools.common.pools.ConnectionType.verify(ConnectionType.java:37)
  at oracle.dbtools.url.mapping.db.targets.SchemaTargetsProvider$SchemaLoader.load(SchemaTargetsProvider.java:279)
...
  at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool
  at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:479)
  at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:154)
  at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:730)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1093)
  at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1074)
  at oracle.dbtools.common.jdbc.DataSourceConnection.getConnection(DataSourceConnection.java:46)
  at oracle.dbtools.common.pools.DataSourceTargetImpl.connection(DataSourceTargetImpl.java:41)
  at oracle.dbtools.url.mapping.db.targets.SchemaTargetsProvider$SchemaLoader.load(SchemaTargetsProvider.java:255)
  ... 42 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool
  at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:359)


Steps to Reproduce

The issue can be reproduced at will with the following steps:
1. Install and Configure ORDS to access APEX on a PDB
2. Access APEX Builder or Admin page without Issue
3. Run any application that use static images (APEX workspace or application images) and they do not display. 
    A small square with an X is seen instead of the image.
4. Test the demo RestFul Service HR/EMP/GET and it gives 404 error.

Changes

 New Installation of ORDS and creating of relevant schemas.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms