My Oracle Support Banner

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 MARCH 29, 2019

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

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.