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 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
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 ...
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
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
Symptoms |
Cause |
Solution |
References |