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

Document ID : KB000088024
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
Environment:
OS Version: N/A
Cause:
Cause type:
Configuration
Root Cause: OAE Login object does not match the Oracle OEBS Login username/password.
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