expdp导出报ORA-39097: Data Pump job encountered unexpected error -1001

jiawang

环境介绍：
OS：centos 7.8
db:19.3

expdp导出报错：

[oracle@sztech~]$ expdp system/oracle directory=dump_dir dumpfile=dmpfile.dmp  version=11.2.0.4.0  transport_tablespaces='tb1,tb2';

Export:Release 19.0.0.0.0 - Production on Fri Aug 5 17:37:13 2022

Version19.3.0.0.0

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

UDE-28002:operation generated ORACLE error 28002

ORA-28002:the password will expire within 7 days

Connectedto: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

ORA-39006:internal error

ORA-39065:unexpected master process exception in DISPATCH

ORA-01001:invalid cursor

ORA-06512:at "SYS.DBMS_METADATA_UTIL", line 3405

ORA-06512:at "SYS.KUPM$MCP", line 2635

ORA-39097: Data Pump jobencountered unexpected error -1001

解决办法：

SQL>select count(*) from metanametrans$;

sqlplus/ as sysdba
@$ORACLE_HOME/rdbms/admin/catmet2.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
详情见文档

DataPump JobReports ORA-39097: Data Pump job encountered unexpected error 100 (文档 ID 453796.1)

再次导出成功

[oracle@sztech ~]$ expdpsystem/oracle directory=dump_dir dumpfile=dmpfile.dmp  version=11.2.0.4.0  transport_tablespaces='tb1,tb2';

Export: Release 19.0.0.0.0 - Production onFri Aug 5 17:49:19 2022

Version 19.3.0.0.0

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

UDE-28002: operation generated ORACLE error28002

ORA-28002: the password will expire within7 days

Connected to: Oracle Database 19cEnterprise Edition Release 19.0.0.0.0 - Production

Starting"SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01":  system/******** directory=dump_dir dumpfile=dmpfile.dmpversion=11.2.0.4.0 transport_tablespaces=tb1,tb2

Processing object typeTRANSPORTABLE_EXPORT/PLUGTS_BLK

Processing object typeTRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK

Processing object typeTRANSPORTABLE_EXPORT/TABLE

Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"successfully loaded/unloaded

******************************************************************************

Dump file set forSYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:

/u01/app/oracle/dumpdir/dmpfile.dmp

******************************************************************************

Datafiles required for transportabletablespace TB1:

/u01/app/oracle/oradata/orcl/tb1.dbf

Datafiles required for transportabletablespace TB2:

/u01/app/oracle/oradata/orcl/tb2.dbf

Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"successfully completed at Fri Aug 5 17:50:59 2022 elapsed 0 00:01:33

[oracle@sztech ~]$