OVD 10g Validating Connection Of Database Adapter Using OCI JDBC Driver Fails With Java.Lang.Reflect.Invocationtargetexception
Last updated on MARCH 08, 2017
Applies to:Oracle Virtual Directory - Version 10.1.4.3.0 to 10.1.4.3.0 [Release 10gR3]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms