java.sql.SQLException: &#65533 When Connecting To MOUNTED Databases As Sys User With OJDBC OCI and UCP On Oracle JDBC Versions 12.2+ (Doc ID 2716388.1)

Last updated on FEBRUARY 10, 2022

Applies to:

Symptoms

Attempts to use JDBC OCI  and UCP libraries to establish a Java BEQ connection as "sys" user to Oracle databases running in MOUNTED mode. The connection fails with the stack trace below:


Exception in thread "main" java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.eclipse.jdt.internal.jarinjarloader.JarRsrcLoader.main(JarRsrcLoader.java:61)
Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: �
        at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
        at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
        at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:928)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1961)
        at oracle.ucp.jdbc.PoolDataSourceImpl.access$400(PoolDataSourceImpl.java:201)
        at oracle.ucp.jdbc.PoolDataSourceImpl$31.build(PoolDataSourceImpl.java:4279)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1917)
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1880
        at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1865)
        at delphix.ojdbc.App.main(App.java:88)
        ... 5 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: �
        at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
        at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59)
        atoracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:134)
        atoracle.ucp.common.Database.createPooledConnection(Database.java:256)
        at oracle.ucp.common.Topology.start(Topology.java:247)
        at oracle.ucp.common.Core.start(Core.java:2361)
        at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBas e.java:685)
        at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129)
        at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:924)
        ... 12 more
Caused by: java.sql.SQLException: �
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1157)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:1049)
        at oracle.jdbc.driver.T2CConnection.getServerSessionInfo(T2CConnection.java:1335)
        at oracle.ucp.jdbc.oracle.OracleDataSourceConnectionFactoryAdapter.createConnection(OracleDataSourceConnectionFactoryAdapter.java:107)
        ... 18 more

This problem has been observed on JDBC versions 12.2, 18c, and 19c. This problem does not occur on version 12.1. 

Changes

Cause

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