Oracle Database: Deploy, Patch and Upgrade Workshop (D105893) – Outline

Detailed Course Outline

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