Oracle Database Administration from Zero to Hero - Practice - Applying RU Patches on Oracle Restart

This video tutorial covers the process of applying patches to Oracle databases using the O Patch O2 utility. It begins with an introduction to Oracle patching, focusing on Oracle Restart configuration. The tutorial then details the steps to upgrade the O Batch utility in both Oracle database and grid homes. Following this, the process of applying Release Update 16 is explained, including downloading, staging, and verifying the patches. The tutorial concludes with a summary of the key learnings, emphasizing the streamlined process of using the O Patch O2 utility for patch application.

What is the primary tool used to apply patches on Oracle Restart configuration?

• Database Patch Tool

• Oracle Patch Manager

• Grid Control Utility

• O Patch O2 utility

Which user is required to invoke the O Patch O2 utility?

• Database user

• Root user

• Grid user

• Oracle user

What is the first step in upgrading the O batch utility?

• Verify the current version

• Remove the O batch directory

• Unzip the upgrade patch

• Contact Oracle support

What should you do if the O batch upgrade command fails?

• Reboot the system

• Ignore the error

• Contact Oracle support

• Retry the command

How many patches are included in the RU 16 for the grid and database homes?

• Three

• Four

• Six

• Five

What is the purpose of creating a staging directory during the patching process?

• To store backup files

• To save the batch file

• To run test scripts

• To monitor patch progress

What switch is used to check for conflicts with interim patches?

• Minus interim

• Minus check

• Minus analyzer

• Minus conflict

What happens to the database during the application of the RU patch?

• It is manually shut down

• It is backed up

• It remains active

• It is automatically shut down and restarted

Which query is used to verify the patches applied on the database?

• Holiwga query

• Database status query

• RU verification query

• Patch check query

What should you do with the VM after completing the practice?

• Delete it

• Reboot it

• Keep it for future practice

• Archive it