本文共 49557 字，大约阅读时间需要 165 分钟。
13:06:41 SQL> show user;
USER is "SYS" 13:07:06 SQL> drop user jyc cascade;drop user jyc cascade * ERROR at line 1: ORA-00600: internal error code, arguments: [ktadrprc-1], [], [], [], [], [], [], [], [], [], [], [] 13:07:18 SQL> @hcheck.sql --脚本下载 HCheck Version 07MAY18 on 25-DEC-2020 13:07:23 ---------------------------------------------- Catalog Version 11.2.0.4.0 (1102000400) db_name: ORCLCatalog Fixed
Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- MissingOIDOnObjCol ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- SourceNotInObj ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- OversizedFiles ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- PoorDefaultStorage ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- PoorStorage ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- TabPartCountMismatch ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- OrphanedTabComPart ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- MissingSum$ ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- MissingDir$ ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- DuplicateDataobj ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- ObjSynMissing ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjSeqMissing ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedUndo ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndex ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndexPartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndexSubPartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedTable ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedTablePartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedTableSubPartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- MissingPartCol ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedSeg$ ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndPartObj# ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- DuplicateBlockUse ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- FetUet ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- Uet0Check ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- SeglessUET ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadInd$ ... 1102000400 <= *All Rel* 12/25 13:07:24 FAILHCKE-0030: OBJ$ INDEX entry has no IND$ or INDPART$/INDSUBPART$ entry (Doc ID 1360528.1)
OBJ$ INDEX has no IND$ entry: Obj#=87820 *NonexistentOwnerId=86* Name=SYS_C0011203 OBJ$ INDEX has no IND$ entry: Obj#=87845 *NonexistentOwnerId=86* Name=SYS_C0011215 OBJ$ INDEX has no IND$ entry: Obj#=87807 *NonexistentOwnerId=86* Name=SYS_IL0000087805C00045$$ OBJ$ INDEX has no IND$ entry: Obj#=87828 *NonexistentOwnerId=86* Name=SYS_IL0000087826C00045$$ OBJ$ INDEX has no IND$ entry: Obj#=87842 *NonexistentOwnerId=86* Name=SYS_IL0000087826C00096$$ OBJ$ INDEX has no IND$ entry: Obj#=87821 *NonexistentOwnerId=86* Name=SYS_MTABLE_0000156FD_IND_1 OBJ$ INDEX has no IND$ entry: Obj#=87822 *NonexistentOwnerId=86* Name=SYS_MTABLE_0000156FD_IND_2 OBJ$ INDEX has no IND$ entry: Obj#=87846 *NonexistentOwnerId=86* Name=SYS_MTABLE_000015712_IND_1 OBJ$ INDEX has no IND$ entry: Obj#=87847 *NonexistentOwnerId=86* Name=SYS_MTABLE_000015712_IND_2 OBJ$ INDEX has no IND$ entry: Obj#=87848 *NonexistentOwnerId=86* Name=SYS_MTABLE_000015712_IND_3 OBJ$ INDEX has no IND$ entry: Obj#=87948 JYC Name=SYS_C0011337 OBJ$ INDEX has no IND$ entry: Obj#=87935 JYC Name=SYS_IL0000087933C00045$$ OBJ$ INDEX has no IND$ entry: Obj#=87949 JYC Name=SYS_MTABLE_00001577D_IND_1 OBJ$ INDEX has no IND$ entry: Obj#=87950 JYC Name=SYS_MTABLE_00001577D_IND_2.- BadTab$ ... 1102000400 <= *All Rel* 12/25 13:07:24 FAIL
HCKE-0031: OBJ$ TABLE entry has no TAB$ entry (Doc ID 1360538.1)
TABLE has no TAB$ entry: Obj=87805 *NonexistentOwnerId=86*.SYS_EXPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87826 *NonexistentOwnerId=86*.SYS_IMPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87804 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87850 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87803 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87849 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87825 *NonexistentOwnerId=86*.T2 TABLE has no TAB$ entry: Obj=87851 *NonexistentOwnerId=86*.TEST TABLE has no TAB$ entry: Obj=87798 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87801 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87799 *NonexistentOwnerId=87*.T TABLE has no TAB$ entry: Obj=87800 *NonexistentOwnerId=87*.T1 TABLE has no TAB$ entry: Obj=87933 JYC.SYS_EXPORT_SCHEMA_01.- BadIcolDepCnt ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS
.- ObjIndDobj ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- TrgAfterUpgrade ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjType0 ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadOwner ... 1102000400 <= *All Rel* 12/25 13:07:24 FAILHCKE-0038: OBJ$.OWNER# not in USER$ (Doc ID 1361020.1)
OBJ$ OBJ#=87820 TYPE=INDEX NAME=SYS_C0011203 Owner#=86 OBJ$ OBJ#=87845 TYPE=INDEX NAME=SYS_C0011215 Owner#=86 OBJ$ OBJ#=87805 TYPE=TABLE NAME=SYS_EXPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87807 TYPE=INDEX NAME=SYS_IL0000087805C00045$$ Owner#=86 OBJ$ OBJ#=87828 TYPE=INDEX NAME=SYS_IL0000087826C00045$$ Owner#=86 OBJ$ OBJ#=87842 TYPE=INDEX NAME=SYS_IL0000087826C00096$$ Owner#=86 OBJ$ OBJ#=87826 TYPE=TABLE NAME=SYS_IMPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87806 TYPE=LOB NAME=SYS_LOB0000087805C00045$$ Owner#=86 OBJ$ OBJ#=87827 TYPE=LOB NAME=SYS_LOB0000087826C00045$$ Owner#=86 OBJ$ OBJ#=87841 TYPE=LOB NAME=SYS_LOB0000087826C00096$$ Owner#=86 OBJ$ OBJ#=87821 TYPE=INDEX NAME=SYS_MTABLE_0000156FD_IND_1 Owner#=86 OBJ$ OBJ#=87822 TYPE=INDEX NAME=SYS_MTABLE_0000156FD_IND_2 Owner#=86 OBJ$ OBJ#=87846 TYPE=INDEX NAME=SYS_MTABLE_000015712_IND_1 Owner#=86 OBJ$ OBJ#=87847 TYPE=INDEX NAME=SYS_MTABLE_000015712_IND_2 Owner#=86 OBJ$ OBJ#=87848 TYPE=INDEX NAME=SYS_MTABLE_000015712_IND_3 Owner#=86 OBJ$ OBJ#=87804 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87850 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87803 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87849 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87825 TYPE=TABLE NAME=T2 Owner#=86 OBJ$ OBJ#=87851 TYPE=TABLE NAME=TEST Owner#=86 OBJ$ OBJ#=87798 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87801 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87799 TYPE=TABLE NAME=T Owner#=87 OBJ$ OBJ#=87800 TYPE=TABLE NAME=T1 Owner#=87 OBJ$ OBJ#=87931 TYPE=TABLE NAME=T1 Owner#=92 OBJ$ OBJ#=87932 TYPE=TABLE NAME=T2 Owner#=92.- StmtAuditOnCommit ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS
.- BadPublicObjects ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadSegFreelist ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadDepends ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- CheckDual ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjectNames ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadCboHiLo ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ChkIotTs ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- NoSegmentIndex ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadNextObject ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- DroppedROTS ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- FilBlkZero ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- DbmsSchemaCopy ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedObjError ... 1102000400 > 1102000000 12/25 13:07:24 PASS .- ObjNotLob ... 1102000400 <= *All Rel* 12/25 13:07:24 FAILHCKE-0049: OBJ$ LOB entry has no LOB$ or LOBFRAG$ entry (Doc ID 2125104.1)
OBJ$ LOB has no LOB$ entry: Obj=87934 Owner: JYC LOB Name: SYS_LOB0000087933C00045$$.- MaxControlfSeq ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS
.- SegNotInDeferredStg ... 1102000400 > 1102000000 12/25 13:07:24 PASS .- SystemNotRfile1 ... 1102000400 > 902000000 12/25 13:07:24 PASS .- DictOwnNonDefaultSYSTEM ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanTrigger ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjNotTrigger ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS --------------------------------------- 25-DEC-2020 13:07:24 Elapsed: 1 secs --------------------------------------- Found 55 potential problem(s) and 0 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or notPL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc13:07:24 SQL> !more /home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc
Trace file /home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /home/db/oracle/product/11.2.0/db_1 System name: Linux Node name: saperp Release: 3.10.0-1062.18.1.el7.x86_64 Version: #1 SMP Tue Mar 17 23:49:17 UTC 2020 Machine: x86_64 VM name: VMWare Version: 6 Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 19 Unix process pid: 13048, image: oracle@saperp (TNS V1-V3) *** 2020-12-25 13:07:23.679 *** SESSION ID:(355.39) 2020-12-25 13:07:23.679 *** CLIENT ID:() 2020-12-25 13:07:23.679 *** SERVICE NAME:(SYS$USERS) 2020-12-25 13:07:23.679 *** MODULE NAME:(sqlplus@saperp (TNS V1-V3)) 2020-12-25 13:07:23.679 *** ACTION NAME:() 2020-12-25 13:07:23.679*** TRACE CONTINUED FROM FILE /home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048.trc ***
HCheck Version 07MAY18 on 25-DEC-2020 13:07:23
---------------------------------------------- Catalog Version 11.2.0.4.0 (1102000400) db_name: ORCL Catalog Fixed Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- MissingOIDOnObjCol ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- SourceNotInObj ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- OversizedFiles ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- PoorDefaultStorage ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- PoorStorage ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- TabPartCountMismatch ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- OrphanedTabComPart ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- MissingSum$ ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- MissingDir$ ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- DuplicateDataobj ... 1102000400 <= *All Rel* 12/25 13:07:23 PASS .- ObjSynMissing ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjSeqMissing ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedUndo ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndex ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndexPartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndexSubPartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedTable ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedTablePartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedTableSubPartition ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- MissingPartCol ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedSeg$ ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedIndPartObj# ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- DuplicateBlockUse ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- FetUet ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- Uet0Check ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- SeglessUET ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadInd$ ... 1102000400 <= *All Rel* 12/25 13:07:24 FAIL HCKE-0030: OBJ$ INDEX entry has no IND$ or INDPART$/INDSUBPART$ entry (Doc ID 1360528.1) OBJ$ INDEX has no IND$ entry: Obj#=87820 *NonexistentOwnerId=86* Name=SYS_C0011203 OBJ$ INDEX has no IND$ entry: Obj#=87845 *NonexistentOwnerId=86* Name=SYS_C0011215 OBJ$ INDEX has no IND$ entry: Obj#=87807 *NonexistentOwnerId=86* Name=SYS_IL0000087805C00045$$ OBJ$ INDEX has no IND$ entry: Obj#=87828 *NonexistentOwnerId=86* Name=SYS_IL0000087826C00045$$ OBJ$ INDEX has no IND$ entry: Obj#=87842 *NonexistentOwnerId=86* Name=SYS_IL0000087826C00096$$ OBJ$ INDEX has no IND$ entry: Obj#=87821 *NonexistentOwnerId=86* Name=SYS_MTABLE_0000156FD_IND_1 OBJ$ INDEX has no IND$ entry: Obj#=87822 *NonexistentOwnerId=86* Name=SYS_MTABLE_0000156FD_IND_2 OBJ$ INDEX has no IND$ entry: Obj#=87846 *NonexistentOwnerId=86* Name=SYS_MTABLE_000015712_IND_1 OBJ$ INDEX has no IND$ entry: Obj#=87847 *NonexistentOwnerId=86* Name=SYS_MTABLE_000015712_IND_2 OBJ$ INDEX has no IND$ entry: Obj#=87848 *NonexistentOwnerId=86* Name=SYS_MTABLE_000015712_IND_3 OBJ$ INDEX has no IND$ entry: Obj#=87948 JYC Name=SYS_C0011337 OBJ$ INDEX has no IND$ entry: Obj#=87935 JYC Name=SYS_IL0000087933C00045$$ OBJ$ INDEX has no IND$ entry: Obj#=87949 JYC Name=SYS_MTABLE_00001577D_IND_1 OBJ$ INDEX has no IND$ entry: Obj#=87950 JYC Name=SYS_MTABLE_00001577D_IND_2 .- BadTab$ ... 1102000400 <= *All Rel* 12/25 13:07:24 FAIL HCKE-0031: OBJ$ TABLE entry has no TAB$ entry (Doc ID 1360538.1) TABLE has no TAB$ entry: Obj=87805 *NonexistentOwnerId=86*.SYS_EXPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87826 *NonexistentOwnerId=86*.SYS_IMPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87804 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87850 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87803 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87849 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87825 *NonexistentOwnerId=86*.T2 TABLE has no TAB$ entry: Obj=87851 *NonexistentOwnerId=86*.TEST TABLE has no TAB$ entry: Obj=87798 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87801 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87799 *NonexistentOwnerId=87*.T TABLE has no TAB$ entry: Obj=87800 *NonexistentOwnerId=87*.T1 TABLE has no TAB$ entry: Obj=87933 JYC.SYS_EXPORT_SCHEMA_01 .- BadIcolDepCnt ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjIndDobj ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- TrgAfterUpgrade ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjType0 ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadOwner ... 1102000400 <= *All Rel* 12/25 13:07:24 FAIL HCKE-0038: OBJ$.OWNER# not in USER$ (Doc ID 1361020.1) OBJ$ OBJ#=87820 TYPE=INDEX NAME=SYS_C0011203 Owner#=86 OBJ$ OBJ#=87845 TYPE=INDEX NAME=SYS_C0011215 Owner#=86 OBJ$ OBJ#=87805 TYPE=TABLE NAME=SYS_EXPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87807 TYPE=INDEX NAME=SYS_IL0000087805C00045$$ Owner#=86 OBJ$ OBJ#=87828 TYPE=INDEX NAME=SYS_IL0000087826C00045$$ Owner#=86 OBJ$ OBJ#=87842 TYPE=INDEX NAME=SYS_IL0000087826C00096$$ Owner#=86 OBJ$ OBJ#=87826 TYPE=TABLE NAME=SYS_IMPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87806 TYPE=LOB NAME=SYS_LOB0000087805C00045$$ Owner#=86 OBJ$ OBJ#=87827 TYPE=LOB NAME=SYS_LOB0000087826C00045$$ Owner#=86 OBJ$ OBJ#=87841 TYPE=LOB NAME=SYS_LOB0000087826C00096$$ Owner#=86 OBJ$ OBJ#=87821 TYPE=INDEX NAME=SYS_MTABLE_0000156FD_IND_1 Owner#=86 OBJ$ OBJ#=87822 TYPE=INDEX NAME=SYS_MTABLE_0000156FD_IND_2 Owner#=86 OBJ$ OBJ#=87846 TYPE=INDEX NAME=SYS_MTABLE_000015712_IND_1 Owner#=86 OBJ$ OBJ#=87847 TYPE=INDEX NAME=SYS_MTABLE_000015712_IND_2 Owner#=86 OBJ$ OBJ#=87848 TYPE=INDEX NAME=SYS_MTABLE_000015712_IND_3 Owner#=86 OBJ$ OBJ#=87804 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87850 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87803 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87849 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87825 TYPE=TABLE NAME=T2 Owner#=86 OBJ$ OBJ#=87851 TYPE=TABLE NAME=TEST Owner#=86 OBJ$ OBJ#=87798 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87801 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87799 TYPE=TABLE NAME=T Owner#=87 OBJ$ OBJ#=87800 TYPE=TABLE NAME=T1 Owner#=87 OBJ$ OBJ#=87931 TYPE=TABLE NAME=T1 Owner#=92 OBJ$ OBJ#=87932 TYPE=TABLE NAME=T2 Owner#=92 .- StmtAuditOnCommit ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadPublicObjects ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadSegFreelist ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadDepends ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- CheckDual ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjectNames ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadCboHiLo ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ChkIotTs ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- NoSegmentIndex ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- BadNextObject ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- DroppedROTS ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- FilBlkZero ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- DbmsSchemaCopy ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanedObjError ... 1102000400 > 1102000000 12/25 13:07:24 PASS .- ObjNotLob ... 1102000400 <= *All Rel* 12/25 13:07:24 FAIL HCKE-0049: OBJ$ LOB entry has no LOB$ or LOBFRAG$ entry (Doc ID 2125104.1) OBJ$ LOB has no LOB$ entry: Obj=87934 Owner: JYC LOB Name: SYS_LOB0000087933C00045$$ .- MaxControlfSeq ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- SegNotInDeferredStg ... 1102000400 > 1102000000 12/25 13:07:24 PASS .- SystemNotRfile1 ... 1102000400 > 902000000 12/25 13:07:24 PASS .- DictOwnNonDefaultSYSTEM ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- OrphanTrigger ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS .- ObjNotTrigger ... 1102000400 <= *All Rel* 12/25 13:07:24 PASS --------------------------------------- 25-DEC-2020 13:07:24 Elapsed: 1 secs --------------------------------------- Found 55 potential problem(s) and 0 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or not*** 2020-12-25 13:07:24.387
Processing Oradebug command 'setmypid'*** 2020-12-25 13:07:24.387
Oradebug command 'setmypid' console output: <none>*** 2020-12-25 13:07:24.387
Processing Oradebug command 'tracefile_name'*** 2020-12-25 13:07:24.387
Oradebug command 'tracefile_name' console output: /home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc13:08:23 SQL> delete from OBJ$ where Obj#=87820;
1 row deleted.
13:13:30 SQL>
13:14:22 SQL> delete from OBJ$ where Obj#=87845;1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87807;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87828;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87842;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87821;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87822;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87846;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87847;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87848;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87948;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87935;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87949;
1 row deleted.
13:14:23 SQL> delete from OBJ$ where Obj#=87950;
1 row deleted.
13:14:23 SQL> commit;
Commit complete.
13:14:25 SQL> @hcheck.sql
HCheck Version 07MAY18 on 25-DEC-2020 13:14:30 ---------------------------------------------- Catalog Version 11.2.0.4.0 (1102000400) db_name: ORCLCatalog Fixed
Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- MissingOIDOnObjCol ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- SourceNotInObj ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OversizedFiles ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- PoorDefaultStorage ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- PoorStorage ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- TabPartCountMismatch ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedTabComPart ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- MissingSum$ ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- MissingDir$ ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- DuplicateDataobj ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- ObjSynMissing ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- ObjSeqMissing ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedUndo ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedIndex ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedIndexPartition ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedIndexSubPartition ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedTable ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedTablePartition ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedTableSubPartition ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- MissingPartCol ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedSeg$ ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- OrphanedIndPartObj# ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- DuplicateBlockUse ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- FetUet ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- Uet0Check ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- SeglessUET ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- BadInd$ ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- BadTab$ ... 1102000400 <= *All Rel* 12/25 13:14:30 FAILHCKE-0031: OBJ$ TABLE entry has no TAB$ entry (Doc ID 1360538.1)
TABLE has no TAB$ entry: Obj=87805 *NonexistentOwnerId=86*.SYS_EXPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87826 *NonexistentOwnerId=86*.SYS_IMPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87804 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87850 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87803 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87849 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87825 *NonexistentOwnerId=86*.T2 TABLE has no TAB$ entry: Obj=87851 *NonexistentOwnerId=86*.TEST TABLE has no TAB$ entry: Obj=87798 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87801 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87799 *NonexistentOwnerId=87*.T TABLE has no TAB$ entry: Obj=87800 *NonexistentOwnerId=87*.T1 TABLE has no TAB$ entry: Obj=87933 JYC.SYS_EXPORT_SCHEMA_01.- BadIcolDepCnt ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS
.- ObjIndDobj ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- TrgAfterUpgrade ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- ObjType0 ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- BadOwner ... 1102000400 <= *All Rel* 12/25 13:14:30 FAILHCKE-0038: OBJ$.OWNER# not in USER$ (Doc ID 1361020.1)
OBJ$ OBJ#=87805 TYPE=TABLE NAME=SYS_EXPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87826 TYPE=TABLE NAME=SYS_IMPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87806 TYPE=LOB NAME=SYS_LOB0000087805C00045$$ Owner#=86 OBJ$ OBJ#=87827 TYPE=LOB NAME=SYS_LOB0000087826C00045$$ Owner#=86 OBJ$ OBJ#=87841 TYPE=LOB NAME=SYS_LOB0000087826C00096$$ Owner#=86 OBJ$ OBJ#=87804 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87850 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87803 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87849 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87825 TYPE=TABLE NAME=T2 Owner#=86 OBJ$ OBJ#=87851 TYPE=TABLE NAME=TEST Owner#=86 OBJ$ OBJ#=87798 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87801 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87799 TYPE=TABLE NAME=T Owner#=87 OBJ$ OBJ#=87800 TYPE=TABLE NAME=T1 Owner#=87 OBJ$ OBJ#=87931 TYPE=TABLE NAME=T1 Owner#=92 OBJ$ OBJ#=87932 TYPE=TABLE NAME=T2 Owner#=92.- StmtAuditOnCommit ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS
.- BadPublicObjects ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- BadSegFreelist ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- BadDepends ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- CheckDual ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- ObjectNames ... 1102000400 <= *All Rel* 12/25 13:14:30 PASS .- BadCboHiLo ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- ChkIotTs ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- NoSegmentIndex ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- BadNextObject ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- DroppedROTS ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- FilBlkZero ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- DbmsSchemaCopy ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- OrphanedObjError ... 1102000400 > 1102000000 12/25 13:14:31 PASS .- ObjNotLob ... 1102000400 <= *All Rel* 12/25 13:14:31 FAILHCKE-0049: OBJ$ LOB entry has no LOB$ or LOBFRAG$ entry (Doc ID 2125104.1)
OBJ$ LOB has no LOB$ entry: Obj=87934 Owner: JYC LOB Name: SYS_LOB0000087933C00045$$.- MaxControlfSeq ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS
.- SegNotInDeferredStg ... 1102000400 > 1102000000 12/25 13:14:31 PASS .- SystemNotRfile1 ... 1102000400 > 902000000 12/25 13:14:31 PASS .- DictOwnNonDefaultSYSTEM ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- OrphanTrigger ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS .- ObjNotTrigger ... 1102000400 <= *All Rel* 12/25 13:14:31 PASS --------------------------------------- 25-DEC-2020 13:14:31 Elapsed: 1 secs --------------------------------------- Found 31 potential problem(s) and 0 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or notPL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc13:14:31 SQL> select * from tab$ where Obj=87805;
select * from tab$ where Obj=87805 * ERROR at line 1: ORA-00904: "OBJ": invalid identifier 13:16:05 SQL> purge dba_recyclebin;DBA Recyclebin purged.
13:16:34 SQL> @hcheck.sql
HCheck Version 07MAY18 on 25-DEC-2020 13:16:42 ---------------------------------------------- Catalog Version 11.2.0.4.0 (1102000400) db_name: ORCLCatalog Fixed
Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- MissingOIDOnObjCol ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- SourceNotInObj ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OversizedFiles ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- PoorDefaultStorage ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- PoorStorage ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- TabPartCountMismatch ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedTabComPart ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- MissingSum$ ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- MissingDir$ ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- DuplicateDataobj ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- ObjSynMissing ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- ObjSeqMissing ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedUndo ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedIndex ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedIndexPartition ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedIndexSubPartition ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedTable ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedTablePartition ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedTableSubPartition ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- MissingPartCol ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedSeg$ ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedIndPartObj# ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- DuplicateBlockUse ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- FetUet ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- Uet0Check ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- SeglessUET ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- BadInd$ ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- BadTab$ ... 1102000400 <= *All Rel* 12/25 13:16:42 FAILHCKE-0031: OBJ$ TABLE entry has no TAB$ entry (Doc ID 1360538.1)
TABLE has no TAB$ entry: Obj=87805 *NonexistentOwnerId=86*.SYS_EXPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87826 *NonexistentOwnerId=86*.SYS_IMPORT_SCHEMA_01 TABLE has no TAB$ entry: Obj=87804 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87850 *NonexistentOwnerId=86*.T TABLE has no TAB$ entry: Obj=87803 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87849 *NonexistentOwnerId=86*.T1 TABLE has no TAB$ entry: Obj=87825 *NonexistentOwnerId=86*.T2 TABLE has no TAB$ entry: Obj=87851 *NonexistentOwnerId=86*.TEST TABLE has no TAB$ entry: Obj=87798 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87801 *NonexistentOwnerId=87*.LOGMNR_NEW TABLE has no TAB$ entry: Obj=87799 *NonexistentOwnerId=87*.T TABLE has no TAB$ entry: Obj=87800 *NonexistentOwnerId=87*.T1 TABLE has no TAB$ entry: Obj=87933 JYC.SYS_EXPORT_SCHEMA_01.- BadIcolDepCnt ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS
.- ObjIndDobj ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- TrgAfterUpgrade ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- ObjType0 ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- BadOwner ... 1102000400 <= *All Rel* 12/25 13:16:42 FAILHCKE-0038: OBJ$.OWNER# not in USER$ (Doc ID 1361020.1)
OBJ$ OBJ#=87805 TYPE=TABLE NAME=SYS_EXPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87826 TYPE=TABLE NAME=SYS_IMPORT_SCHEMA_01 Owner#=86 OBJ$ OBJ#=87806 TYPE=LOB NAME=SYS_LOB0000087805C00045$$ Owner#=86 OBJ$ OBJ#=87827 TYPE=LOB NAME=SYS_LOB0000087826C00045$$ Owner#=86 OBJ$ OBJ#=87841 TYPE=LOB NAME=SYS_LOB0000087826C00096$$ Owner#=86 OBJ$ OBJ#=87804 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87850 TYPE=TABLE NAME=T Owner#=86 OBJ$ OBJ#=87803 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87849 TYPE=TABLE NAME=T1 Owner#=86 OBJ$ OBJ#=87825 TYPE=TABLE NAME=T2 Owner#=86 OBJ$ OBJ#=87851 TYPE=TABLE NAME=TEST Owner#=86 OBJ$ OBJ#=87798 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87801 TYPE=TABLE NAME=LOGMNR_NEW Owner#=87 OBJ$ OBJ#=87799 TYPE=TABLE NAME=T Owner#=87 OBJ$ OBJ#=87800 TYPE=TABLE NAME=T1 Owner#=87 OBJ$ OBJ#=87931 TYPE=TABLE NAME=T1 Owner#=92 OBJ$ OBJ#=87932 TYPE=TABLE NAME=T2 Owner#=92.- StmtAuditOnCommit ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS
.- BadPublicObjects ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- BadSegFreelist ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- BadDepends ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- CheckDual ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- ObjectNames ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- BadCboHiLo ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- ChkIotTs ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- NoSegmentIndex ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- BadNextObject ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- DroppedROTS ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- FilBlkZero ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- DbmsSchemaCopy ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanedObjError ... 1102000400 > 1102000000 12/25 13:16:42 PASS .- ObjNotLob ... 1102000400 <= *All Rel* 12/25 13:16:42 FAILHCKE-0049: OBJ$ LOB entry has no LOB$ or LOBFRAG$ entry (Doc ID 2125104.1)
OBJ$ LOB has no LOB$ entry: Obj=87934 Owner: JYC LOB Name: SYS_LOB0000087933C00045$$.- MaxControlfSeq ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS
.- SegNotInDeferredStg ... 1102000400 > 1102000000 12/25 13:16:42 PASS .- SystemNotRfile1 ... 1102000400 > 902000000 12/25 13:16:42 PASS .- DictOwnNonDefaultSYSTEM ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- OrphanTrigger ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS .- ObjNotTrigger ... 1102000400 <= *All Rel* 12/25 13:16:42 PASS --------------------------------------- 25-DEC-2020 13:16:42 Elapsed: 0 secs --------------------------------------- Found 31 potential problem(s) and 0 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or notPL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc13:16:42 SQL> desc tab$;
Name Null? Type ----------------------------------------------------------------------------------------- -------- ------------------------------------------------------------ OBJ# NOT NULL NUMBER DATAOBJ# NUMBER TS# NOT NULL NUMBER FILE# NOT NULL NUMBER BLOCK# NOT NULL NUMBER BOBJ# NUMBER TAB# NUMBER COLS NOT NULL NUMBER CLUCOLS NUMBER PCTFREE$ NOT NULL NUMBER PCTUSED$ NOT NULL NUMBER INITRANS NOT NULL NUMBER MAXTRANS NOT NULL NUMBER FLAGS NOT NULL NUMBER AUDIT$ NOT NULL VARCHAR2(38) ROWCNT NUMBER BLKCNT NUMBER EMPCNT NUMBER AVGSPC NUMBER CHNCNT NUMBER AVGRLN NUMBER AVGSPC_FLB NUMBER FLBCNT NUMBER ANALYZETIME DATE SAMPLESIZE NUMBER DEGREE NUMBER INSTANCES NUMBER INTCOLS NOT NULL NUMBER KERNELCOLS NOT NULL NUMBER PROPERTY NOT NULL NUMBER TRIGFLAG NUMBER SPARE1 NUMBER SPARE2 NUMBER SPARE3 NUMBER SPARE4 VARCHAR2(1000) SPARE5 VARCHAR2(1000) SPARE6 DATE13:16:58 SQL> select * from tab$ where Obj#=87805;
rows will be truncatedrows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
no rows selected13:17:22 SQL> select * from obj$ where Obj#=87805;
rows will be truncatedrows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
OBJ# DATAOBJ# OWNER# NAME NAMESPACE SUBNAME TYPE# CTIME MTIME STI ---------- ---------- ---------- ------------------------------ ---------- ------------------------------ ---------- ------------------- ------------------- --- 87805 87805 86 SYS_EXPORT_SCHEMA_01 1 2 2020-12-24 15:34:41 2020-12-24 15:34:41 20213:17:35 SQL> delete from OBJ$ where obj#=87805;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87826;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87804;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87850;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87803;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87849;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87825;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87851;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87798;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87801;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87799;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87800;
1 row deleted.
13:18:44 SQL> delete from OBJ$ where obj#=87933;
1 row deleted.
13:18:45 SQL> commit;
Commit complete.
13:18:47 SQL> @hcheck.sql
HCheck Version 07MAY18 on 25-DEC-2020 13:18:55 ---------------------------------------------- Catalog Version 11.2.0.4.0 (1102000400) db_name: ORCLCatalog Fixed
Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- MissingOIDOnObjCol ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- SourceNotInObj ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OversizedFiles ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- PoorDefaultStorage ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- PoorStorage ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- TabPartCountMismatch ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedTabComPart ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- MissingSum$ ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- MissingDir$ ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- DuplicateDataobj ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- ObjSynMissing ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- ObjSeqMissing ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedUndo ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedIndex ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedIndexPartition ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedIndexSubPartition ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedTable ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedTablePartition ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedTableSubPartition ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- MissingPartCol ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedSeg$ ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedIndPartObj# ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- DuplicateBlockUse ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- FetUet ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- Uet0Check ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- SeglessUET ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadInd$ ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadTab$ ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadIcolDepCnt ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- ObjIndDobj ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- TrgAfterUpgrade ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- ObjType0 ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadOwner ... 1102000400 <= *All Rel* 12/25 13:18:55 FAILHCKE-0038: OBJ$.OWNER# not in USER$ (Doc ID 1361020.1)
OBJ$ OBJ#=87806 TYPE=LOB NAME=SYS_LOB0000087805C00045$$ Owner#=86 OBJ$ OBJ#=87827 TYPE=LOB NAME=SYS_LOB0000087826C00045$$ Owner#=86 OBJ$ OBJ#=87841 TYPE=LOB NAME=SYS_LOB0000087826C00096$$ Owner#=86 OBJ$ OBJ#=87931 TYPE=TABLE NAME=T1 Owner#=92 OBJ$ OBJ#=87932 TYPE=TABLE NAME=T2 Owner#=92.- StmtAuditOnCommit ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS
.- BadPublicObjects ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadSegFreelist ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadDepends ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- CheckDual ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- ObjectNames ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadCboHiLo ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- ChkIotTs ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- NoSegmentIndex ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- BadNextObject ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- DroppedROTS ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- FilBlkZero ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- DbmsSchemaCopy ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanedObjError ... 1102000400 > 1102000000 12/25 13:18:55 PASS .- ObjNotLob ... 1102000400 <= *All Rel* 12/25 13:18:55 FAILHCKE-0049: OBJ$ LOB entry has no LOB$ or LOBFRAG$ entry (Doc ID 2125104.1)
OBJ$ LOB has no LOB$ entry: Obj=87934 Owner: JYC LOB Name: SYS_LOB0000087933C00045$$.- MaxControlfSeq ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS
.- SegNotInDeferredStg ... 1102000400 > 1102000000 12/25 13:18:55 PASS .- SystemNotRfile1 ... 1102000400 > 902000000 12/25 13:18:55 PASS .- DictOwnNonDefaultSYSTEM ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- OrphanTrigger ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS .- ObjNotTrigger ... 1102000400 <= *All Rel* 12/25 13:18:55 PASS --------------------------------------- 25-DEC-2020 13:18:55 Elapsed: 0 secs --------------------------------------- Found 6 potential problem(s) and 0 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or notPL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc13:18:55 SQL> delete from OBJ$ where OBJ#=87806;
1 row deleted.
13:19:45 SQL> delete from OBJ$ where OBJ#=87827;
1 row deleted.
13:19:45 SQL> delete from OBJ$ where OBJ#=87841;
1 row deleted.
13:19:45 SQL> delete from OBJ$ where OBJ#=87931;
1 row deleted.
13:19:45 SQL> delete from OBJ$ where OBJ#=87932;
1 row deleted.
13:19:46 SQL> commit;
Commit complete.
13:19:48 SQL> @hcheck.sql
HCheck Version 07MAY18 on 25-DEC-2020 13:19:55 ---------------------------------------------- Catalog Version 11.2.0.4.0 (1102000400) db_name: ORCLCatalog Fixed
Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- MissingOIDOnObjCol ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- SourceNotInObj ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OversizedFiles ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- PoorDefaultStorage ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- PoorStorage ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- TabPartCountMismatch ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedTabComPart ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- MissingSum$ ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- MissingDir$ ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- DuplicateDataobj ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- ObjSynMissing ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- ObjSeqMissing ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedUndo ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedIndex ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedIndexPartition ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedIndexSubPartition ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedTable ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedTablePartition ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedTableSubPartition ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- MissingPartCol ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedSeg$ ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- OrphanedIndPartObj# ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- DuplicateBlockUse ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- FetUet ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- Uet0Check ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- SeglessUET ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadInd$ ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadTab$ ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadIcolDepCnt ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- ObjIndDobj ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- TrgAfterUpgrade ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- ObjType0 ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadOwner ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- StmtAuditOnCommit ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadPublicObjects ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadSegFreelist ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadDepends ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- CheckDual ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- ObjectNames ... 1102000400 <= *All Rel* 12/25 13:19:55 PASS .- BadCboHiLo ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- ChkIotTs ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- NoSegmentIndex ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- BadNextObject ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- DroppedROTS ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- FilBlkZero ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- DbmsSchemaCopy ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- OrphanedObjError ... 1102000400 > 1102000000 12/25 13:19:56 PASS .- ObjNotLob ... 1102000400 <= *All Rel* 12/25 13:19:56 FAILHCKE-0049: OBJ$ LOB entry has no LOB$ or LOBFRAG$ entry (Doc ID 2125104.1)
OBJ$ LOB has no LOB$ entry: Obj=87934 Owner: JYC LOB Name: SYS_LOB0000087933C00045$$.- MaxControlfSeq ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS
.- SegNotInDeferredStg ... 1102000400 > 1102000000 12/25 13:19:56 PASS .- SystemNotRfile1 ... 1102000400 > 902000000 12/25 13:19:56 PASS .- DictOwnNonDefaultSYSTEM ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- OrphanTrigger ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS .- ObjNotTrigger ... 1102000400 <= *All Rel* 12/25 13:19:56 PASS --------------------------------------- 25-DEC-2020 13:19:56 Elapsed: 1 secs --------------------------------------- Found 1 potential problem(s) and 0 warning(s) Contact Oracle Support with the output and trace file to check if the above needs attention or notPL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc13:19:56 SQL> delete from OBJ$ where OBJ#=87934;
1 row deleted.
13:20:23 SQL> commit;
Commit complete.
13:20:25 SQL> @hcheck.sql
HCheck Version 07MAY18 on 25-DEC-2020 13:20:30 ---------------------------------------------- Catalog Version 11.2.0.4.0 (1102000400) db_name: ORCLCatalog Fixed
Procedure Name Version Vs Release Timestamp Result ------------------------------ ... ---------- -- ---------- -------------- ------ .- LobNotInObj ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- MissingOIDOnObjCol ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- SourceNotInObj ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OversizedFiles ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- PoorDefaultStorage ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- PoorStorage ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- TabPartCountMismatch ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedTabComPart ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- MissingSum$ ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- MissingDir$ ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- DuplicateDataobj ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- ObjSynMissing ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- ObjSeqMissing ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedUndo ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedIndex ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedIndexPartition ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedIndexSubPartition ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedTable ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedTablePartition ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedTableSubPartition ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- MissingPartCol ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedSeg$ ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- OrphanedIndPartObj# ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- DuplicateBlockUse ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- FetUet ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- Uet0Check ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- SeglessUET ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- BadInd$ ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- BadTab$ ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- BadIcolDepCnt ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- ObjIndDobj ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- TrgAfterUpgrade ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- ObjType0 ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- BadOwner ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- StmtAuditOnCommit ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- BadPublicObjects ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- BadSegFreelist ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- BadDepends ... 1102000400 <= *All Rel* 12/25 13:20:30 PASS .- CheckDual ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- ObjectNames ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- BadCboHiLo ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- ChkIotTs ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- NoSegmentIndex ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- BadNextObject ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- DroppedROTS ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- FilBlkZero ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- DbmsSchemaCopy ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- OrphanedObjError ... 1102000400 > 1102000000 12/25 13:20:31 PASS .- ObjNotLob ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- MaxControlfSeq ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- SegNotInDeferredStg ... 1102000400 > 1102000000 12/25 13:20:31 PASS .- SystemNotRfile1 ... 1102000400 > 902000000 12/25 13:20:31 PASS .- DictOwnNonDefaultSYSTEM ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- OrphanTrigger ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS .- ObjNotTrigger ... 1102000400 <= *All Rel* 12/25 13:20:31 PASS --------------------------------------- 25-DEC-2020 13:20:31 Elapsed: 1 secs --------------------------------------- Found 0 potential problem(s) and 0 warning(s)PL/SQL procedure successfully completed.
Statement processed.
Complete output is in trace file:
/home/db/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_13048_HCHECK.trc13:20:31 SQL> drop user jyc cascade;
User dropped.
13:20:48 SQL> show parameter name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------ cell_offloadgroup_name string db_file_name_convert string db_name string orcl db_unique_name string orcl global_names boolean FALSE instance_name string orcl lock_name_space string log_file_name_convert string processor_group_name string service_names string orcl转载地址：http://ncsof.baihongyu.com/