TCP Timeout Issue with UCP ORA-01017: Invalid Username/Password (Doc ID 2942503.1)

Last updated on APRIL 16, 2023

Applies to:

Symptoms

J2EE Application which is using Oracle Universal Connection Pool (UCP) version (19.16.0.0) to connect to Oracle RAC Database (version RU 19.16) with SCAN listener configured.
The application encounter experienced issue under the flows below,
1. UCP first created a JDBC connect to RAC successfully.
2. Idle the JDBC connection over 90mins.
3. Database Server dropped the connection by Dead Connection Detection (DCD).
4. UCP detected a invalid JDBC connection and trying to re-create a new one.
However, it fails with ORA-01017.

 
 Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
: [oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336), oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59), oracle.ucp.jdbc.oracle.OracleDriverConnectionFactoryAdapter.createConnection(OracleDriverConnectionFactoryAdapter.java:117), oracle.ucp.common.Database.createPooledConnection(Database.java:256), oracle.ucp.common.Service$2.exec(Service.java:638), oracle.ucp.common.Service$2.exec(Service.java:635), oracle.ucp.actors.InterruptableActor.doAction(InterruptableActor.java:128), oracle.ucp.common.Service.createConnectionInterruptably(Service.java:635), oracle.ucp.common.Service.create(Service.java:815), oracle.ucp.common.Service.create(Service.java:583), oracle.ucp.common.Topology.create(Topology.java:161), oracle.ucp.common.Core.growBorrowed(Core.java:1091), oracle.ucp.common.UniversalConnectionPoolImpl.helpGrowBorrowed(UniversalConnectionPoolImpl.java:365), oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionWithoutCountingRequests(UniversalConnectionPoolImpl.java:311), oracle.ucp.common.UniversalConnectionPoolImpl.borrowConnectionAndValidateHelper(UniversalConnectionPoolImpl.java:190),

The issue happens with below JDBC & UCP versions
- 19.16.0.0
- 19.17.0.0
- 19.18.0.0
- 21.9.0.0

Cause

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