Hi all,
Just documenting here, in case you don’t know this script:
Script to Check for Known Problems in oracle8i, oracle9i, oracle10g, Oracle 11g and Oracle 12c( Doc ID 136697.1 )
SQL> @hcheck.sql HCheck Version 07MAY18 on 12-AUG-2019 21:51:32 ---------------------------------------------- Catalog Version 12.2.0.1.0 (1202000100) db_name: R360PD Is CDB?: NO Catalog Fixed Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1202000100 <= *All Rel* 08/12 21:51:32 PASS .- MissingOIDOnObjCol ... 1202000100 <= *All Rel* 08/12 21:51:33 PASS .- SourceNotInObj ... 1202000100 <= *All Rel* 08/12 21:51:33 PASS .- OversizedFiles ... 1202000100 <= *All Rel* 08/12 21:51:33 PASS .- PoorDefaultStorage ... 1202000100 <= *All Rel* 08/12 21:51:33 PASS .- PoorStorage ... 1202000100 <= *All Rel* 08/12 21:51:33 PASS .- TabPartCountMismatch ... 1202000100 <= *All Rel* 08/12 21:51:33 PASS .- OrphanedTabComPart ... 1202000100 <= *All Rel* 08/12 21:51:34 PASS .- MissingSum$ ... 1202000100 <= *All Rel* 08/12 21:51:38 PASS .- MissingDir$ ... 1202000100 <= *All Rel* 08/12 21:51:38 PASS .- DuplicateDataobj ... 1202000100 <= *All Rel* 08/12 21:51:39 PASS .- ObjSynMissing ... 1202000100 <= *All Rel* 08/12 21:55:56 PASS .- ObjSeqMissing ... 1202000100 <= *All Rel* 08/12 21:55:57 PASS .- OrphanedUndo ... 1202000100 <= *All Rel* 08/12 21:55:57 PASS .- OrphanedIndex ... 1202000100 <= *All Rel* 08/12 21:55:57 PASS .- OrphanedIndexPartition ... 1202000100 <= *All Rel* 08/12 21:55:57 PASS .- OrphanedIndexSubPartition ... 1202000100 <= *All Rel* 08/12 21:55:57 PASS .- OrphanedTable ... 1202000100 <= *All Rel* 08/12 21:56:00 PASS .- OrphanedTablePartition ... 1202000100 <= *All Rel* 08/12 21:56:00 PASS .- OrphanedTableSubPartition ... 1202000100 <= *All Rel* 08/12 21:56:00 PASS .- MissingPartCol ... 1202000100 <= *All Rel* 08/12 21:56:04 PASS .- OrphanedSeg$ ... 1202000100 <= *All Rel* 08/12 21:56:04 PASS .- OrphanedIndPartObj# ... 1202000100 <= *All Rel* 08/12 21:56:15 PASS .- DuplicateBlockUse ... 1202000100 <= *All Rel* 08/12 21:56:15 PASS .- FetUet ... 1202000100 <= *All Rel* 08/12 21:56:17 PASS .- Uet0Check ... 1202000100 <= *All Rel* 08/12 21:56:17 PASS .- SeglessUET ... 1202000100 <= *All Rel* 08/12 21:56:18 PASS .- BadInd$ ... 1202000100 <= *All Rel* 08/12 21:56:19 PASS .- BadTab$ ... 1202000100 <= *All Rel* 08/12 21:56:21 PASS .- BadIcolDepCnt ... 1202000100 <= *All Rel* 08/12 21:56:21 PASS .- ObjIndDobj ... 1202000100 <= *All Rel* 08/12 21:56:21 PASS .- TrgAfterUpgrade ... 1202000100 <= *All Rel* 08/12 21:56:22 PASS .- ObjType0 ... 1202000100 <= *All Rel* 08/12 21:56:22 FAIL HCKE-0036: Bad OBJ$ entry with TYPE#=0 (Doc ID 1361015.1) OBJ$ OBJ#=212606505 TYPE#=0 NAME=COMMENTS NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606501 TYPE#=0 NAME=CONTACT NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606496 TYPE#=0 NAME=HT360_CURRENCY_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=74768696 TYPE#=0 NAME=HT360_USER_ACCESS_MV NAMESPACE=66 Dblink=MDMPROD OBJ$ OBJ#=183148682 TYPE#=0 NAME=HT360_USER_SUBS_PERM_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=186229204 TYPE#=0 NAME=HT360_USER_SUBS_PERM_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=115573869 TYPE#=0 NAME=HT360_USER_SUBS_PERM_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606499 TYPE#=0 NAME=HT360_USER_SUBS_PERM_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606631 TYPE#=0 NAME=TC_HT_SERVICE_DEL_ATTRIBUTES_V NAMESPACE=66 Dblink=EBSPROD OBJ$ OBJ#=186229477 TYPE#=0 NAME=GDS360_PROPERTY_REMOTE NAMESPACE=66 Dblink=MDMPROD OBJ$ OBJ#=148134057 TYPE#=0 NAME=MEDIA_ROI_INS NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606497 TYPE#=0 NAME=MEDIA_ROI_INS NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=75622441 TYPE#=0 NAME=CONTACT_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=197171249 TYPE#=0 NAME=CONTACT_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=148134085 TYPE#=0 NAME=CAMPAIGN_DMP NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606500 TYPE#=0 NAME=CAMPAIGN_DMP NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=148134088 TYPE#=0 NAME=INSERTION_CODE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606503 TYPE#=0 NAME=INSERTION_CODE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=148134080 TYPE#=0 NAME=INSERTION_DMP NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606504 TYPE#=0 NAME=INSERTION_DMP NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=148134083 TYPE#=0 NAME=INSERTION_ELEMENT NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=212606502 TYPE#=0 NAME=INSERTION_ELEMENT NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=172793128 TYPE#=0 NAME=SUPPLIER_CONTACT_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=197171212 TYPE#=0 NAME=SUPPLIER_CONTACT_REMOTE NAMESPACE=66 Dblink=EMCPROD OBJ$ OBJ#=183148695 TYPE#=0 NAME=PROPERTY_MAPPING NAMESPACE=66 Dblink=MDMPROD OBJ$ OBJ#=154666744 TYPE#=0 NAME=PROPERTY_MAPPING NAMESPACE=66 Dblink=MDMPROD .- BadOwner ... 1202000100 <= *All Rel* 08/12 21:56:22 PASS .- StmtAuditOnCommit ... 1202000100 <= *All Rel* 08/12 21:56:23 PASS .- BadPublicObjects ... 1202000100 <= *All Rel* 08/12 21:56:23 PASS .- BadSegFreelist ... 1202000100 <= *All Rel* 08/12 21:56:23 PASS .- BadDepends ... 1202000100 <= *All Rel* 08/12 21:56:25 PASS .- CheckDual ... 1202000100 <= *All Rel* 08/12 21:56:26 PASS .- ObjectNames ... 1202000100 <= *All Rel* 08/12 21:56:26 WARN HCKW-0018: OBJECT name clashes with SCHEMA name (Doc ID 2363142.1) Schema=TC_MONITOR JOB=TC_MONITOR.TC_MONITOR Schema=TCDWSTAGE DATABASE LINK=PUBLIC.TCDWSTAGE .- BadCboHiLo ... 1202000100 <= *All Rel* 08/12 21:56:27 PASS .- ChkIotTs ... 1202000100 <= *All Rel* 08/12 21:56:32 PASS .- NoSegmentIndex ... 1202000100 <= *All Rel* 08/12 21:56:32 PASS .- BadNextObject ... 1202000100 <= *All Rel* 08/12 21:56:32 PASS .- DroppedROTS ... 1202000100 <= *All Rel* 08/12 21:56:33 PASS .- FilBlkZero ... 1202000100 <= *All Rel* 08/12 21:56:33 PASS .- DbmsSchemaCopy ... 1202000100 <= *All Rel* 08/12 21:56:33 PASS .- OrphanedIdnseqObj ... 1202000100 > 1201000000 08/12 21:56:33 PASS .- OrphanedIdnseqSeq ... 1202000100 > 1201000000 08/12 21:56:33 PASS .- OrphanedObjError ... 1202000100 > 1102000000 08/12 21:56:33 PASS .- ObjNotLob ... 1202000100 <= *All Rel* 08/12 21:56:34 PASS .- MaxControlfSeq ... 1202000100 <= *All Rel* 08/12 21:56:34 PASS .- SegNotInDeferredStg ... 1202000100 > 1102000000 08/12 21:56:34 PASS .- SystemNotRfile1 ... 1202000100 > 902000000 08/12 21:56:35 PASS .- DictOwnNonDefaultSYSTEM ... 1202000100 <= *All Rel* 08/12 21:56:35 PASS .- OrphanTrigger ... 1202000100 <= *All Rel* 08/12 21:56:35 PASS .- ObjNotTrigger ... 1202000100 <= *All Rel* 08/12 21:56:35 PASS --------------------------------------- 12-AUG-2019 21:56:36 Elapsed: 304 secs --------------------------------------- Found 26 potential problem(s) and 2 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or not PL/SQL procedure successfully completed. Statement processed. Complete output is in trace file: /u01/app/oracle/diag/rdbms/r360pdlo/r360pd3/trace/r360pd3_ora_310651_HCHECK.trc
useful, right?