After Upgrading Database 11gR2 for OID 11g, e.g. from 18.104.22.168 to 22.214.171.124, Oracle (Database) Processes CPU Utilization is 100%, and Unable to Authenticate via OID
Last updated on JUNE 25, 2018
Applies to:Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.
Oracle Internet Directory (OID) 11g.
OID and its database run on the same server.
Since upgrading the database server, e.g., from 126.96.36.199 to 188.8.131.52, 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:
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
BASE DN = cn=users,dc=example,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
Database was upgraded.
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