UPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD

UPGRADE 12C to 19C IN PDB USING AUTOUPGRADE METHOD

 

LOG INTO THE DATABASE AND MAKE SURE THE CORRECT ORACLE HOME HAS BEEN SET.

CHECK STATUS OF ARCHIVELOG MODE IN THE DATABASE AND CHANGE IT TO ARCHIVE MODE AND TURN FLASHBACK ON

CREATE A NEW AUTOUPGRADE FOLDER AND NEW CONFIGUE FILE

ENTER THE DETAILS IN THE CONFIGURE FILES

CREATE ENV FOR 19C  AND SET PATH TO BOTH 12C AND 19C

DOWNLOAD THE 19C SOFTWARE IN THE db_1 UNZIP THE FILE AND RUN THE RUNINSTALLER

FOR PRECHECKS FOR THE UPGRADE EMPTY THE RECYCLEBIN AND EXECUTE THE GATHER STATS AND SET THE FILE_RECOVERY_DESK=8G

EXECUTE THE ANALYZE PHASE OF THE AUTO UPGRADE TOOL WITH THE NEW CDB19 ENVIRONMENT

START THE FULL UPGRADE USING THE AUTOUPGRADE FEATURE  IN 19C ENV

 

Now connect to the database and check whether it is updated or not

AFTER UPGRADE DROP THE RESTORE POINT

SET THE COMPATIBLE FILE TO UPDATED VERSION 19.3.0.0.0

THEN ATLAST SHUTDOWN AND STARTUP THE DATABASE