Refreshing a Snapshot Fails With ORA-7445 Under nnflrne()

(Doc ID 797903.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.

Symptoms

Refreshing a snapshot fails with an error like:

ORA-07445: exception encountered: core dump [000000010235BBCC] [SIGSEGV] [Address not mapped to object] [0x0000001C0] [] []


In the trace file we see something like:

ORA-07445: exception encountered: core dump [000000010235BBCC] [SIGSEGV] [Address not mapped to
object] [0x0000001C0] [] []

Current SQL statement for this session:
begin sys.dbms_snapshot_utl.set_up@ <database link> (:mown_col, :mas_col, :rollseg_col, :flag_col,
:outflag_col, :snaptime_col, :loadertime_col, :num_sid, :snapid_tab, :max_tab_scn_col,
:max_dl_scn_col, :max_pmop_scn_col, :trunc_scn_col, :max_ins_tim_col, :max_upd_tim_col,
:max_del_tim_col, :max_ins_scn_col, :max_upd_scn_col, :max_del_scn_col, :hdl_col,
:hdl_indx_col, :rscn); end;

----- PL/SQL Call Stack -----
object line object
handle number name
3f7881400 1 anonymous block
3f79ca878 12 package body SYS.DBMS_SNAPSHOT
3f79ca878 787 package body SYS.DBMS_SNAPSHOT
3f79ca878 877 package body SYS.DBMS_SNAPSHOT
3f7a89598 683 package body SYS.DBMS_IREFRESH
3f7b8c410 195 package body SYS.DBMS_REFRESH
3f7bf2040 1 anonymous block

----- Call Stack Trace -----

... nnflrne nnfgrne nlolgobj nnfun2a nnfsn2a kmntrn kpnvcs npicon0 psdrpc prirpc pevm_RCAL pfrrun peicnt kkxexe opiexe opiall0 opikpr opiodr rpidrus skgmstack rpidru ...

 

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