OVD 10g Validating Connection Of Database Adapter Using OCI JDBC Driver Fails With Java.Lang.Reflect.Invocationtargetexception (Doc ID 1157888.1)

Last updated on MAY 31, 2024

Applies to:

Symptoms

Oracle Virtual Directory (OVD) 10g, i.e., patched to 10.1.4.3.0 and also with latest merge patch as per <Note 807468.1> already applied.

Using JDBC thin driver for Database (DB) Adapter validates ok and it works fine.

Now creating a Database Adapter using OCI jdbc driver against the same DB and credentials that works with JDBC thin driver.

(Note:  OCI driver needed for Data Guarded databases primary and failover, where it should detect if the primary is unavailable and failover to the secondary database.)

When validating the OCI connection, it fails with  popup window titled Could not validate connection with error:

Steps to reproduce:
1.  Deploy ojdbc jar file for the DB version via OVD Manager > right click on Server > Manage > Server Libraries.
2.  Create new DB adapter as per <Note 387529.1>, but selecting OCI driver as the type.
3.  Error message Java.Lang.Reflect.Invocationtargetexception appears immediately when trying to validate the connection.

Also tried solution from <Note 465570.1> but it did not help.

Cause

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