ORA-7445 kghssapage on Windows 10.2.0.4 With Bundle Patches >=14 And <= 19 (Doc ID 784866.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4 - Release: 10.2 to 10.2
Generic Windows

Symptoms

This article is written specifically for ORA-07445[INT_DIVIDE_BY_ZERO] [__VInfreq__kghssapage+35] . At the time of writing the error/issue seems restricted to Windows
platforms but is still under review.

The following conditions/symptoms will be seen :-

a) ORA-07445: exception encountered: core dump [INT_DIVIDE_BY_ZERO]
[__VInfreq__kghssapage+35] [PC:0x42E5BF5] [] [] []

The above error will be seen in the alert log

b) Current SQL statement for this session will be similar to :-

Current SQL statement for this session:
SELECT TGT.TARGET_GUID, TO_DATE(LIST.UPLOAD_TIME,:B3 ) LOAD_TIME FROM
TABLE(CAST(:B1 AS EM_LOADER_UPLOAD_TIME_ARRAY)) LIST, MGMT_TARGETS TGT WHERE
TGT.TARGET_GUID = HEXTORAW(LIST.TARGET_GUID) ORDER BY DECODE(TGT.TARGET_TYPE, :
B2 ,1,2), TGT.TARGET_TYPE,TGT.TARGET_NAME

c) PLSQL Call Stack wil be similar to :-

----- PL/SQL Call Stack -----
object line object
handle number name
340D4A50 2127 package body SYSMAN.EMD_LOADER
2F340F6C 1 anonymous block

d) Stack will be similar to :-

VInfreq__kghssapage <- koxss2gpage <- qksfroGetCollSize <- kkeits <- kkoiqb <- kkooqb <- kkoqbc <- apakkoqb <- apaqbdDescendents  <- apaqbdListReverse <- apaqbd <- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- <- kksfbc <- opiexe <- opipls <- opiodr <- rpidrus <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_BFTCHC <- pfrinstr_BFTCHC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- opimai


e) The client session will report OEM in use :-

SO: 34742F98, type: 4, owner: 3465A218, flag: INIT/-/-/0x00
(session) sid: 145 trans: 337C83AC, creator: 3465A218, flag: (41) USR/-
BSY/-/-/-/-/-
DID: 0001-001A-00000004, short-term DID: 0000-0000-00000000
txn branch: 00000000
oct: 3, prv: 0, sql: 2C7BE728, psql: 2F3418B0, user: 162/SYSMAN
service name: xxxxxx
O/S info: user: SYSTEM, term: unknown, ospid: 1234, machine: xxxxx
program: OMS
client info: xxxxxxx
application name: OEM.Loader, hash value=2047538122
action name: XMLLoader0, hash value=76787928

Changes

Errors seem to be seen after applying Windows V10204 Patch/Bundle 14 through Patch/Bundle 19.




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