After Applying OID 11g Bundle Patch (BP) (11.1.1.7.1, FA BP Patch 11.1.1.7.5, or higher), or Partitioning Indexes on the OID DB, oiddiag Reports Missing Indexes (e.g., Index PN_DN, etc) (Doc ID 1924189.1)

Last updated on JANUARY 30, 2017

Applies to:

Oracle Internet Directory - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

Scenario 1:

If a DBA changes Oracle Internet Directory (OID) related indexes into partitioned indexes in the OID Database (DB), oiddiag may report them as missing, for example:

Mon Jan 30 13:07:38 IST 2017
 OIDDIAG Executing: [oracle.ldap.oiddiag.dit.OidDiagDIT15, Report the Missing Index Names]
Mon Jan 30 13:07:39 IST 2017
Diagnotics Information:

The Indexes which are missing:
RP_DN
DN_MODIFIERSNAME
ST_OBJECTCLASS
VA_OBJECTCLASS
DN_UNIQUEMEMBER
UV_ORCLGUID


Mon Jan 30 13:07:39 IST 2017
Done Executing: [oracle.ldap.oiddiag.dit.OidDiagDIT15, Report the Missing Index Names

 

Scenario 2:

After applying Oracle Internet Directory (OID) 11g Bundle Patch (BP) 11.1.1.7.1 or higher, or Fusion Apps (FA) BP Patch 11.1.1.7.5 or higher, as per Document 1614114.1, oiddiag reports PN_DN index is missing, for example:

...<snip>...
Thu Sep 04 12:44:29 EDT 2014
OIDDIAG Executing: [oracle.ldap.oiddiag.dit.OidDiagDIT04, Details of some of the indexes owned by 'ODS' database user]
Thu Sep 04 12:44:29 EDT 2014
Diagnotics Information:

columns of index rp_dn: [CT_DN.PARENTDN, CT_DN.RDN]
columns of index ep_dn: [CT_DN.ENTRYID, CT_DN.PARENTDN]
columns of index pn_dn: []
columns of index ei_attrstore: [DS_ATTRSTORE.ENTRYID]

Thu Sep 04 12:44:29 EDT 2014
Done Executing: [oracle.ldap.oiddiag.dit.OidDiagDIT04, Details of some of the indexes owned by 'ODS' database user
...<snip>...

  
Doublechecking against Document 969583.1 confirms it:

  

Is this expected?

 

Solution

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