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
Last updated on DECEMBER 04, 2017
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.
***Checked for relevance on 09-Dec-2012***
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.
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 hundreds of Community platforms