OID 10g DIP Provisioning (for Portal, Apps, etc.) Fails With Profile Trace Error: ODIexception:Exception Connecting To DB :Java.Sql.Sqlexception:ORA-01017 (Doc ID 339898.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Internet Directory - Version 9.0.4 to 10.1.4 [Release 10gR1 to 10gR3]
Information in this document applies to any platform.

Symptoms

The database password for Portal, Apps, or other product used with provisioning with OID, was changed and since then the provisioning with OID fails.

Another scenario:  While installing a CPU patch on infrastructure, one of the update scripts prompted for a Portal database password, which was unknown, so manually changed the Portal password with sql / alter user command, and patch applied ok.

Ensured that the passwords for the Apps/Portal and OID's ODS users were sync'd, ran oidpasswd to ensure that the change was propogated.

However, the Provisioning fails with the following error in the trace file:
-------------------------------------------------------------------------------
Trace Log Started at Wed Nov 02 15:39:51 CST 2005
-------------------------------------------------------------------------------
ad02bcbac31c41cca586b4835bd84d55_04eee5c579b84d8a8865f32c4ed06c42 - Error in Mapping
EngineODIException: Exception Connecting to DB :java.sql.SQLException: ORA-01017: invalid
username/password; logon denied
ODIException: Exception Connecting to DB :java.sql.SQLException: ORA-01017: invalid
username/password; logon denied
at oracle.ldap.odip.gsi.DBConnector.connect(DBConnector.java:127)
at oracle.ldap.odip.prov.ProvWriter.initialise(ProvWriter.java:111)
at oracle.ldap.odip.engine.ProvThread.mapInitialise(ProvThread.java:260)
at oracle.ldap.odip.engine.ProvThread.execMapping(ProvThread.java:181)
at oracle.ldap.odip.engine.ProvThread.run(ProvThread.java:156)
java.lang.NullPointerException
at oracle.ldap.odip.gsi.DBConnector.end(DBConnector.java:209)
at oracle.ldap.odip.engine.ProvThread.mapEnd(ProvThread.java:336)
at oracle.ldap.odip.engine.ProvThread.run(ProvThread.java:161)
-------------------------------------------------------------------------------
Trace Log Started at Wed Nov 02 15:57:57 CST 2005
-------------------------------------------------------------------------------
Interface Additional Info Not Specified
Failed To Process MODIFY !!!
Failed To Process MODIFY !!![ etc, etc ]

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