Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > Registering an Oracle database instance that uses only SHA-2 to calculate checksums

Registering an Oracle database instance that uses only SHA-2 to calculate checksums

Updated November 7, 2017

Overview

If an Oracle database instance is configured to use only SHA-2 (Secure Hash Algorithm 2) to calculate checksums, the following error message is displayed when you try to register it as a monitored instance or as the DPA repository:

An unknown error has occurred. The provided message is "Could not get JDBC Connection; nested exception is java.sql.SQLException: Oracle Error ORA-12650".

To enable DPA to connect to Oracle databases that use only SHA-2, you must update the JDBC driver as described below.

After you update the driver, DPA will not be able to connect to database instances that run Oracle 9 or earlier. If you need to monitor Oracle 9 database instances, keep the existing driver and configure other Oracle instances to use SHA-1. 

Environment

  • DPA, all versions

Resolution

DPA 11.0 and earlier

  1. Stop DPA:
    • On Windows, stop the Ignite PI Server service.
    • On Linux, run the shutdown.sh command from the DPA directory.
  2. Go to the following folder:

    <dpa_home>\iwc\tomcat\webapps\iwc\WEB-INF\lib

  3. Rename the following file:

    Original name New name
    ojdbc5-11.2.0.3.0.jar ojdbc5-11.2.0.3.0.jar.support
  4. Go to Oracle Database 12.1.0.2 JDBC Driver & UCP Downloads.
  5. Download ojdbc7.jar and place it in the following location:

    <dpa_home>\iwc\tomcat\webapps\iwc\WEB-INF\lib

  6. Download Patch 20960881 for release 12.1.0.2 from Oracle.

    For more information about this patch, see Oracle support

  7. Extract the downloaded p20960881_121020_Generic.zip file.
  8. Go to the 20960881\files\jdbc\lib\ojdbc7.jar directory and copy the entire \oracle directory.
  9. Paste the \oracle directory in the following location:

    <dpa_home>\iwc\tomcat\webapps\iwc\WEB-INF\classes

    The resulting path should be:

    <dpa_home>\iwc\tomcat\webapps\iwc\WEB-INF\classes\oracle\net\...

  10. Restart DPA:
    • On Windows, restart the Ignite PI Server service.
    • On Linux, run the startup.sh command from the DPA directory.

You can now register database instances that are configured to use only SHA-2.

DPA 11.1 and later

(This will be published when DPA 11.1 is GA.)

  1. Stop DPA:
    • On Windows, stop the Ignite PI Server service.
    • On Linux, run the shutdown.sh command from the DPA directory.
  2. Go to the following folder:

    <dpa_home>\iwc\tomcat\webapps\iwc\WEB-INF\lib

  3. Rename the following files:

    Original name New name
    ojdbc5-11.2.0.3.0.jar ojdbc5-11.2.0.3.0.jar.support
    ojdbc7-12.1.0.2.0.jar.support ojdbc7-12.1.0.2.0.jar
  4. Download Patch 20960881 for release 12.1.0.2 from Oracle.

    For more information about this patch, see Oracle support.  

  5. Extract the downloaded p20960881_121020_Generic.zip file.
  6. Go to the 20960881\files\jdbc\lib\ojdbc7.jar directory and copy the entire \oracle directory.
  7. Paste the \oracle directory in the following location:

    <dpa_home>\iwc\tomcat\webapps\iwc\WEB-INF\classes

    The resulting path should be:

    <dpa_home>\iwc\tomcat\webapps\iwc\WEB-INF\classes\oracle\net\...

  8. Restart DPA:
    • On Windows, restart the Ignite PI Server service.
    • On Linux, run the startup.sh command from the DPA directory.

You can now register database instances that are configured to use only SHA-2.

 

Last modified

Tags

Classifications

Public