Pages

Monday, January 30, 2023

expdp error "ORA-39021: Database compatibility version 19.xx.0.0.0 is not supported."

=============
Issue
=============
Error during expdp version 19.x
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39021: Database compatibility version 19.4.0.0.0 is not supported.


=============
Investigation
=============
Per Oracle technote "DataPump Reports ORA-39021: Database compatibility version 19.X.0.0.0 is not supported (Doc ID 2610939.1)"

After upgrade to 19.x, compatible parameter is increased, because RU or an RUR changed the COMPATIBLE parameter.

SQL> show parameter compatible
NAME          TYPE        VALUE
------------- ----------- ----------
compatible    string      19.4.0

This is due to bug #30828205 - EXPDP IS FAILING WITH ORA-39021 WHEN COMPATIBLE IS SET AS 19.4.0.

Data Pump uses DBMS_UTILITY.DB_VERSION() to retrieve the current local database version.
Compatibility version was raised to the level of RU installation.
So database compatibility version was raised, but datapump version was not.
Thus the error "Database compatibility version 19.4.0.0.0 is not supported".

Solution

Upgrade to  19.11.0.0.210420DBRU.
In this version this bug was fixed

Workaround
Add parameter VERSION=19.0.0 to expdp command

No comments:

Post a Comment