My Oracle Support Banner

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 23, 2021

Applies to:

Oracle Containers for J2EE - Version and later
Enterprise Manager for Fusion Middleware - Version to
JDBC - Version to [Release 10.1]
Information in this document applies to any platform.


Using Oracle Application Server with default JDBC driver 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

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