OVD 11g Creating Database Adapter Via ODSM Fails With "Invalid Database Connection" (Doc ID 1490199.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Virtual Directory - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Virtual Directory (OVD) 11g, i.e., 11.1.1.6.0.

Unable to create an Oracle Database (DB) OVD Adapter through Oracle Directory Services Manager (ODSM).

Error returned on the pop-up window:

Invalid Database Connection

Using default DB Adapter configuration:
Template - Default
URL Type - Predefined Database
DB Type - Oracle Oracle Thin Drivers

The wls_ods1-diagnostic.log shows:

...<snip>...

[2012-08-29T23:17:52.663-04:00] [wls_ods1] [WARNING] [] [org.apache.myfaces.trinidadinternal.context.RequestContextImpl] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c5a3cc79c8f29b43:23ee1e07:138985791e0:-8000-00000000000191e7,0] [APP: odsm#11.1.1.2.0] Could not find partial trigger latIT from RichTable[org.apache.myfaces.trinidad.component.UIXTable$RowKeyFacesBeanWrapper@161f47, id=t4] with the supported partialTriggers syntax. The partial trigger was found with the deprecated syntax. Please use the supported syntax.
[2012-08-29T23:17:52.742-04:00] [wls_ods1] [NOTIFICATION] [] [oracle.ldap.odsm.model.ovd.config.adapters.NewDataBaseAdapterCfg] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c5a3cc79c8f29b43:23ee1e07:138985791e0:-8000-00000000000191e7,0] [APP: odsm#11.1.1.2.0] invalid DB connection[[
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}hostname:mydbserver.mycompany.com
java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)

...<etc>...

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
]]
[2012-08-29T23:17:52.744-04:00] [wls_ods1] [NOTIFICATION] [] [oracle.ldap.odsm.model.ovd.config.adapters.NewDataBaseAdapterCfg] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c5a3cc79c8f29b43:23ee1e07:138985791e0:-8000-00000000000191e7,0] [APP: odsm#11.1.1.2.0] saveChanges[[
oracle.ldap.admin.common.SaveChangeException: Invalid Database Connection
at oracle.ldap.odsm.model.ovd.config.adapters.NewAPDataBaseAdapterCfg.saveChanges(NewAPDataBaseAdapterCfg.java:413)
at oracle.ldap.odsm.ui.common.Wizard.doNext(Wizard.java:282)
at sun.reflect.GeneratedMethodAccessor6334.invoke(Unknown Source)

...<etc>....

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
]]
[2012-08-29T23:17:52.744-04:00] [wls_ods1] [NOTIFICATION] [] [oracle.ldap.odsm.ui.common.Wizard] [tid: [ACTIVE].ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: c5a3cc79c8f29b43:23ee1e07:138985791e0:-8000-00000000000191e7,0] [APP: odsm#11.1.1.2.0] doNext[[
oracle.ldap.admin.common.SaveChangeException: Invalid Database Connection
at oracle.ldap.odsm.model.ovd.config.adapters.NewDataBaseAdapterCfg.saveChanges(NewAPDataBaseAdapterCfg.java:425)
at oracle.ldap.odsm.ui.common.Wizard.doNext(Wizard.java:282)
at sun.reflect.GeneratedMethodAccessor6334.invoke(Unknown Source)

...<snip>...

 

Changes

 

Cause

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