Duplicate Entries In Newly Installed OID 10g (On Separate Metadata Repository Database) (Doc ID 961156.1)

Last updated on OCTOBER 04, 2019

Applies to:

Symptoms

Scenario:

Application Server (AS) / Oracle Internet Directory (OID) 10g, for example, 10.1.2.0.2 installed with a separate Metadata Repository Database (MR DB) on 10.2 RDMS, prepared with the Metadata Repository Creation Assistant (MRCA or RepCA).

Had problems with MRCA at first - it would not work with the minimum database requirements, but after setting 3GBs for the sga, it completed successfully.

After that, installed a fresh new AS/OID 10.1.2.0.2, which also finished successfully.

Next, an upgrade of Portal to 10.1.4 failed. Upon further investigation, found out there were two duplicate entries for cn=PUBLIC in OID.  Saved both entries to an ldapsearch output, then deleted both entries from OID and recreated only one, and the Portal upgrade went fine after that.

Next, tried applying the AS/OID 10.1.2.3.0 Patchset but it failed. Found out that there were also duplicates for "cn=Directory Integration Platform,cn=Products,cn=OracleContext" and for many other entries under this DIT/tree.

Restored back to prior to Portal 10.1.4.0 upgrade and, by following checks from <Note 351138.1>,
found out that there missing indexes from the OID table ods.ct_dn.

Due to all the existing duplicated entries, unable to use bulkload with the index option to recreate all OID indexes.

Why are there duplicate entries in a fresh new installation, where no custom data was ever added with neither bulkload nor ldap tools?

Changes

Cause

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