Oracle Database 19c: Deploy, Patch, and Upgrade Workshop
This course helps you learn how to deploy, patch, and upgrade Oracle Grid Infrastructure and Oracle Database software. You learn how to create a container database and provision pluggable databases. Additionally, you get to work on multiple install scenarios as part of the hands-on
STUDENTS WILL LEARN TO
- Prepare a Server for Oracle Database software Installation
- Install Oracle Grid Infrastructure
- Create FRA Disk Group Using Oracle ASMCA
- Install Oracle Database Software
- Create an Oracle Database Using Oracle DBCA
- Patch Oracle Grid Infrastructure and Oracle Database
- Upgrade to Oracle Grid Infrastructure 19c
- Upgrade to Oracle Database 19c
- Perform Postupgrade Tasks for Oracle Database 19c
- Migrate Data by Using Oracle Data Pump

Phone
|
Phone
|
---|---|
Product
|
Oracle
|
Code
|
D1106095GC10
|
Duration
|
2 Days
|
Price (baht)
|
40,000
|
About the course
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
Register for Training
Schedule
Start Date | End Date | Duration (days) | Price | Register | Course | Code | Product |
---|