Issue With DMS Migration-JK1 Job Failure (Doc ID 3008192.1)

Last updated on MAY 07, 2024

Applies to:

Symptoms

DBCS to ADB offline migration failed with following error:

<HOST1>: 2024-02-23T01:44:45.955Z : Executing phase ZDM_PREPARE_DATAPUMP_TGT
<HOST1>: 2024-02-23T01:44:45.956Z : Execution of phase ZDM_PREPARE_DATAPUMP_TGT completed
<HOST1>: 2024-02-23T01:44:45.967Z : Executing phase ZDM_DATAPUMP_EXPORT_SRC
<HOST1>: 2024-02-23T01:44:45.968Z : starting Data Pump Export for database "<DBNAME>"
<HOST1>: 2024-02-23T01:44:46.008Z : running Oracle Data Pump job "ZDM_674_DP_EXPORT_1417" for database "<DBNAME>"
<HOST1>: 2024-02-23T01:44:46.012Z : Oracle Data Pump Export dump file size set to 5000M ...
<HOST1>: 2024-02-23T01:44:46.012Z : applying Data Pump dump compression ALL algorithm MEDIUM
<HOST1>: 2024-02-23T01:44:46.065Z : applying Data Pump dump encryption ALL algorithm AES128
<HOST1>: 2024-02-23T01:44:46.065Z : Oracle Data Pump Export parallelism set to 4 ...
<HOST1>: 2024-02-23T01:44:46.066Z : Oracle Data Pump errors to be ignored are ORA-31684,ORA-39111,ORA-39082...
<HOST1>: 2024-02-23T01:44:51.926Z : Oracle Data Pump log ZDM_674_DP_EXPORT_1417.log uploaded to Oracle cloud storage bucket bucket-dms-migration
PRGD-1019 : creation of Data Pump job "ZDM_674_DP_EXPORT_1417" with operation type "EXPORT_OFFLINE" failed
PRGD-1016 : stored procedure "DBMS_DATAPUMP.OPEN" execution as user "system" failed for database with Java Database Connectivity (JDBC) URL "jdbc:oracle:thin:@(description=(address=(protocol=tcp)(port=1521)(host=254.24.128.0))(connect_data=(service_name=<SERVICE_NAME>)))"
ORA-20000: Datapump: Unexpected error
ORA-06512: at line 1
ORA-39002: invalid operation
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4929
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5180
ORA-06512: at line 1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.