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 to [Release 11.2]
Linux x86-64


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 ...



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