My Oracle Support Banner

Database Crashes With ORA-07445 [oss_desparsify] Errors While Trying An Upgrade From 12c To 19c (Doc ID 2685680.1)

Last updated on JULY 27, 2020

Applies to:

Oracle Exadata Storage Server Software - Version 19.1.0.0.0 to 20.1.0.0.0 [Release 12.2 to 20.0]
Oracle Database - Enterprise Edition - Version 19.0.0.0.0 to 19.7.0.0.0 [Release 19]
Information in this document applies to any platform.

Symptoms

19.1.0.0.0 Oracle Home.
Oracle Solaris on SPARC (64-bit) ~ Super Cluster rack.

Trying to upgrade snapshot clone database from 12c to 19c and when it reaches OPEN MIGRATE mode, immediately database is hitting below ORA 7445 ::

NOTE: Startup the database from original 12c Oracle Home has no issue.

.....
2020-05-11T16:11:31.359797-05:00
ALTER DATABASE OPEN MIGRATE            <<<<<<<<<<<<<<<<<<<<<<<<<
TMI: adbdrv open database BEGIN 2020-05-11 16:11:31.359846
2020-05-11T16:11:31.509060-05:00
NOTE: ASMB mounting group 5 (SPARSE)
NOTE: Assigned CGID 0x10032 for group 5
NOTE: ASMB process initiating disk discovery for grp 5 (reqid:0)
2020-05-11T16:11:32.246029-05:00
NOTE: Assigning number (5,0) to disk (o/192.168.79.50;192.168.79.51/SPARSE_CD_07_bs01auceladm12)
..
..
Starting background process ARC4
2020-05-11T16:11:33.824656-05:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0xFFFFFFFEFABEEDB8, oss_desparsify()+88] [flags: 0x0, count: 1]
Errors in file /app/oracle/diag/rdbms/testdb/testdb1/trace/testdb1_ora_57189.trc (incident=36681):
ORA-07445: exception encountered: core dump [oss_desparsify()+88] [SIGSEGV] [ADDR:0x10] [PC:0xFFFFFFFEFABEEDB8] [Address not mapped to object] []       <<<<<<<<<<<<<<<<<<<<<<<<<
2020-05-11T16:11:33.838863-05:00
ARC4 started with pid=97, OS id=58369
Starting background process ARC5
Incident details in: /app/oracle/diag/rdbms/testdb/testdb1/incident/incdir_36681/testdb1_ora_57189_i36681.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2020-05-11T16:11:33.896472-05:00
ARC5 started with pid=98, OS id=58399
Starting background process ARC6
..
..
..
Instance terminated by PMON, pid = 51987

 

Other findings ::

1. ----- Current SQL Statement for this session (sql_id=aps3qh1nhzkjx) -----
select line#, sql_text from bootstrap$ where obj# not in (:1, :2)

2. Main Stack:

  oss_desparsify ksfdss_checkdata ksfdss_read ksfdread kcfrbd1 kcbz_table_scan_read kcbzibmlt kcbzib kcbgtcr ktrget2 kdst_fetch0

3. Snapshot clone databases are resided within SPARSE ASM disk groups.
  

Changes

 Snapshot clone database upgrade from 12c to 19c release.

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
Changes
Cause
Solution
References


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