My Oracle Support Banner

SQL DICTIONARY HEALTH CHECK: CHECK SEQ$.PARTCOUNT RANGE 106 ON OBJECT SEQ$ FAILED (Doc ID 1624449.1)

Last updated on AUGUST 04, 2018

Applies to:

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

Symptoms

Running DBMS_HM.RUN_CHECK against a DB created on Oracle 12c reported the damage below:

BEGIN
 DBMS_HM.RUN_CHECK (check_name => 'Dictionary Integrity Check',
 run_name => 'DICTrun122413',
 input_params => 'CHECK_MASK=ALL');
END;

SET LONG 100000
SET LONGCHUNKSIZE 1000
SET PAGESIZE 1000
SET LINESIZE 512
SELECT DBMS_HM.GET_RUN_REPORT('DICTrun122413') from dual;

 

Output:

..........

Finding
Finding Name  : Dictionary Inconsistency
Finding ID    : 436
Type          : FAILURE
Status        : OPEN
Priority      : CRITICAL
Message       : SQL dictionary health check: check seq$.partcount range 106
              on object SEQ$ failed
Message       : Damaged rowid is AAAABkAABAAAASKAAC - description: Object
              SYS.WI$_JOB_ID is referenced
Finding
Finding Name  : Dictionary Inconsistency
Finding ID    : 439
Type          : FAILURE
Status        : OPEN
Priority      : CRITICAL
Message       : SQL dictionary health check: check seq$.partcount range 106
              on object SEQ$ failed
Message       : Damaged rowid is AAAABkAABAAAASKAAD - description: Object
              SYS.WRI$_ADV_SEQ_SQLW_QUERY is referenced

...........

 

Changes

New setup of Oracle Database 12c Enterprise Edition Release 12.1.0.1.0

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.