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

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