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 is the first step in preparing for the Oracle Database upgrade?

• Gather statistics for data dictionary objects

• Empty the recycle bin

• Verify Oracle user group membership

• Download Oracle Database 21C

Why is it important to verify that the Oracle user is a member of the Opera group?

• To speed up the upgrade process

• To ensure proper file permissions

• To meet installer requirements

• To enable remote login

During the installation of Oracle Database 21C, what should you do if you receive a warning about the clock source?

• Stop the installation

• Ignore the warning and proceed

• Restart the installation

• Change the clock source

What is the purpose of running the Auto Upgrade utility in analyze mode?

• To install additional software

• To perform the actual upgrade

• To check for potential issues

• To create a backup

Which command is used to list running jobs during the upgrade process?

• status

• tasks

• LSJ

• jobs

What should be done before starting the upgrade process to ensure no application users are connected?

• Stop the database

• Notify users

• Backup the database

• Stop application users from connecting

What is the final step in deploying the upgrade process?

• Create a new listener

• Run the upgrade in deploy mode

• Verify database services

• Delete old configuration files

After the upgrade, what should be verified about the database?

• All users are connected

• It is open for read-write operations

• The old version is still accessible

• The upgrade logs are deleted

What should be done with the Oracle 19C HOME after a successful upgrade?

• Keep it for backup

• Deinstall it

• Ignore it

• Update it to 21C

What is a recommended action after completing the upgrade?

• Take a full backup of the database

• Revert to the previous version

• Install additional software

• Delete all old files