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 18, 2021
Applies to:
Oracle REST Data Services - Version 3.0.12 and laterInformation 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 |