After Upgrading Database 11gR2 for OID 11g, e.g. from 11.2.0.3 to 11.2.0.4, Oracle (Database) Processes CPU Utilization is 100%, and Unable to Authenticate via OID (Doc ID 2083655.1)

Last updated on AUGUST 29, 2019

Applies to:

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

Symptoms

Oracle Internet Directory (OID) 11g.

OID and its database run on the same server.

Since upgrading the database server, e.g., from 11.2.0.3 to 11.2.0.4, at first Portal and OID worked normally.

Suddenly, got maxed out CPU utilization errors from (oracle) database processes, and no longer able to authenticate using OID.

Database report shows the following SQL as CPU + Wait for CPU 99.73 activity:

SELECT /*+ USE_NL(store) INDEX(store EI_ATTRSTORE) INDEX(dn EP_DN) FIRST_ROWS */ /* SUBSTRING */ store.entryid, store.attrname, NVL(store.attrval, ' '), NVL(store.attrstype, ' ') FROM ct_dn dn, ds_attrstore store WHERE dn.entryid in ((SELECT /*+ INDEX(at1 VA_myattr) FIRST_ROWS */ at1.entryid FROM ct_myattr at1 WHERE ( at1.attrvalue like :4 ESCAPE '\' ) ) UNION (SELECT /*+ INDEX(at1 VA_objectclass) */ at1.entryid FROM ct_objectclass at1 WHERE at1.attrvalue = 'referral' ) ) AND ( dn.parentdn like :bdn ESCAPE '\' OR (dn.rdn = :rdn and dn.parentdn = :pdn) ) AND dn.entryid = store.entryid AND dn.entryid >= :entryThreshold AND store.attrkind = 'u' AND store.attrname in ( 'orclentrydn', 'objectclass', 'orclentrylevelaci', 'orclownerguid', 'orclresourceviewers', 'owner', 'orclisvisible', :an0, :an1, :an2, :an3 )

OID high level debugged logs do not show errors per se, but show some searches taking a long time to complete with high "DB Fetch" times, for example:

2015-11-04T09:12:26 * Exit gslfseADoSearch
2015-11-04T09:12:26 *
BASE DN = cn=users,dc=<COMPANY>,dc=com
SCOPE = 2
FILTER = (myattr=*value*)
REQD ATTRS = uid myattr

EVENT "BER READ " time : 519 micro sec
EVENT "DIME OVRD " time : 2021244932 micro sec
EVENT "PRVGRP CLS " time : 62 micro sec
EVENT "ACPGRP CLS " time : 54 micro sec
EVENT "PRE DIME " time : 227 micro sec
EVENT "DB Fetch " time : 2021243756 micro sec
EVENT "Post Dime " time : 229 micro sec
EVENT "Ber flush " time : 58 micro sec
TOTAL "Operation " time : 2021245434 micro sec

TOTAL "Worker " time : 2021245644 micro sec

END
]]