Trending
LeukO 2026 to Unite the Global Leukemia Community This September is trending now Lab Chemical Exposure, Diet Tied to Young Scientists' Health is trending now Rising Seas Not the Only Threat to Coastal Cities is trending now Myles Lewis-Skelly transfer news: Chelsea and Man Utd turn down intermediary offer to sig… is trending now Somali denied World Cup ‘proud’ to referee PSG vs Villa in UEFA Super Cup is trending now PSG vs Aston Villa: UEFA Super Cup – prediction, lineups, teams is trending now Bukky Wright Calls Out Nollywood Actors Who Show Up Five Hours Late to Set is trending now Mama G Shares Reasons She Always Plays Witch Roles in Nollywood Movies: "Na That Eye I De… is trending now "Big things are coming": 70 vendors ready for Adedimeji's triplets' celebration is trending now Ex-gang leader faces trial over 1996 Tupac Shakur murder is trending now Aurodig targets data-conscious mobile users with new approach to streaming is trending now Pin Up Casino Kenya: Which Games Kenyans Are Choosing in 2026 is trending now LeukO 2026 to Unite the Global Leukemia Community This September is trending now Lab Chemical Exposure, Diet Tied to Young Scientists' Health is trending now Rising Seas Not the Only Threat to Coastal Cities is trending now Myles Lewis-Skelly transfer news: Chelsea and Man Utd turn down intermediary offer to sig… is trending now Somali denied World Cup ‘proud’ to referee PSG vs Villa in UEFA Super Cup is trending now PSG vs Aston Villa: UEFA Super Cup – prediction, lineups, teams is trending now Bukky Wright Calls Out Nollywood Actors Who Show Up Five Hours Late to Set is trending now Mama G Shares Reasons She Always Plays Witch Roles in Nollywood Movies: "Na That Eye I De… is trending now "Big things are coming": 70 vendors ready for Adedimeji's triplets' celebration is trending now Ex-gang leader faces trial over 1996 Tupac Shakur murder is trending now Aurodig targets data-conscious mobile users with new approach to streaming is trending now Pin Up Casino Kenya: Which Games Kenyans Are Choosing in 2026 is trending now
Organic

Oracle autoupgrade for 12c to 19c upgrade

Download latest autoupgrade.jar Download the latest autoupgrade from MOS you download the most recent version from MOS Note: 2485457.1 – AutoUpgrade Tool: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/autoupgrade-command-line-parameters.html Create the autoupgrade config file Run Autoupgrade in analyze mode Run Autoupgrade in fixups mode Run Autoupgrade in Deploy mode Drop restore point

Download latest autoupgrade.jar

Download the latest autoupgrade from MOS

you download the most recent version from MOS Note: 2485457.1 – AutoUpgrade Tool:

https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/autoupgrade-command-line-parameters.html

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_1
upg1.target_home=/u01/app/oracle/product/19.0.0/dbhome_1
upg1.sid=TEST2
upg1.dbname=TEST2
upg1.target_cdb=CDBTEST2
upg1.target_pdb_name=TEST2
upg1.start_time=now
upg1.log_dir=/home/oracle/autoupgrade
upg1.run_utlrp=yes # Run UTLRP after the upgrade
upg1.timezone_upg=yes
upg1.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 analyze
AutoUpgrade 25.4.250730 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> help given time from command execution
upg> 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 deploy
upg> 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 1
upg> 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 1
upg> lsj
+----+--------+---------+---------+-------+----------+-------+-------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED|MESSAGE|
+----+--------+---------+---------+-------+----------+-------+-------+
| 103|TEST2|DBUPGRADE|EXECUTING|RUNNING| 12:06:18|19s ago|Running|
+----+--------+---------+---------+-------+----------+-------+-------+
Total jobs 1
upg> 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 1
upg> 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 1
upg> 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 1
upg> lsj
+----+--------+-----------+---------+-------+----------+-------+----------+
|Job#| DB_NAME| STAGE|OPERATION| STATUS|START_TIME|UPDATED| MESSAGE|
+----+--------+-----------+---------+-------+----------+-------+----------+
| 103|TEST2|POSTUPGRADE|EXECUTING|RUNNING| 12:06:18| 1s ago|Restarting|
+----+--------+-----------+---------+-------+----------+-------+----------+
Total jobs 1
upg> 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_TEST2122010
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$
[TEST2] oracle@ora004:~/TEST2$

Drop restore point

SQL> select name from v$restore_point;
NAME
--------------------------------------------------------------------------------
GRP_1763508671856
AUTOUPGRADE_9212_TEST2122010
SQL>
View original source →

Related