My Oracle Support Banner

OID DIP 11g Provisioning Profile Fails with: DIP-20050 DIP-20345 Error initialzing ProvPLSQLWriter - ODI Exception while Initialising PLSQL Writer : DIP_GEN_SPACE_STR (Doc ID 2178282.1)

Last updated on JANUARY 09, 2024

Applies to:

Oracle Internet Directory - Version 11.1.1 to [Release 11g]
Information in this document applies to any platform.


Setting up a Directory Integration Platform (DIP) 11g provisioning profile to synchronize, for example, Oracle Label Security (OLS) data from Oracle Internet Directory (OID) to a database.

Also following Document 1450227.1.

The profile fails with errors:

Error while initializing ProvPLSQLWriter

Log error stack example:

[2016-08-12T16:22:04.798+03:00] [wls_ods1] [ERROR] [DIP-20050] [oracle.dip.<PROFILE>] [tid: <PROFILE>] [userId: dip] [ecid: <ECID>] [APP: DIP#] connecting as : URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<DATABASE_HOSTNAME>)(PORT=<PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>))) , User : dip
[2016-08-12T16:22:04.798+03:00] [wls_ods1] [ERROR] [DIP-20345] [oracle.dip.<PROFILE>] [tid: <PROFILE>] [userId: dip] [ecid: <ECID>] [APP: DIP#] Error while initializing ProvPLSQLWriter
Error initialzing ProvPLSQLWriter - ODI Exception while Initialising PLSQL Writer : DIP_GEN_SPACE_STR
at oracle.ldap.odip.prov.ProvPLSQLWriter_2_0.initialise(
at oracle.ldap.odip.prov.ProvOIDToAppSync_2_0.initialise(
at oracle.ldap.odip.web.DIPProvBean.runOldVersion(
at oracle.ldap.odip.web.DIPProvBean.doOneIteration(
at oracle.ldap.odip.web.DIPProv_o70i40_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(
at oracle.ldap.odip.web.DIPProv_o70i40_EOImpl.doOneIteration(Unknown Source)
at oracle.ldap.odip.web.ProvQuartzJobImpl.execute(
at org.quartz.simpl.SimpleThreadPool$

(There is no "caused by" follow up stack.)

Tried restarting the entire stack, including rebooting the server, but it did not help.

Able to successfully connect from a command prompt on the OID server, using the same connect string as in the profile:


Also verified the hostname in the connect string is not a SCAN listener.





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

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