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