FIXING APEX ERROR DURING UPGRADATION IN PDB

FIXING APEX ERROR DURING UPGRADATION IN PDB

INTRODUCTION :-

I got the following APEX error in 19C pluggable database while upgrading the PDB database from lower version (12C) to higher version (19C)

ERROR :

Error getting while plugging PDB from 12c PDB to 19c PDB

TO RESOLVE THIS ERROR :-

STEP 1 : CHECK THE APEX VERSION AND DETAILS IN 12C PDB

STEP 2 : CHECK THE APEX VERSION AND DETAILS IN 19C PDB

 Therefore there are no APEX version in 19c PDB which was in 12c 

STEP 3 : Go to the apex location in 12c

STEP 4 : connect to the database and run the APEX remove command @apxremov_con

STEP 5 : Recompile all invalid objects

 ERROR RESOLVED

CONCLUSION :- 

While doing upgradation from lower version to higher version in PDB, check whether APEX version is same or not in both versions .if it is not same the apex error will occurs. So we have to add or remove the apex files in any one of the databases.