My Oracle Support Banner

19c Data Pump Fails with "Stopped due to Fatal Error" Message After Upgrading to 19c Using the DBMS_ROLLING Package (Doc ID 2872191.1)

Last updated on JUNE 17, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading to Oracle RDBMS 19c using the DBMS_ROLLING package (to do a rolling upgrade), Data Pump fails with a message similar to the following:

If the database was upgraded in a non-rolling fashion, then there is no error. Analysis of tracing for the Data Pump session reveals that the fatal statement is

ALTER SESSION ENABLE PARALLEL DML

The error that this statement receives is:

ORA-12841: Cannot alter the session parallel DML state within a transaction

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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