My Oracle Support Banner

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:

SQL> SELECT index_name,index_type,uniqueness from dba_indexes where table_name='CT_ORCLGUID' or table_name='CT_DN';

INDEX_NAME                     INDEX_TYPE                  UNIQUENES
------------------------------ --------------------------- ---------
UV_ORCLGUID                    NORMAL                      UNIQUE
VA_ORCLGUID                    NORMAL                      UNIQUE
ST_ORCLGUID                    NORMAL                      NONUNIQUE
EP_DN                          NORMAL                      UNIQUE
RP_DN                          NORMAL                      UNIQUE

  

Is this expected?

 

Solution

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
Goal
Solution
References


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