OAE Agent fails to start with "ORA-01017: invalid username/password; logon denied" error

Article Id: 88024
Status: Published
Updated On: 15-04-2018 08:03
Legacy Id: 000009861
Products:
CA Automic Applications Manager (AM)
Issue/Introduction:

Error Message :
ErrorMsg: AwE-5001 Database Query Error (12/12/17 4:14 PM)
Details: getConnection
null
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
...

Starting the Oracle Applications Extension (OAE) Agent fails to go into a RUNNING status. The above error message is seen in the Web client and/or AgentService<timestamp>.log.

This behavior is generally seen after the Automation Engine (Master), Agents, and/or databases have been stopped for maintenance. During the maintenance, the Oracle E-Business Suite (OEBS) username/password is changed without updating the Applications Manager's OAE login object.

Cause:

Cause type:
Configuration
Root Cause: OAE Login object does not match the Oracle OEBS Login username/password.

Environment:

OS Version: N/A

Resolution:

Ensure that the OAE login object in Applications Manager matches the login defined for OEBS.

It is likely the password has been changed on the OEBS side, in which case the OAE login object also needs to be updated.

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information:

Workaround :
N/A