Oracle Database 12c: Install and Upgrade Workshop (D77766) – Outline

Detailed Course Outline

Oracle Database 12c R2: Overview
  • Objectives
  • Oracle Database Innovation
  • Oracle Database Server Architecture: Overview
  • Oracle Database Instance Configurations
  • Connecting to the Database Instance
  • Oracle Database Memory Structures
  • Process Architecture
  • Database Storage Architecture
Oracle Software Installation Basics
  • Planning Your Installation
  • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
  • Operating System Groups and Users
  • Environment Variables
  • Configuring the Oracle Software Owner Environment
  • Using Oracle Universal Installer (OUI)
  • Installation Option: Silent Mode
Installing Oracle Grid Infrastructure for a Standalone Server
  • Overview of Patching
  • Types of patches
  • Determining the latest patch sets available using Oracle Support
  • Upgrading OPatch
  • Patching Using OPatch
  • Post Patch steps using Datapatch
  • Patching Using opatchauto
  • Patching Using OPlan
Installing Oracle Database Software
  • Oracle Database Installation: System Requirements
  • Creating Operating System Groups and Users
  • Types of Installations
Creating an Oracle Database by Using DBCA
  • Planning the Database
  • Types of Databases
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets Are Used
  • Setting the NLS_LANG Initialization Parameter
  • Using the DBCA to Create a Database
  • Creating a Container Database by Using DBCA
  • Creating a Database Design Template
Oracle Restart
  • Oracle Restart
  • 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 12c
  • Defining Upgrade and Data Migration
  • Upgrade Methods
  • Database Upgrade Assistant: Advantages and Disadvantages
  • Manual Upgrade: Advantages and Disadvantages
  • Upgrade Paths
  • Upgrade Method Limitations
  • Upgrading to a New Release of Oracle Database
  • Migration Methods
Preparing to Upgrade to Oracle Database 12c
  • Preparing to Upgrade
  • Planning the Upgrade
  • 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
Upgrading to Oracle Database 12c
  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Key DBUA Features
  • Manually Upgrading to Oracle Database 12c
  • Migrating a Pre-12.1 or 12.1 Non-CDB to CDB
  • Plugging a Non-CDB Database into a CDB
Performing Post-Upgrade Tasks
  • Required Tasks After Database Upgrade
  • Recommended Tasks After Database Upgrade
  • Understanding Auditing Implementation
  • Enabling Unified Auditing
  • Administering the Roles Required for Auditing
Migrating Data by Using Oracle Data Pump
  • Oracle Data Pump: Overview
  • Data Pump Export and Import Clients: Overview
  • Data Pump Utility: Interfaces and Modes
  • Migrating by Using Oracle Data Pump
  • Importing by Using a Network Link
  • Creating a Container Database by Using DBCA
  • Creating a New PDB from PDB$SEED
  • Exporting from a Non-CDB and Importing into a PDB