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?
