Duplicate Entries In Newly Installed OID 10g (On Separate Metadata Repository Database)
Last updated on MARCH 08, 2017
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.
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?
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