Oracle Database 19c: Deploy, Patch, and Upgrade Workshop

COURSE TOPICS

Module 1: Course Overview

• Oracle Database 19c: Deploy, Patch, and Upgrade Workshop Overview

Module 2: Installation Overview

• Installation Overview
• Compare and Contrast Single Owner Compared to Job Role Separation
• Describe Different Instance to Database Configurations
• Compare and Contrast File System Storage to Oracle ASM

Module 3: Preparing to Install Oracle Software

• Preparing to Install Oracle Software
• Course Practice Environment: Security Credentials
• Practice 2-1: Preparing Oracle Linux for Oracle Grid Infrastructure Installation
• Practice 2-2: Preparing Storage for ASM

Module 4: Installing Oracle Grid Infrastructure for a Stand-Alone Server

• Installing Oracle Grid Infrastructure for a Stand-Alone Server
• Installation Option
• Oracle ASMCA: Home
• Practice 3-1: Installing Oracle Grid Infrastructure
• Practice 3-2: Creating Second Disk Group Using Oracle ASMCA (+FRA)

Module 5: Installing Oracle Database Software

• Installing Oracle Database Software
• Practice 4-1: Installing Oracle Database

Module 6: Creating an Oracle Database Using Oracle DBCA

• Creating an Oracle Database Using Oracle DBCA
• Practice 5-1: Creating an Oracle Database Using Oracle DBCA
• Practice 5-2: Creating an Oracle Database Using Oracle DBCA Silent Mode

Module 7: Patching Oracle Grid Infrastructure and Oracle Database

• Patching Oracle Grid Infrastructure and Oracle Database
• Oracle Patches Maintenance
• Oracle Patching Tools
• Minimizing Downtimes: Rolling Patching
• Practice 6-1: Applying Patch 27006180 with autopatch
• Practice 6-2: Apply Patch 28553832 Using opatch (Manual Patching)
• Practice 6-3: Out-of-Place Patching Grid Infrastructure
• Practice 6-4: Out-of-Place Patching Oracle Database

Module 8: Oracle Restart

• Oracle Restart
• Oracle Restart Configuration & Management
• Server Control Utility (SRVCTL)
• Oracle Restart Maintenance Operations
• Practice 7-1: Starting and Stopping Oracle Restart
• Practice 7-2: Starting and Stopping Components
• Practice 7-3: Managing Configuration of Components

Module 9: Upgrading to Oracle Grid Infrastructure 19c

• Upgrading to Oracle Grid Infrastructure 19c
• Practice 8-1: Prepare Oracle Linux for Oracle Grid Infrastructure Upgrade
• Practice 8-2: Upgrading Oracle Grid Infrastructure to 19c

Module 10: Before Upgrading to Oracle Database 19c

• Before Upgrading to Oracle Database 19c
• Upgrade Methods
• Migration Methods

Module 11: Upgrading to Oracle Database 19c

• Upgrading to Oracle Database 19c
• Installing Oracle Database 19c Software Using OUI
• AutoUpgrade Utility System Check
• Backing Up the Database
• Upgrading Using the AutoUpgrade Utility
• Upgrading Using the Oracle Database Upgrade Assistant (DBUA)
• Manually Upgrading to Oracle Database 19c
• Practice 10-1: Installing Oracle Database 19c Software
• Practice 10-2: Performing Full Database Backup
• Practice 10-3: Using the AutoUpgrade Utility Perform Preupgrade System Checks and Execute the Recommended Fixups Part 1
• Practice 10-3: Using the AutoUpgrade Utility Perform Preupgrade System Checks and Execute the Recommended Fixups Part 2
• Practice 10-3: Using the AutoUpgrade Utility Perform Preupgrade System Checks and Execute the Recommended Fixups Part 3
• Practice 10-4: Upgrading Oracle Database

Module 12: Performing Postupgrade Tasks

• Performing Postupgrade Tasks
• Practice 11-1: Performing Postupgrade Actions Part 1
• Practice 11-1: Performing Postupgrade Actions Part 2

Module 13: Migrating Data Using Oracle Data Pump

• Migrating Data Using Oracle Data Pump
• Practice 12-1: Performing a Full Transportable Export and Import from the Oracle Database 12c Release 2 into an Oracle Database 19c Part 1
• Practice 12-1: Performing a Full Transportable Export and Import from the Oracle Database 12c Release 2 into an Oracle Database 19c Part 2
• Practice 12-1: Performing a Full Transportable Export and Import from the Oracle Database 12c Release 2 into an Oracle Database 19c Part 3