In this article, we will see upgrading Oracle Database from 12c Release 1 to 12C Release 2.

Step 1: Check database details

Step 2: Run preupgrade script

Step 3: Run preupgrade_fixups.sql

Step 4: It is giving an error on min_archive_dest_size parameter as It is not having enough free storage available

Step 5: Run DBUA

Step 6: As GUI opens select database you want to upgrade and specify username and password

Step 7: Check if there are warnings or errors as prerequisites check, solve them before proceeding

Step 8: Tick  checkboxes you want to upgrade  and specify scripts if you want it to execute before the upgrade or after upgrade

Step 9: Select recovery option here I have instructed it to create a new full RMAN backup.

Step 10: Select listener you want to migrate to new database home

Step 11: Configure EM options

Step 12: Check upgrade summary and click on next

Step 13: Check upgrade progress.

Step 14: After successful completion of the upgrade close window

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.