Oracle Database Administration from Zero to Hero - Practice - Upgrading Oracle Database

This video tutorial guides viewers through upgrading an Oracle CDB database from version 19C to 21C. It covers preparation steps, installation of Oracle 21C, and the use of the Auto Upgrade utility. The tutorial also details post-upgrade actions and final steps, emphasizing the importance of manual checks and adjustments. Key tasks include setting up the Oracle environment, running the upgrade utility, and verifying the upgrade's success. The video concludes with recommendations for maintaining the upgraded system and reverting to the previous version if needed.

What are the preparation steps required before upgrading the database in SRV One?

What should you verify about the Oracle user before starting the upgrade?

What is the significance of gathering statistics for the data dictionary objects before the upgrade?

Describe the process of creating the upgrade configuration file using the Auto Upgrade utility.

What steps should be taken to ensure the database is ready for operations after the upgrade?

Explain the importance of monitoring the upgrade process using commands like LSJ and tasks.

What actions should be taken after the upgrade process is completed?

What should be done if the compatible parameter is not updated to the latest release number after the upgrade?

What is the recommended action regarding the 19 C Oracle HOME after a successful upgrade?

How does the Auto Upgrade utility assist in the upgrade process?