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 OCTOBER 25, 2016

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***

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.

Cause

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