12c to 19c upgrade by autoupgrade

Prerequisite

1) Download autoupgrade.jar file from MOS 2485457.1

mv  /u01/app/oracle/product/19c/db_1/rdbms/admin/autoupgrade.jar autoupgrade.jar_old

cp -r autoupgrade.jar /u01/app/oracle/product/19c/db_1/rdbms/admin

$ /u01/app/oracle/product/19c/db_1/jdk/bin/java -jar /u01/app/oracle/product/19c/db_1/rdbms/admin/autoupgrade.jar -version

$ /u01/app/oracle/product/19c/db_1/jdk/bin/java -version

 

 For an upgrade, the java version should be 1.8 which is available in “ORACLE_HOME/jdk/bin” so make sure match to the minimum required version of java.

 cd /u01/autoupgrade_19c

$ /u01/app/oracle/product/19c/db_1/jdk/bin/java -jar /u01/app/oracle/product/19c/db_1/rdbms/admin/autoupgrade.jar -create_sample_file config

$ cp sample_config.cfg prod_db_config.cfg

$ > prod_db_config.cfg

$ vi prod_db_config.cfg

upg1.dbname=prod

upg1.start_time=NOW

upg1.source_home=/u01/app/oracle/product/12/db_1

upg1.target_home=/u01/app/oracle/product/19c/db_1

upg1.sid=prod

upg1.log_dir=/u01/autoupgrade_19c/upg_logs/prod

upg1.upgrade_node=hostname (select host_name from v$instance;)

upg1.target_version=19.11

upg1.run_utlrp=yes

upg1.timezone_upg=yes

 

 

 

 

export ORACLE_HOME=/u01/app/oracle/product/19c/db_1/

export PATH=$PATH:$ORACLE_HOME/jdk/bin

cd u01/autoupgrade_19c

$ /u01/app/oracle/product/19c/db_1/jdk/bin/java -jar /u01/app/oracle/product/19c/db_1/rdbms/admin/autoupgrade.jar -config prod_db_config.cfg -mode ANALYZE

 

lsj - to list the jobs

status -job 101 - to show the job status

$ /u01/app/oracle/product/19c/db_1/jdk/bin/java -jar /u01/app/oracle/product/19c/db_1/rdbms/admin/autoupgrade.jar -config prod_db_config.cfg -mode DEPLOY

Autoupgrade logs are available at below location

/u01/autoupgrade_19c/upg_logs

tail below log and as well as database alert log for monitoring. Also user lsj and status command

 

select name from v$restore_point;

drop restore point restorepoint_name;

show parameter compatible

alter system set conpatible='19.0.0' scope=spfile;

shutdown immediate;

startup;

show parameter compatible;

 Ref https://www.youtube.com/watch?v=UPYGd78USSw&t=2478s