ORA-7445 [kghssacopy] Running SELECT on SYS.ALERT_QT (Doc ID 2039380.1)

Last updated on AUGUST 04, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Linux x86-64

Symptoms

Alert log report an ORA-7445 [ghssacopy]:

Exception [type: SIGFPE, Integer divide by zero] [ADDR:0x93460E5] [PC:0x93460E5, kghssacopy()+87] [flags: 0x0, count: 1]
Errors in file /o400/diag/rdbms/rsklf/rsklf3/trace/rsklf3_e000_9265.trc  (incident=28501):
ORA-07445: exception encountered: core dump [kghssacopy()+87] [SIGFPE] [ADDR:0x93460E5] [PC:0x93460E5] [Integer divide by zero] []
Incident details in: /o400/diag/rdbms/rsklf/rsklf3/incident/incdir_28501/rsklf3_e000_9265_i28501.trc


The trace file shows next characteristics:

----- Current SQL Statement for this session (sql_id=25tufrsy90sd0) -----
select  tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay,   tab.expiration , tab.exception_qschema,   tab.exception_queue, tab.chain_no, tab.local_order_no, tab.enq_time,   tab.time_manager_info, tab.state, tab.enq_tid, tab.step_no,   tab.sender_name, tab.sender_address, tab.sender_protocol,   tab.dequeue_msgid, tab.user_prop, tab.user_data  from "SYS"."ALERT_QT" tab  where q_name = :1 and msgid = :2  

----- Call Stack Trace -----

... kghssacopy kprcdt kprccu opifcr qertbFetchByRowID opifch2 kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute kwqidrdq kwqidsfmp kwqidafm0 kwqididqx kwqididq kpondeqpayl kponepms kponprmsg kponemn0 kponemn ksvrdp opirip opidrv ...

 

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