我一直在測試從 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 實例讓您失望了。但是讓我們從頭開始。

並行 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-00800: 軟外部錯誤，參數：$$ Set Priority Failed $$,$$ VKTM $$，適用於 Oracle Linux（文件 ID 2718971.1）（*nix 系統上的 Oracle）
• ORA-00800：軟外部錯誤，參數：$$ Set Priority Failed $$,$$ VKTM $$ $$ Check traces and OS configuration $$（文件 ID 2551359.1）（IBM AIX 系統上的 Oracle）

ORA-00313 錯誤

• 添加新的重做日誌成員後啟動時出現 ORA-00313（文件 ID 1005110.6）

ORA-07445

• ORA-7445 故障排除工具（Oracle 線上故障排除工具）

此選項要求您將 IPS 包上傳到 Oracle，以便他們分析數據。如果您使用 Oracle 創建 SR 並在案例中提供錯誤消息 ORA-7445，那麼您將被自動重定向到此工具。但是，該連結下有一個可下載的版本。

如果一切都失敗了

嘗試將 12c 對象導入 19c 時似乎確實存在問題，因此您可能需要聯繫經過認證的 Oracle 顧問，或者如果您有 Oracle 支持標識符，請打開新的服務請求。

引用自：https://dba.stackexchange.com/questions/287169