Trending
Neurologists raise the alarm as stroke hits one Nigerian every minute is trending now Drug-resistant gonorrhoea on the rise in Europe, ECDC warns is trending now Frontiers in T1D Cure Call for Consolidated Researchers is trending now WHO urges Africa to expand access to hepatitis care is trending now AI agent helps prepare synchrotron X-ray experimental measurements, paving the way for au… is trending now Colitis Protection Linked to Microbiota Driven Apiin Activity is trending now 1st atmosphere detected on Earth-like, habitable-zone world is trending now Galaxy cluster's magnetic field reconstructed for 1st time with record-breaking astronomy… is trending now FIFA Rankings: Nigeria Drops to 4th in Africa After World Cu is trending now 'Immensely proud' Antonela Roccuzzo tells Lionel Messi he will 'always be the best' in he… is trending now 2026 Ballon d’Or: Voting dates for nominees confirmed as World Cup ends is trending now Kevin Keegan dies aged 75: Former England forward and manager passes away after battle wi… is trending now Neurologists raise the alarm as stroke hits one Nigerian every minute is trending now Drug-resistant gonorrhoea on the rise in Europe, ECDC warns is trending now Frontiers in T1D Cure Call for Consolidated Researchers is trending now WHO urges Africa to expand access to hepatitis care is trending now AI agent helps prepare synchrotron X-ray experimental measurements, paving the way for au… is trending now Colitis Protection Linked to Microbiota Driven Apiin Activity is trending now 1st atmosphere detected on Earth-like, habitable-zone world is trending now Galaxy cluster's magnetic field reconstructed for 1st time with record-breaking astronomy… is trending now FIFA Rankings: Nigeria Drops to 4th in Africa After World Cu is trending now 'Immensely proud' Antonela Roccuzzo tells Lionel Messi he will 'always be the best' in he… is trending now 2026 Ballon d’Or: Voting dates for nominees confirmed as World Cup ends is trending now Kevin Keegan dies aged 75: Former England forward and manager passes away after battle wi… 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