Trending
Smoking could reduce chances of having baby, WHO warns is trending now BREAKING: Plateau Shuts Schools Over Suspected Diphtheria Outbreak is trending now Advanced optical imaging reveals hidden activity in blood immune cells is trending now Rescue satellite gets close to NASA’s doomed telescope, even if it can’t save it is trending now Antarctica gained a record 695 billion tons of ice. Scientists found the surprising reason is trending now Jamie Vardy Joins Burnley On Deal Until End Of Season is trending now 'Disappointed' - Carrick reacts to late Everton draw as Rashford suffers injury blow is trending now Ronald Koeman Jr. becomes the first goalkeeper to score two goals in an Eredivisie match is trending now 'All over the place' - Gary Neville and Jamie Carragher deliver verdicts after Arsenal be… is trending now "My Husband Is a Secure Man": Mo Bimpe Breaks Silence After Backlash Over Video With Jide… is trending now Saida BOJ Reacts to Regina Daniels' Return to Ned Nwoko, Compares Her to Rat in Trap is trending now Influencer Dies of Complications From Penis Enlargement Procedure is trending now Smoking could reduce chances of having baby, WHO warns is trending now BREAKING: Plateau Shuts Schools Over Suspected Diphtheria Outbreak is trending now Advanced optical imaging reveals hidden activity in blood immune cells is trending now Rescue satellite gets close to NASA’s doomed telescope, even if it can’t save it is trending now Antarctica gained a record 695 billion tons of ice. Scientists found the surprising reason is trending now Jamie Vardy Joins Burnley On Deal Until End Of Season is trending now 'Disappointed' - Carrick reacts to late Everton draw as Rashford suffers injury blow is trending now Ronald Koeman Jr. becomes the first goalkeeper to score two goals in an Eredivisie match is trending now 'All over the place' - Gary Neville and Jamie Carragher deliver verdicts after Arsenal be… is trending now "My Husband Is a Secure Man": Mo Bimpe Breaks Silence After Backlash Over Video With Jide… is trending now Saida BOJ Reacts to Regina Daniels' Return to Ned Nwoko, Compares Her to Rat in Trap is trending now Influencer Dies of Complications From Penis Enlargement Procedure 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