OVD 11g Database Adapter Creation Using OCI Driver Fails with Invalid Database Connection Error
(Doc ID 1927363.1)
Last updated on NOVEMBER 25, 2019
Applies to:
Oracle Virtual Directory - Version 11.1.1.1.0 and laterInformation in this document applies to any platform.
Symptoms
Trying to create a DB Adapter from ODSM using OCI driver Fails with "Invalid Database Connection" Error
Following error is seen in the wls_ods1 diagnostic.log file
oracle.ldap.admin.common.SaveChangeException: Invalid Database Connection
at oracle.ldap.odsm.model.ovd.config.adapters.NewAPDataBaseAdapterCfg.saveChanges(NewAPDataBaseAdapterCfg.java:425)
at oracle.ldap.odsm.ui.common.Wizard.doNext(Wizard.java:282)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Example DB Adapter Settings:
URL Type: Use Custom URL
Database Type: Oracle - Oracle OCI Drivers
JDBC Driver Class : oracle.jdbc.driver.OracleDriver
Database URL : jdbc:oracle:oci:@(description=(address=(host=DB_HOSTNAME>)(protocol=tcp)(port=<DB_LISTENER_PORT>))(connect_data=SERVICE_NAME=<SERVICE_NAME>)))
Host: <DB_HOSTNAME>
Port: <DB_LISTENER_PORT>
Database Name: <SERVICE_NAME>
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |