Oracle Database: Deploy, Patch and Upgrade Workshop

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Dec 20, 202109:0005:00ESTToronto - In Class or by Video Conference2$2,700 USDPurchase
Feb 1, 202209:0005:00ESTToronto - In Class or by Video Conference2$2,700 USDPurchase
Apr 11, 202209:0005:00EDTToronto - In Class or by Video Conference2$2,700 USDPurchase
Jun 1, 202211:0007:00EDTToronto - In Class or by Video Conference2$2,700 USDPurchase
Aug 22, 202209:0005:00EDTToronto - In Class or by Video Conference2$2,700 USDPurchase
Oct 24, 202209:0005:00EDTToronto - In Class or by Video Conference2$2,700 USDPurchase
Dec 1, 202211:0007:00ESTToronto - In Class or by Video Conference2$2,700 USDPurchase


Oracle Database: Deploy, Patch and Upgrade Workshop

Description: This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.

Versions Supported: 19c, 18c, 12c

Duration: 2 Days

Learn to:

  • Install Oracle Grid Infrastructure for a Standalone Server.
  • Use Oracle Restart to manage components.
  • Upgrade an existing Oracle Database.
  • Create a container database and provision pluggable databases.
  • Gain an understanding of the Oracle Database Cloud Service.

Course Objectives:

  • Install Oracle Grid Infrastructure for a Standalone Server
  • Configure ASMLIB and create ASM disk groups
  • Apply the latest patch set updates to the Grid Infrastructure software
  • Install Oracle Database software
  • Use Oracle Restart to manage components
  • Prepare the Linux operating system for Oracle software installation
  • Upgrade Oracle Database
  • Create a container database
  • Install Oracle Grid Infrastructure for an Independent Server
  • Create an Oracle Database using DBCA
  • Install the latest patch set updates to the Oracle database software

Audience:

  • Data Warehouse Administrator
  • Database Administrator
  • Database Designer
  • Support Engineer
  • Technical Administrator

Topics:

Oracle Database Overview

  • Oracle Database Introduction
  • Oracle Database Architecture Overview
  • Oracle Database Instance Configurations
  • Oracle Database Memory Structures
  • Process Structures
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Container and Pluggable Database Overview

Installing Oracle Grid Infrastructure for a Standalone Server

  • Overview of Oracle Grid Infrastructure for a Standalone Server
  • System Requirements for Oracle Grid Infrastructure
  • Configuring Storage for Oracle Automatic Storage Management (ASM)
  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Upgrading Oracle Grid Infrastructure for a Standalone Server

Installing Oracle Database Software

  • Planning Your Installation
  • System Requirements for Oracle Database
  • Preparing the Operating System
  • Using 4 KB Sector Disks
  • Setting Environment Variables
  • Checking the System Requirements
  • Using the Oracle Universal Installer (OUI)
  • Performing a Silent Mode Installation

Creating an Oracle Database by Using DBCA

  • Planning the Database Storage Structure
  • Choosing non-CDB or CDB
  • Types of Databases (based on workload)
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets are Used
  • Setting the NLS_LANG Initialization Parameter
  • Using the Database Configuration Assistant (DBCA)

Using Oracle Restart

  • Oracle Restart Overview
  • Oracle Restart Process startup
  • Controlling Oracle Restart
  • Choosing the Correct SRVCTL Utility
  • Oracle Restart Configuration
  • Using the SRVCTL Utility
  • Obtaining Help for the SRVCTL Utility
  • Starting Components by Using the SRVCTL Utility

Introduction to Upgrading to Oracle Database

  • Upgrade Methods
  • Data Migration Methods
  • Supported Releases for Direct Upgrade
  • Overview of Upgrade Process
  • Performing a Rolling Upgrade
  • Upgrading a CBD

Preparing to Upgrade to Oracle Database

Developing a Test Plan

  • Performance Testing
  • Requirements for Databases Using Oracle Label Security or Oracle Database Vault
  • Requirement for Databases Using Oracle Warehouse Builder
  • Using the Pre-Upgrade Information Tool
  • Backing Up the Database
  • Installing the Oracle Database Software
  • Preparing the New Oracle Home

Upgrading to Oracle Database

  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Manually Upgrading to Oracle Database
  • Migrating a non-CDB to a CDB

Performing Post-Upgrade Tasks

  • Migrating to Unified Auditing
  • Performing Post-Upgrade Tasks Following a Manual Upgrade

Migrating Data by Using Oracle Data Pump

  • Data Pump Overview
  • Migrating by Using Data Pump
  • Importing by Using a Network Link
Right Menu IconMENU