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
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 |