Home » RDBMS Server » Server Administration » DBMS_HM ERROR (oracle database 11.2.0.3 for linux x64)
icon7.gif  DBMS_HM ERROR [message #585104] Wed, 22 May 2013 03:35
xionghaidi
Messages: 1
Registered: May 2013
Location: cn
Junior Member

I have used the dbms_hm.run_check to check the Dictionary Integrity ,but i got some much errors ,the tablespace like TPCCTAB,TEST,TEST1...must be the test tablespace for my test purpose and which is deleted long time ago, i just don't know how can i deal with this problem,anyone can give some advice? thanks a lot!

SQL
exec dbms_hm.run_check('Dictionary Integrity Check','check05');
select dbms_hm.get_run_report('check05') from dual;

REPORT

Basic Run Information
Run Name : check05
Run Id : 8901
Check Name : Dictionary Integrity Check
Mode : MANUAL
Status : COMPLETED
Start Time : 2013-05-22 15:33:55.683407 +08:00
End Time : 2013-05-22 15:33:57.599266 +08:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0

Input Paramters for the Run
TABLE_NAME=ALL_CORE_TABLES
CHECK_MASK=ALL

Run Findings And Recommendations
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8902
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: file$ pk 42 on object FILE$
failed
Message : Damaged rowid is AAAAARAABAAAADpAAF - description: No further
damage description available
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8905
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: file$ pk 42 on object FILE$
failed
Message : Damaged rowid is AAAAARAABAAAADpAAG - description: No further
damage description available
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8908
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: file$ pk 42 on object FILE$
failed
Message : Damaged rowid is AAAAARAABAAAADpAAI - description: No further
damage description available
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8911
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: file$ pk 42 on object FILE$
failed
Message : Damaged rowid is AAAAARAABAAAADpAAJ - description: No further
damage description available
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8914
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: file$ pk 42 on object FILE$
failed
Message : Damaged rowid is AAAAARAABAAAADpAAK - description: No further
damage description available
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8917
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAC - description: Tablespace
SOE is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8920
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAD - description: Tablespace
TPCCTAB is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8923
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAF - description: Tablespace
TBS_TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8926
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAE - description: Tablespace
TPCCTAB is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8929
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAG - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8932
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAH - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8935
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAI - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8938
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAJ - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8941
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAK - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8944
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAL - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8947
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAM - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8950
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAN - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8953
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAO - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8956
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAP - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8959
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAQ - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8962
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAR - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8965
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAS - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8968
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAT - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8971
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADVAAU - description: Tablespace
TEST is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8974
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADWAAB - description: Tablespace
TEST2 is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8977
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADWAAA - description: Tablespace
TEST1 is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8980
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADWAAC - description: Tablespace
TEST3 is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8983
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADWAAD - description: Tablespace
TEST1 is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8986
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADWAAE - description: Tablespace
TEST2 is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8989
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADWAAF - description: Tablespace
TEST3 is referenced
Finding
Finding Name : Dictionary Inconsistency
Finding ID : 8992
Type : FAILURE
Status : OPEN
Priority : CRITICAL
Message : SQL dictionary health check: tsq$.user# fk 92 on object TSQ$
failed
Message : Damaged rowid is AAAAAKAABAAAADWAAG - description: Tablespace
TEST is referenced
Previous Topic: Listener shutdown for individual instances?
Next Topic: Restarting AWR snapshots after errors.
Goto Forum:
  


Current Time: Thu Apr 17 16:34:32 CDT 2014

Total time taken to generate the page: 0.14215 seconds