主页 / dba / 问题 / 287169
Accepted
Mary Ann
Asked: 2021-03-18 00:27:01 +0800 CST

ORA-39014 从 Oracle12c 的 DMP 文件导入 Oracle 19c

  • 772

我一直在测试从 12c 到 19c（新创建的数据库）的数据库的 expdp/impdp，但是一个数据库让我遇到了这个错误：

nohup impdp system/****@CKLPROD CONTENT=METADATA_ONLY PARALLEL=4 DIRECTORY=DATA_PUMP_DIR DUMPFILE=EXP_CKLPROD_20210317_B419C.DMP LOGFILE=IMP_CKLPROD_20210317_B419C_META.log > IMP_CKLPROD_20210317_B419C_META.out &

> Processing object type
> DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE ORA-39014: One or
> more workers have prematurely exited. ORA-39029: worker 1 with process
> name "DW00" prematurely terminated ORA-39014: One or more workers have
> prematurely exited. ORA-39029: worker 2 with process name "DW00"
> prematurely terminated Job "SYSTEM"."SYS_IMPORT_SCHEMA_02" stopped due
> to fatal error at Wed Mar 17 14:04:14 2021 elapsed 0 00:18:42

警报日志有以下 ORA 错误：

Line 122: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 355: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 508: ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Line 639: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 781: ORA-00313: open failed for members of log group 1 of thread 1
Line 784: ORA-00313: open failed for members of log group 1 of thread 1
Line 788: ORA-00313: open failed for members of log group 2 of thread 1
Line 791: ORA-00313: open failed for members of log group 2 of thread 1
Line 795: ORA-00313: open failed for members of log group 3 of thread 1
Line 798: ORA-00313: open failed for members of log group 3 of thread 1
Line 803: ORA-00313: open failed for members of log group 1 of thread 1
Line 806: ORA-00313: open failed for members of log group 1 of thread 1
Line 810: ORA-00313: open failed for members of log group 2 of thread 1
Line 813: ORA-00313: open failed for members of log group 2 of thread 1
Line 817: ORA-00313: open failed for members of log group 3 of thread 1
Line 820: ORA-00313: open failed for members of log group 3 of thread 1
Line 2208: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 3062: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 3900: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 4733: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 5055: ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
Line 5834: ORA-07445: exception encountered: core dump [ph2csql_idndef_to_diana()+39] [SIGSEGV] [ADDR:0x0] [PC:0x55CDCD7] [SI_KERNEL(general_protection)] []
Line 5853: ORA-07445: exception encountered: core dump [ph2csql_idndef_to_diana()+39] [SIGSEGV] [ADDR:0x0] [PC:0x55CDCD7] [SI_KERNEL(general_protection)] []
oracle import

1 个回答

  1. Best Answer

    看起来您的 Oracle 实例让您失望了。但是让我们从头开始。

    并行 IMPDP

    要使用参数执行IMPDP命令，PARALLEL您必须满足以下要求：

    • 该参数仅在Oracle 数据库 11g 或更高版本的企业版 （勾选）中有效。

    • 要并行导入表或表分区（使用 PQ 从属），您必须具有DATAPUMP_IMP_FULL_DATABASE （检查）角色。

    • 无法并行导入可传输表空间元数据。

    • 同时使用 NETWORK_LINK 参数时，无法并行导入元数据

    • 以下对象不能并行导入：

      • 扳机
      • 看法
      • OBJECT_GRANT
      • 序列
      • 约束
      • REF_CONSTRAINT。

    参考： 3. 数据泵导入 | 并行（Oracle 帮助中心）

    ORA-xxxxx 错误

    免责声明
    由于版权限制，我只能为您提供一些指向 Oracle Doc ID 的一般链接，这些链接可能会或可能不会为您提供问题的解决方案。需要注册才能完整查看此信息。

    ORA-00800 错误

    ORA-00313 错误

    ORA-07445

    此选项要求您将 IPS 包上传到 Oracle，以便他们分析数据。如果您使用 Oracle 创建 SR 并在案例中提供错误消息 ORA-7445，那么您将被自动重定向到此工具。但是，该链接下有一个可下载的版本。

    如果一切都失败了

    尝试将 12c 对象导入 19c 时似乎确实存在问题，因此您可能需要联系经过认证的 Oracle 顾问，或者如果您有 Oracle 支持标识符，请打开新的服务请求。

    • 3

相关问题