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

Applications Manager version 9.4.2 introduced a change where the ojdbc*.jar is loaded into client java process before Launching so a oracle driver is no longer needed in the client's jar directory.