Validate Connection Fails with java.lang.reflect.InvocationTargetException on OVD 10g Database Adapter on Solaris, Works on Linux (Doc ID 404470.1)

Last updated on JUNE 03, 2024

Applies to:

Symptoms

• In 10.1.4 OVD on Solaris 9, when creating a Database Adapter using "Oracle - Oracle OCI Drivers", "Validate Connection" fails with:
  

  java.lang.reflect.InvocationTargetException

• It works fine on SuSE Linux 9
• The java.lang.reflect.InvocationTargetException error occurs immediately after trying to validate the connection. There is no "pause" while it attempts to connect to the database (like when using THIN drivers)
• lsof command indicates that the OVD java process is indeed using the correct ojdbc14.jar file from the oci directory:
  

  java 23394 root txt VREG 311,5 1536979 913 /opt/ovid/oci/ojdbc14.jar

• adapters.os_xml on Solaris doesn't show the db adapter, however it is successfully added to this file on Linux
• The connect string used on Solaris matches that on Linux
• Oracle Client version 10.1.0.2 is installed in the system
• A sqlplus connection to the database is successful from the OVD system
• Java error/trace stack when attempting to start the OCI driver shows:
  

Changes

The ojdbc14.jar file was moved to in a newly created directory ($OVD_HOME/oci) per:

<Bug 5666103> - NEED INSTRUCTIONS ON SETTING UP OVD FOR OCI DRIVER.

The connection validation also fails when the ojdbc14.jar file is placed in the $OVD_HOME/plugins/library directory

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.