Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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