My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.