I have java application that connects to an Oracle 19 database. We connect using the ojdbc8, ucp, ons libraries version 19.9.0.0.
I see this error in this log with a very vague error message. What exactly is occurring at oracle.ucp.common.Core.initialize(Core.java:1827) ~[ucp-19.9.0.0.jar:19.9.0.0.0] to cause an IllegalStateException ?
Caused by: java.sql.SQLException: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
java.lang.IllegalStateException: unable to start connection creation task
oracle.ucp.UniversalConnectionPoolException: Exception occurred while enabling failover with remote ONS subscription
... 12 more
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:930) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1964) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:202) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4284) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1920) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1883) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1868) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at com.wellsfargo.isg.logmanager.caldbsink.database.OracleCalDatabaseConnection.getConnection(OracleCalDatabaseConnection.java:126) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
at com.wellsfargo.isg.logmanager.caldbsink.kafka.CalDbSinkTask.put(CalDbSinkTask.java:156) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
... 11 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Core.initialize(Core.java:1850) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:710) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:926) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1964) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:202) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4284) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1920) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1883) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1868) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at com.wellsfargo.isg.logmanager.caldbsink.database.OracleCalDatabaseConnection.getConnection(OracleCalDatabaseConnection.java:126) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
at com.wellsfargo.isg.logmanager.caldbsink.kafka.CalDbSinkTask.put(CalDbSinkTask.java:156) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
... 11 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Core.initialize(Core.java:1827) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:710) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:926) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1964) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:202) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4284) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1920) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1883) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1868) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at com.wellsfargo.isg.logmanager.caldbsink.database.OracleCalDatabaseConnection.getConnection(OracleCalDatabaseConnection.java:126) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
at com.wellsfargo.isg.logmanager.caldbsink.kafka.CalDbSinkTask.put(CalDbSinkTask.java:156) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
... 11 more
Caused by: java.lang.IllegalStateException: unable to start connection creation task
at oracle.ucp.common.Core.initialize(Core.java:1827) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:710) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:926) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1964) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:202) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4284) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1920) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1883) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1868) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at com.wellsfargo.isg.logmanager.caldbsink.database.OracleCalDatabaseConnection.getConnection(OracleCalDatabaseConnection.java:126) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
at com.wellsfargo.isg.logmanager.caldbsink.kafka.CalDbSinkTask.put(CalDbSinkTask.java:156) ~[logmanager-caldb-sink-connector-R21.10.00.72.jar:R21.10.00.72]
... 11 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Exception occurred while enabling failover with remote ONS subscription
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:304) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:318) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.ONSDriver.start(ONSDriver.java:101) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Topology.onsDriver(Topology.java:533) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Service$3.<init>(Service.java:879) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Service.create(Service.java:850) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Service.create(Service.java:577) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Topology.create(Topology.java:161) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Core$6.call(Core.java:1791) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Core$6.call(Core.java:1779) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.Core.initialize(Core.java:1826) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:710) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:926) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1964) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:202) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4284) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1920) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1883) ~[ucp-19.9.0.0.jar:19.9.0.0.0]
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1868) ~[ucp-19.9.0.0.jar:19.9.0.0.0]