Download latest autoupgrade.jar
Download the latest autoupgrade from MOS
you download the most recent version from MOS Note: 2485457.1 – AutoUpgrade Tool:
Create the autoupgrade config file
# ============================================================# Global settings# ============================================================global.autoupg_log_dir=/home/oracle/DBA/autoupgrade# ============================================================upg1.source_home=/u01/app/oracle/product/12.2.0/dbhome_1upg1.target_home=/u01/app/oracle/product/19.0.0/dbhome_1upg1.sid=TEST2upg1.dbname=TEST2upg1.target_cdb=CDBTEST2upg1.target_pdb_name=TEST2upg1.start_time=nowupg1.log_dir=/home/oracle/autoupgradeupg1.run_utlrp=yes # Run UTLRP after the upgradeupg1.timezone_upg=yesupg1.target_pdb_copy_option=file_name_convert=('+DATA1', '+DATA2')upg1.upgrade_node=ora004# ============================================================
Run Autoupgrade in analyze mode
Run Autoupgrade in analyze mode[TEST2] oracle@ora004:~/TEST2$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config autoupgrade.cfg -mode analyzeAutoUpgrade 25.4.250730 launched with default internal optionsProcessing config file ...Note: The following parameters specified in the configuration file have not been used: upg1.dbnameBe sure that each parameter is spelled correctly and applies to the utilityrequested, as misspelled or unknown parameters are ignored by AutoUpgrade.For supported parameters, see section "AutoUpgrade Utility Configuration FilesParameters and Options" in the Oracle Database Upgrade Guide.+--------------------------------+| Starting AutoUpgrade execution |+--------------------------------+1 Non-CDB(s) will be analyzedType 'help' to list console commandsupg> help given time from command executionupg> Job 101 completed------------------- Final Summary --------------------Number of databases [ 1 ]Jobs finished [1]Jobs failed [0]Please check the summary report at:/home/oracle/TEST2/cfgtoollogs/upgrade/auto/status/status.html/home/oracle/TEST2/cfgtoollogs/upgrade/auto/status/status.log[TEST2] oracle@ora004:~/TEST2$
Run Autoupgrade in fixups mode
[TEST2] oracle@ora004:~/TEST2$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config autoupgrade.cfg -mode fixups
Run Autoupgrade in Deploy mode
TEST2] oracle@ora004:~/TEST2$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config autoupgrade.cfg -mode deployupg> lsj+----+--------+---------+---------+-------+----------+-------+----------------------------+|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|+----+--------+---------+---------+-------+----------+-------+----------------------------+| 103|TEST2|PRECHECKS|EXECUTING|RUNNING| 12:06:18|10s ago|Loading database information|+----+--------+---------+---------+-------+----------+-------+----------------------------+Total jobs 1upg> lsj+----+--------+-----+---------+-------+----------+-------+----------------------+|Job#| DB_NAME|STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|+----+--------+-----+---------+-------+----------+-------+----------------------+| 103|TEST2|DRAIN|EXECUTING|RUNNING| 12:06:18|10s ago|Shutting down database|+----+--------+-----+---------+-------+----------+-------+----------------------+Total jobs 1upg> lsj+----+--------+---------+---------+-------+----------+-------+-------+|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED|MESSAGE|+----+--------+---------+---------+-------+----------+-------+-------+| 103|TEST2|DBUPGRADE|EXECUTING|RUNNING| 12:06:18|19s ago|Running|+----+--------+---------+---------+-------+----------+-------+-------+Total jobs 1upg> lsj+----+--------+---------+---------+-------+----------+-------+------------+|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|+----+--------+---------+---------+-------+----------+-------+------------+| 103|TEST2|DBUPGRADE|EXECUTING|RUNNING| 12:06:18|15s ago|39%Upgraded |+----+--------+---------+---------+-------+----------+-------+------------+Total jobs 1upg> lsj+----+--------+----------+---------+-------+----------+-------+----------------+|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|+----+--------+----------+---------+-------+----------+-------+----------------+| 103|TEST2|POSTFIXUPS|EXECUTING|RUNNING| 12:06:18|16s ago|Executing fixups|+----+--------+----------+---------+-------+----------+-------+----------------+Total jobs 1upg> lsj+----+--------+-----------+---------+-------+----------+-------+---------------------+|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|+----+--------+-----------+---------+-------+----------+-------+---------------------+| 103|TEST2|POSTUPGRADE|EXECUTING|RUNNING| 12:06:18|24s ago|Creating final SPFILE|+----+--------+-----------+---------+-------+----------+-------+---------------------+Total jobs 1upg> lsj+----+--------+-----------+---------+-------+----------+-------+----------+|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|+----+--------+-----------+---------+-------+----------+-------+----------+| 103|TEST2|POSTUPGRADE|EXECUTING|RUNNING| 12:06:18| 1s ago|Restarting|+----+--------+-----------+---------+-------+----------+-------+----------+Total jobs 1upg> Job 103 completed------------------- Final Summary --------------------Number of databases [ 1 ]Jobs finished [1]Jobs failed [0]Jobs restored [0]Jobs pending [0]---- Drop GRP at your convenience once you consider it is no longer needed ----Drop GRP from TEST2: drop restore point AUTOUPGRADE_9212_TEST2122010Please check the summary report at:/home/oracle/TEST2/cfgtoollogs/upgrade/auto/status/status.html/home/oracle/TEST2/cfgtoollogs/upgrade/auto/status/status.log[TEST2] oracle@ora004:~/TEST2$[TEST2] oracle@ora004:~/TEST2$
Drop restore point
SQL> select name from v$restore_point;NAME--------------------------------------------------------------------------------GRP_1763508671856AUTOUPGRADE_9212_TEST2122010SQL>
TechToday