Datasource Connection Fails With ORA-01017: invalid username/password When Using Password in Upper Case, Special Characters, or Numeric Values in Oracle Application Server 10.1.3
(Doc ID 1094936.1)
Last updated on AUGUST 22, 2020
Applies to:Oracle Containers for J2EE - Version 10.1.3.0.0 and later
Enterprise Manager for Fusion Middleware - Version 10.1.3.0.0 to 10.1.3.5.1
JDBC - Version 10.1.0.2 to 10.1.0.5 [Release 10.1]
Information in this document applies to any platform.
Using Oracle Application Server 10.1.3.4 with default JDBC driver 10.1.0.5 and Oracle Database 11g.
Datasource connection fails with:
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
Testing connections from connection pool created in Oracle Application Server Admin Console (ASC) fail with this error. This only occurs when the password of the user has a special character or a numeric value.
When the connection pool is created at first, the connection succeeds. But if the connection is then tested subsequent times, they all fail with error ORA-1017 until the user is locked due to several invalid entries.
Even restarting the application server, and testing again the connection from the connection pool makes it work the first time and fails all other times.
Connections with the same user and password containing characters in upper case, special characters, or numeric values work well from SQLPlus.
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