My Oracle Support Banner

Invalid User/Password Error with Data Source when Password is Case Sensitive (Doc ID 1454612.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

Oracle WebCenter Portal - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

What is the reason for getting the below error when using managed data source with connection pooling:

Unable to establish connection to "<DATASOURCE_NAME>". Error message: Exception occurred testing managed data source connection. Exception: 'java.sql.SQLException: ORA-01017: invalid username/password; logon denied '.

The following can be seen in the log file when a user has tried to access an application based on this data source:  

2012-04-10 07:47:48,969: ERROR CORE tid=<ID> password.kron.datasource.KronosDB.getConnection:50(dionned Kron kron.do) - java.sql.SQLException(): ORA-01017: invalid username/password; logon denied

2012-04-10 07:47:48,970: ERROR CORE tid=<ID> password.kron.datasource.KronosDB.getConnection:50(dionned Kron kron.do) - at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:277)

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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