Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Database Performance Analyzer (DPA) > Replace the Oracle JDBC driver with a different version in DPA

Replace the Oracle JDBC driver with a different version in DPA

Overview

SolarWinds DPA connects to Oracle databases using a JDBC driver. This article describes how to replace the Oracle JDBC driver with a different version of the driver.

  • If you have SolarWinds DPA 9.0, to monitor Oracle 8i databases you need to install JDBC driver version 10.2.0.5 (Oracle 10g Release)
  • If you have Confio Ignite 8.3, to monitor Oracle 12c databases you need to install JDBC driver version 12.1.0.2 (Oracle 12c Release)

Environment

All DPA versions

Steps

Notes:

  • If you upgrade the JDBC driver, it could be overwritten if you reinstall or upgrade SolarWinds DPA. Depending on which version of JDBC ships with SolarWinds DPA you may need to re-install the JDBC driver as a result.
  • If you upgrade to the Oracle 12c JDBC driver (ojdbc6.jar) you must be running a JRE/JDK of at least 1.6. This is the version that ships with Ignite for Windows and Linux, but if you have upgraded or installed the 64 bit JRE/JDK, verify that it is at least 1.6. To check the version you can use the java -version command.
  • If you upgrade to the Oracle 11g JDBC driver (ojdbc5.jar), you must be running at least a JRE/JDK 1.5 or higher.
  • Oracle JDBC drivers are typically backwards compatible for two versions. If you install a 12c JDBC driver, you may not be able to monitor Oracle 9i databases. If you install an 11g JDBC driver, you may not be able to monitor 8i databases.
     
  1. Download the driver from the JDBC/UCP Download Page.
  2. Shut down SolarWinds DPA.
  3. Rename the current driver file to prevent SolarWinds DPA from using the file:
    1. Go to {ignitehome}/iwc/tomcat/webapps/iwc/WEB_INF/lib (Unix/Linux) or C:\Program Files (x86)\SolarWinds\Ignite PI\iwc\tomcat\webapps\iwc\WEB-INF\lib (Windows).
    2. Locate the current driver file and rename it. For example: Rename ojdbc14.jar (Oracle 10g driver) to ojdbc14.jar_10g.
  4. Copy the new JDBC driver into this directory, either ojdbc5.jar (11g) or ojdbc6.jar (12c).
  5. Restart SolarWinds DPA and the new driver will be used automatically.
Last modified
19:17, 22 Jun 2016

Tags

Classifications

Public