Installation Guide › Installing an AIX Implementation › Run the CA RCM Installer › Complete CA RCM Server Installation on AIX/WebSphere › Install Oracle JDBC Drivers and Data Providers in the CA RCM Cluster

Install Oracle JDBC Drivers and Data Providers in the CA RCM Cluster

The Java Database Connectivity (JDBC) API supports server cluster connections to the database. When an Oracle database server hosts CA RCM databases, you install JDBC drivers on the WebSphere Application Server.

Note: The optional External Reports database exports data for use by other applications. Even if an Oracle datasource hosts all other CA RCM databases, implement the External Reports database using a Microsoft SQL Server datasource.

To install Oracle JDBC drivers and data providers in the CA RCM cluster

1. Download the ojdbc14.jar file from the Oracle Download Center to the WebSphere application server. Place the file under the following directory:

   WAS_install_root/essentials/JDBC/
   

   Note: WAS_install_root is the WebSphere application server installation directory.

2. In the WebSphere administration console, click Resources, JDBC, JDBC Providers and create a JDBC provider with the following settings:
   • Scope – CA RCM cluster
   • Database type – Oracle
   • Provider type – Oracle JDBC Driver
   • Implementation type – data source
   • Name – Oracle JDBC Driver
   • Class path – WAS_install_root/essentials/JDBC/ojdbc14.jar
3. Restart the WebSphere Application Server or the Deployment Manager service as required in your WebSphere environment to implement the new data source definitions.