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 OCTOBER 09, 2024
Applies to:
Oracle Internet Directory - Version 11.1.1.7.0 and laterInformation 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
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>...
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
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 |