My Oracle Support Banner

Advisory Message For ORA-8103 Shown On Alert File in 12.2 (Doc ID 2452395.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Alert log shows Advisory for ORA-8103

 

2018-07-28T09:49:28.990178+08:00
ADVISORY: Please collect redo for investigation of ORA-8103. Use command:     >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
  ALTER SYSTEM DUMP REDO scn min 1 scn max 267096730531 dba min 2 3698 dba max 2 3698;
Hex dump of (file 2, block 3698) in trace file E:\APP\ORACLESRV\diag\rdbms\pmtsenq\pmtsenq\trace\pmtsenq_j000_9520.trc

Corrupt block relative dba: 0x00800e72 (file 2, block 3698)
Bad header found during buffer read (logical check)
Data in bad block:
type: 35 format: 2 rdba: 0x00800e72
last change scn: 0x0000.003e.3034ab9a seq: 0x1 flg: 0x04
spare3: 0x0
consistency value in tail: 0xab9a2301
check value in block header: 0xa88
computed block checks


Failing statement

ORA-08103: object no longer exists
----- Current SQL Statement for this session (sql_id=bgu9gd2bjj7d1) -----
SELECT TABLESPACE_NAME FROM SYS.WRI$_HEATMAP_TOP_TABLESPACES

Call Stack :-

kcbgtcr ktrget2 kdst_fetch kdsttgr

 

Changes

Issue happens only in 12.2

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.