ORA-01017 after Setting up OC4J Password Indirection Using Datasources (Doc ID 742896.1)

Last updated on JULY 13, 2017

Applies to:

Oracle Containers for J2EE - Version 10.1.3.3.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

There are a number of datasources in OC4J 10.1.3.3 that have clear text passwords in the data-sources.xml configuration file.
The connections work successfully with this setup.
However, after changing the datasources to use password indirection through Enterprise Manager
console (EM), the following error is obtained:
Unable to establish connection to "SECA_CipherServices_POOL". Error message: Exception occurred testing connection.
Exception : java.sql.SQLException: ORA-01017: invalid username/password; logon denied.
 
 
 

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