HOL 19c Unplug - Plug - Upgrade – Upgrade your Database

« PREVIOUS «

In this part of the Hands-On Lab you will now unplug an Oracle 12.2.0.1 pluggable database (PDB) from CDB1 and plug it into 19c’s CDB2, including all the necessary steps.

Index

1. Preparation work in CDB1
2. Preupgrade.jar and Unplug
3. Plugin
4. Upgrade

1. Preparation work in CDB1

The PDB3 we will use in this part of the lab is created already in CDB1 – but you need to startup CDB1 and PDB3.

. cdb1
sqlplus / as sysdba

startup
show pdbs
exit

2. AutoUpgrade will do it for you

In /home/oracle/scripts you will find a precreated config file for this task:

cat /home/oracle/scripts/PDB3.cfg

It has the following contents:

global.autoupg_log_dir=/home/oracle/logs
upg1.source_home=/u01/app/oracle/product/12.2.0.1
upg1.target_home=/u01/app/oracle/product/19
upg1.sid=CDB1
upg1.pdbs=PDB3
upg1.target_cdb=CDB2
upg1.log_dir=/home/oracle/logs
upg1.target_pdb_copy_option=file_name_convert=('CDB1', 'CDB2')

At first, run the analyze phase with autoupgrade:

java -jar $OH19/rdbms/admin/autoupgrade.jar -mode analyze -config PDB3.cfg

In rare occasions, AutoUpgrade may give you an error that the content of PDB3.cfg has altered after the deploy. Then you need to clear the log information kept by AutoUpgrade:
java -jar $OH19/rdbms/admin/autoupgrade.jar -config PDB3.cfg -clear_recovery_data

You may want to check the HTML output from this analyze run:

firefox /home/oracle/logs/cfgtoollogs/upgrade/auto/status/status.html &

There shouldn’t be any issues. AutoUpgrade will take care on everything.

Now you can initiate the deploy run which will repeat the analyze, then run the fixups, unplug the PDB, plug it in and upgrade it to Oracle 19c.

java -jar $OH19/rdbms/admin/autoupgrade.jar -mode deploy -config PDB3.cfg

Of course, you can monitor the upgrade automatically in your browser as well:

firefox /home/oracle/logs/cfgtoollogs/upgrade/auto/state.html

In your xterm you may receive this output after approximately 10-15 minutes:

upg> Job 102 completed
------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]
Jobs pending                   [0]

Please check the summary report at: 
/home/oracle/logs/cfgtoollogs/upgrade/auto/status/status.html
/home/oracle/logs/cfgtoollogs/upgrade/auto/status/status.log

Done.

If you’d like, you can now try some fallback exercises. For this part of the lab you should restore the initial snapshot again.

Mark the initial snapshot in the VirtualBox Manager with the mouse <click>: