ORA-07445 Mining a 10g archive With Logminer 11g (Doc ID 1603298.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Mining an Oracle 10g archive with the Oracle 11.2.0.3 DBMS_LOGMNR package fails with an ORA-7445 [krvtgsupd_GenStmtUpdate()+313]

The alert logfiles shows errors like:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x44] [PC:0x53E4CC5, krvtgsupd_GenStmtUpdate()+313] [flags: 0x0, count: 1]
Errors in file /home/ora11g/diag/rdbms/.../.../<SID>_ora_10593.trc  (incident=30223):
ORA-07445: exception encountered: core dump [krvtgsupd_GenStmtUpdate()+313] [SIGSEGV] [ADDR:0x44] [PC:0x53E4CC5] [Address not mapped to object] []
Incident details in: /home/ora11g/diag/rdbms/.../.../incident/incdir_30223/<SID>_ora_10593_i30223.trc
Use ADRCI or Support Workbench to package the incident.


In the tracefile, the following information is shown:

INSERT INTO <schema>.<table_name>L select :source, :al, SCN,TIMESTAMP,TX_NAME,XID, OPERATION,SEG_OWNER,SEG_NAME,SQL_REDO
FROM "SYS"."V$LOGMNR_CONTENTS" WHERE (seg_owner=:schema and seg_name=:tab) or (OPERATION in ('COMMIT','ROLLBACK'))
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x25e2fa6d0        30  function <function_name>
0x25e4720d8        10  anonymous block

----- Call Stack Trace -----
krvtgsupd_GenStmtUpdate krvtgst krvfgsql_GenerateSql krvffar_FillAdhocRow krvfcact2 krvfcact qerfxFetch rwsfcd qerltcFetch
insexe opiexe opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun
plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main


============
Plan Table
============
-----------------------------------------------------+-----------------------------------+
| Id  | Operation                 | Name             | Rows  | Bytes | Cost  | Time      |
-----------------------------------------------------+-----------------------------------+
| 0   | INSERT STATEMENT          |                  |       |       |     1 |           |
| 1   |  LOAD TABLE CONVENTIONAL  |                  |       |       |       |           |
| 2   |   FIXED TABLE FULL        | X$LOGMNR_CONTENTS|     1 |  2352 |     0 |           |
-----------------------------------------------------+-----------------------------------+

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