ORA-7445 [KGLUNPIN()+55] with High CPU and Session Hang (Doc ID 1618048.1)

Last updated on FEBRUARY 18, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Consistently encountering High CPU and session hangs with ORA-7445 [kglUnPin] reported in the alert log:

Wed Oct 16 14:19:44 2013
Archived Log entry 50303 added for thread 1 sequence 50362 ID 0xddbc60 dest
1:
Wed Oct 16 14:20:35 2013
ORA-00060: Deadlock detected. More info in file
/u01/app/oracle/diag/rdbms/hmuprod/hmuprod/trace/hmuprod_ora_3030.trc.
Wed Oct 16 14:22:41 2013
Thread 1 cannot allocate new log, sequence 50364
Private strand flush not complete
 Current log# 15 seq# 50363 mem# 0:
/u05/app/oracle/oradata/hmuprod/redo15a.rdo
 Current log# 15 seq# 50363 mem# 1:
/u06/app/oracle/oradata/hmuprod/redo15b.rdo
Thread 1 advanced to log sequence 50364 (LGWR switch)
 Current log# 4 seq# 50364 mem# 0:
/u05/app/oracle/oradata/hmuprod/redo04a.rdo
 Current log# 4 seq# 50364 mem# 1:
/u06/app/oracle/oradata/hmuprod/redo04b.rdo
Wed Oct 16 14:22:47 2013
Archived Log entry 50304 added for thread 1 sequence 50363 ID 0xddbc60 dest
1:
Wed Oct 16 14:25:18 2013
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xAB]
[PC:0x939D869, kglUnPin()+55] [flags: 0x0, count: 1]
...
...
Wed Oct 16 14:37:16 2013
opiodr aborting process unknown ospid (11527) as a result of ORA-609
Wed Oct 16 14:37:17 2013
opiodr aborting process unknown ospid (10844) as a result of ORA-609
Wed Oct 16 14:37:18 2013
opiodr aborting process unknown ospid (11514) as a result of ORA-609
Wed Oct 16 14:37:47 2013
Active Session History (ASH) performed an emergency flush. This may mean that
ASH is undersized. If emergency flushes are a recurring issue, you may
consider increasing ASH size by setting the value of _ASH_SIZE to a
sufficiently large value. Currently, ASH size is 33554432 bytes. Both ASH
size and the total number of emergency flushes since instance startup can be
monitored by running the following query:
select total_size,awr_flush_emergency_count from v$ash_info;
Wed Oct 16 14:37:48 2013
Errors in file
/u01/app/oracle/diag/rdbms/hmuprod/hmuprod/trace/hmuprod_ora_26693.trc
(incident=505439):
ORA-07445: exception encountered: core dump [kglUnPin()+55] [SIGSEGV]


The call stack from the trace file shows functions like:

... kzxcGetNumLeafPrivs <- qmcGetACL_int <- qmcGetACL <- qmcCheckPrivilegesInternal2 <- qmcCheckPrivilegesInternal  <- qmcCheckPrivileges <- psdnopCheck <- psdnop <- pihtConnectAuth <- nhpNewConnection  <- nhpGetConnection <- nhpStartRequest <- nhpReqBegin <- pihtqg <- spefcifa <- spefmccallstd <- pextproc <- PGOSF589_peftrust <- PGOSF633_psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr

 

Changes

 None.

Cause

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