Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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