19c 19.9.0.0 数据泵导出失败 NOCDB 模式，有INVALID的对象。找遍全网都无正确解决方案，

sys@ONELAB 23:13:28> SELECT NAME,cdb FROM v$database;

NAME CDB
-------------------------------------------------------------------------------- ------
ONELAB NO

Elapsed: 00:00:00.01

[oracle@QZLIMSDB:/home/oracle]$ expdp zwdba/***@10.199.11.108/ONELAB DUMPFILE=LIMS16.dmp logfile=LIMS16.log DIRECTORY=DATA_PUMP_DIR schemas=HUB PARALLEL=2

Export: Release 19.0.0.0.0 - Production on Thu Oct 31 23:08:34 2024
Version 19.9.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "ZWDBA"."SYS_EXPORT_SCHEMA_35": zwdba/********@10.130.11.108/ONELAB DUMPFILE=LIMS16.dmp logfile=LIMS16.log DIRECTORY=DATA_PUMP_DIR schemas=HUB PARALLEL=2
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-04063: package body "SYS.DBMS_METADATA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9749

----- PL/SQL Call Stack -----
object line object
handle number name
0x184041e80 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x184041e80 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x184041e80 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x184041e80 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x184041e80 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x184041e80 2439 package body SYS.KUPW$WORKER.MAIN
0x142b8a8b0 2 anonymous block

DBMS_LOB.CREATETEMPORARY v_dml_xml_clob
KUPW: In UNLOAD_METADATA
KUPW: Flags: 128
KUPW: Start sequence number:
KUPW: End sequence number:
KUPW: **NOT** Doing Parallel metadata
KUPW: In procedure CONFIGURE_METADATA_UNLOAD
KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
DBMS_METADATA.OPEN19.0.0.0.0
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-04063: package body "SYS.DBMS_METADATA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA"

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD []
ORA-04063: package body "SYS.DBMS_METADATA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 12617
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9749

----- PL/SQL Call Stack -----
object line object
handle number name
0x184041e80 33543 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x184041e80 12651 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x184041e80 10244 package body SYS.KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
0x184041e80 3838 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x184041e80 13746 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x184041e80 2439 package body SYS.KUPW$WORKER.MAIN
0x142b8a8b0 2 anonymous block

DBMS_LOB.CREATETEMPORARY v_dml_xml_clob
KUPW: In UNLOAD_METADATA
KUPW: Flags: 129
KUPW: Start sequence number:
KUPW: End sequence number:
KUPW: **NOT** Doing Parallel metadata
KUPW: In procedure CONFIGURE_METADATA_UNLOAD
KUPW: Phase: Filter Name: BEGIN_AFTER Filter Value:
DBMS_METADATA.OPEN19.0.0.0.0
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-04063: package body "SYS.DBMS_METADATA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA"

Job "ZWDBA"."SYS_EXPORT_SCHEMA_35" stopped due to fatal error at Thu Oct 31 23:08:38 2024 elapsed 0 00:00:03

[oracle@QZLIMSDB:/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 31 23:13:25 2024
Version 19.9.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0

select owner,object_name,object_type,status from dba_objects where status = 'INVALID';
"SYS" "KU$_PRIM_COLUMN_VIEW" "VIEW" "INVALID"
"SYS" "KU$_COLUMN_VIEW" "VIEW" "INVALID"
"SYS" "KU$_PCOLUMN_VIEW" "VIEW" "INVALID"
"SYS" "KU$_P2TPARTCOL_VIEW" "VIEW" "INVALID"
"SYS" "KU$_SP2TPARTCOL_VIEW" "VIEW" "INVALID"
"SYS" "KU$_P2TCOLUMN_VIEW" "VIEW" "INVALID"
"SYS" "KU$_SP2TCOLUMN_VIEW" "VIEW" "INVALID"
"SYS" "KU$_HTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_PHTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_FHTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_2_FHTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_PFHTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_ACPTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_PARTITION_VIEW" "VIEW" "INVALID"
"SYS" "KU$_SUBPARTITION_VIEW" "VIEW" "INVALID"
"SYS" "KU$_IOTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_PIOTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_XMLSCHEMA_VIEW" "VIEW" "INVALID"
"SYS" "KU$_EXP_XMLSCHEMA_VIEW" "VIEW" "INVALID"
"SYS" "KU$_NT_PARENT_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_HTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_PHTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_FHTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_PFHTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_IOTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_PIOTABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_VIEW_VIEW" "VIEW" "INVALID"
"SYS" "KU$_11_2_VIEW_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_H_VIEW" "VIEW" "INVALID"
"SYS" "KU$_ZM_VIEW_H_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_PH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_ZM_VIEW_PH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_FH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_ZM_VIEW_FH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_PFH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_ZM_VIEW_PFH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_IOT_VIEW" "VIEW" "INVALID"
"SYS" "KU$_ZM_VIEW_IOT_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_PIOT_VIEW" "VIEW" "INVALID"
"SYS" "KU$_ZM_VIEW_PIOT_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_ZONEMAP_H_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_ZONEMAP_PH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_ZONEMAP_FH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_ZONEMAP_PFH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_ZONEMAP_IOT_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_ZONEMAP_PIOT_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_LOG_H_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_LOG_PH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_LOG_FH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_M_VIEW_LOG_PFH_VIEW" "VIEW" "INVALID"
"SYS" "KU$_CLUSTER_VIEW" "VIEW" "INVALID"
"SYS" "KU$_QTAB_STORAGE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_QUEUE_TABLE_VIEW" "VIEW" "INVALID"
"SYS" "KU$_HISTGRM_VIEW" "VIEW" "INVALID"
"SYS" "KU$_COL_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_TAB_COL_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_PTAB_COL_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_TAB_ONLY_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_TAB_ONLY_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_PTAB_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_PTAB_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_11_2_TAB_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_2_TAB_STATS_VIEW" "VIEW" "INVALID"
"SYS" "KU$_10_1_TAB_STATS_VIEW" "VIEW" "INVALID"
"SYS" "DBMS_METADATA" "PACKAGE BODY" "INVALID"
"XDB" "XDB_PV_TRIG" "TRIGGER" "INVALID"
"SYS" "DBMS_CUBE_ADVISE" "PACKAGE BODY" "INVALID"