$ expdp system/system full=y directory=EXPDPIMPDP2 dumpfile=20170819_%U.dmp parallel=4 job_name=expimpdp
Export: Release 11.2.0.3.0 - Production on Sat Aug 19 02:10:19 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting “SYSTEM”.”EXPIMPDP”: system/** full=y directory=EXPDPIMPDP2 dumpfile=20170819_%U.dmp parallel=4 job_name=expimpdp
Estimate in progress using BLOCKS method…
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN “DMSYS”.”DBMS_DM_MODEL_EXP”.SCHEMA_CALLOUT(:1,0,1,’11.02.00.00.00’); END;
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.DBMS_METADATA”, line 1749
ORA-06550: line 1, column 8:
PLS-00201: identifier ‘DMSYS.DBMS_DM_MODEL_EXP’ must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.KUPW$WORKER”, line 8996
重点内容
—– PL/SQL Call Stack —–
object line object
handle number name
0x8bc99b38 20462 package body SYS.KUPW$WORKER
0x8bc99b38 9028 package body SYS.KUPW$WORKER
0x8bc99b38 10935 package body SYS.KUPW$WORKER
0x8bc99b38 13698 package body SYS.KUPW$WORKER
0x8bc99b38 2654 package body SYS.KUPW$WORKER
0x8bc99b38 9697 package body SYS.KUPW$WORKER
0x8bc99b38 1775 package body SYS.KUPW$WORKER
0x8bf236a8 2 anonymous block
Estimate in progress using BLOCKS method…
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN “DMSYS”.”DBMS_DM_MODEL_EXP”.SCHEMA_CALLOUT(:1,0,1,’11.02.00.00.00’); END;
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.DBMS_METADATA”, line 1749
ORA-06550: line 1, column 8:
PLS-00201: identifier ‘DMSYS.DBMS_DM_MODEL_EXP’ must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.KUPW$WORKER”, line 8996
—– PL/SQL Call Stack —–
object line object
handle number name
0x8bc99b38 20462 package body SYS.KUPW$WORKER
0x8bc99b38 9028 package body SYS.KUPW$WORKER
0x8bc99b38 10935 package body SYS.KUPW$WORKER
0x8bc99b38 13698 package body SYS.KUPW$WORKER
0x8bc99b38 2654 package body SYS.KUPW$WORKER
0x8bc99b38 9697 package body SYS.KUPW$WORKER
0x8bc99b38 1775 package body SYS.KUPW$WORKER
0x8bf236a8 2 anonymous block
Job “SYSTEM”.”EXPIMPDP” stopped due to fatal error at 02:11:40
这个问题是需要 重建dmsys用户
SQL> drop user dmsys cascade;
SQL> @？/rdbms/admin/dminst.sql SYSAUX TEMP $ORACLE_HOME/rdbms/admin/
SQL> @？/rdbms/admin/odmpatch.sql
SQL> @？/rdbms/admin/utlrp.sql
SQL> select COMP_NAME,VERSION,STATUS from dba_registry where COMP_NAME=’Oracle Data Mining’;
SQL> create synonym DMSYS.DBMS_DM_MODEL_EXP for SYS.DBMS_DM_MODEL_EXP;