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 FEBRUARY 09, 2024

Applies to:

Symptoms

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.

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.