Banner Agent listed as unavailable after moving Banner Database

book

Article ID: 225057

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

After moving the Banner database to a new server, the Banner Agent status is listed as unavailable instead of Running.

The AgentService<timestamp>.log for the Banner Agent show the following error:

10:31:52.482 AgentService: BannerAgentImpl: getConnection: [email protected]
ErrorMsg: Database login error
Details: Error connecting to the database. Check the JDBC login assigned  to the agent and verify that it is correct.
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)

The above error is referring to the Banner JDBC Connection object called "[email protected]". This value will likely differ on the environment.

Cause

The Banner Agent JDBC login needs to be updated with the correct DB information.

Environment

Release : 9.x

Component :

Resolution

The Banner JDBC Connection needs be updated. To edit the Banner JDBC Connection:

1. Select the Logins Selector button or select Object Admin > Administration > Logins > find and edit the Banner JDBC Connection object.

2. Make necessary changes to Userid, Password, Host, Port, Service Name, etc. 

3. Apply/OK

4. Restart Banner Agent