Oracle database upgrade by using Autoupgrade

High-level Steps For Auto-Upgrade

1. Install Oracle 19.3.0.0 binaries

2. Prerequisite for Auto upgrade

3. Create the config file

4. Analyze the database

5. Deploy the upgrade

6. Post upgrade task

AutoUpgrade – Step-by-Step

1. Install Oracle 19.3.0.0 binaries

I have already completed the installation of 19c

2. Prerequisite for Autoupgrade

Download the latest file of autoupgrade.jar

• The autoupgrade.jar file exists by default, In Oracle Database 19c (19.3) and the later target Oracle homes.

• The autoupgrade. jar file is available in the Oracle 19c database software in the $ORACLE_HOME/rdbms/admin directory.

• Before you use AutoUpgrade, Oracle recommends that you download the latest Autoupgrade version and replace the autoupgrade.jar with the latest version downloaded.

3. Create the config file

$vi /home/oracle/upgrade/autoupgrade.txt

global.autoupg_log_dir=/home/oracle/upgrade

upg1.dbname=ora

upg1.source_home=/u01/app/oracle/product/12c/db_home/

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

upg1.sid=ora

upg1.log_dir=/home/oracle/upgrade

upg1.start_time=NOW

upg1.target_version=19

4. Analyze the database

[oracle@db3 upgrade]$ java -jar autoupgrade.jar -config config.txt -mode analyze

AutoUpgrade 26.2.260205 launched with default internal options

Processing config file ...

Note: The following parameters specified in the configuration file have not been used:

        upg1.dbname

Be sure that each parameter is spelled correctly and applies to the utility

requested, as misspelled or unknown parameters are ignored by AutoUpgrade.

For supported parameters, see section "AutoUpgrade Utility Configuration Files

Parameters and Options" in the Oracle Database Upgrade Guide.

+--------------------------------+

| Starting AutoUpgrade execution |

+--------------------------------+

1 Non-CDB(s) will be analyzed

Type 'help' to list console commands

upg> Job 103 completed

------------------- Final Summary --------------------

Number of databases            [ 1 ]

Jobs finished                  [1]

Jobs failed                    [0]

Please check the summary report at:

/home/oracle/upgrade/cfgtoollogs/upgrade/auto/status/status.html

/home/oracle/upgrade/cfgtoollogs/upgrade/auto/status/status.log

[oracle@db3 upgrade]$