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 DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save