Health Monitor is reporting false findings after tablespace management : DROP and READ ONLY (Doc ID 1360899.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Preforming tablespace management like dropping a tablespace or setting a tablespace to READ ONLY, will result in false findings by DBMS_HM.RUN_CHECK


SQL> alter tablespace rzy100 read only;

 

Run Findings And Recommendations
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 118862
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: ts$.online$ 41 on object TS$ failed
Message : Damaged rowid is AAAAAGAABAAAE6xAAA - description: Tablespace RZY100 is referenced



SQL> drop tablespace rzy100 including contents and datafiles;



Finding
Finding Name : Dictionary Inconsistency
Finding ID : 118865
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: file$ pk 42 on object FILE$ failed
Message : Damaged rowid is AAAAARAABAAAAA8AAE - description: No further damage description available

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