After changing the password for the Banner database user Banworx, the RA Banner Agent fails with the following error in the logs:
20180801/163427.842 - U02000107 Connection object 'CONN.NAME' with time stamp '1533155624000' was successfully transferred to the Agent.
20180801/163443.282 - Database login error
20180801/163443.282 - Error connecting to the database. Check the JDBC login assigned to the agent and verify that it is correct.
A forced stack trace is created with the error:
java.sql.SqlRecoverableException: IO error: Connection reset
Either the connection object passwords have not been changed, or the password is cached in the jdbc.
Release: AOMWSA99000-3.X-Automic Operations Manager-Web Services Base-Pack Agent (Incl. 5
Ensure that the passwords are changed in the connection objects. If this has already been done, then load a fresh JDBC following the steps below:
-Stop the RA Banner Agent
-Navigate to the Agent's bin/lib directory
-Copy the jdbc jar file to another folder as a backup
-Download the relevant .jar file for the database being used
-Delete the old file and replace it with the new jdbc jar file
-Restart the Agent