Downgrade fails with ORA-20000: Upgrade from version 12.1.0 cannot be downgraded to version 12.1.0.2 (Doc ID 2737761.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

During CDB downgrade  from 122 to 121, while executing catrelod.sql on 12.1 side, it fails with following error:

SQL> DECLARE
 2    p_prv_version sys.registry$.prv_version%type;
 3    p_version sys.registry$.version%type;
 4  BEGIN
 5    SELECT prv_version, version INTO p_prv_version, p_version
 6    FROM registry$ WHERE cid = 'CATPROC' AND namespace = 'SERVER';
 7    IF p_prv_version IS NOT NULL AND SUBSTR(p_prv_version,1,8) != '12.1.0.2' THEN
 8    RAISE_APPLICATION_ERROR (-20000,
 9       'Upgrade from version ' || p_prv_version ||
10       ' cannot be downgraded to version 12.1.0.2');
11    END IF;
12    IF p_version='12.1.0' THEN
13    update registry$ set version=p_prv_version WHERE cid = 'CATPROC' AND namespace = 'SERVER';
14    commit;
15    END IF;
16  END;
17  /
DECLARE
*
ERROR at line 1:
ORA-20000: Upgrade from version 12.1.0 cannot be downgraded to version 12.1.0.2
ORA-06512: at line 8

Changes

Cause

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