No suitable driver found for jdbc:oracle:thin error when opening Database Browser

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Opening the Applications Manager Database Browser may result in the below error:

 java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//master.hostname.example:1521/AMMASTER

Cause

Ojbc*.jar driver found in $AW_HOME/web/classes may be incompatible

Environment

Release : 9.3.x

Component : APPLICATIONS MANAGER

Resolution

Solution:

Ensure the ojdbc*.jar version in the $AW_HOME/web/classes directory or %AW_HOME\web\classes (Windows) directory is the most suitable version for the Oracle Client/Server versions. Refer to Oracle if needed.

A restart of Applications Manager processes or service (Windows) is required to register any jar file changes.

Workaround:

If the issue still exists, copy the ojdbc*.jar file from the $AW_HOME/web/classes directory or %AW_HOME\web\classes (Windows) directory to the Client PC's jars directory. The jars directory is located in the same directory as the RunClient.jar file.

Additional Information

The workaround is currently under investigation to determine why it works and why it is required in the first place in a very small number of environments.