My Oracle Support Banner

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 JULY 26, 2024

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

 

For OID/DIP 11g or 12c with EBS Provisioning, use the following Note instead:      After Updating The APPS User Password In The E-Business Suite, User Updates From OID To E-Business Fail With ORA-01017 Errors In The Provisioning Tracefile (Doc ID 1088803.1)

 

OID/DIP 10g Only:

The database password for Portal, Apps, or other product used with provisioning with OID 10g, 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
-------------------------------------------------------------------------------
<profile number>_<profile number> - 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

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

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