RA Banner Agent does not start after changing database password

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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
 

Environment

Release: AOMWSA99000-3.X-Automic Operations Manager-Web Services Base-Pack Agent (Incl. 5
Component:

Cause

Either the connection object passwords have not been changed, or the password is cached in the jdbc. 

Resolution

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