Oracle Database : Install and Upgrade Workshop

Oracle Database : Install and Upgrade Workshop Certification Training Course Overview

The Oracle Database 12c R2: Install and Upgrade Workshop training course will give you a detailed overview installing Oracle Database 12c Release 2 software, creating a container database and provision pluggable databases.

Who should do Oracle Database 12c R2: Install and Upgrade Workshop training?

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

Oracle Database : Install and Upgrade Workshop (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 850
02 - 03 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Oracle Database 12c R2: Overview
  • Oracle Database Innovation
  • Oracle Database Server Architecture: Overview
  • Process Architecture
  • Database Storage Architecture
  • Oracle Database Memory Structures
  • Objectives
  • Oracle Database Instance Configurations
  • Connecting to the Database Instance
Module 2: Oracle Software Installation Basics
  • Operating System Groups and Users
  • Environment Variables
  • Configuring the Oracle Software Owner Environment
  • Planning Your Installation
  • Using Oracle Universal Installer (OUI)
  • Installation Option: Silent Mode
  • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
Module 3: Installing Oracle Grid Infrastructure for a Standalone Server
  • Post Patch steps using Datapatch
  • Determining the latest patch sets available using Oracle Support
  • Patching Using OPatch
  • Upgrading OPatch
  • Patching Using OPlan
  • Patching Using opatchauto
  • Overview of Patching
  • Types of patches
Module 4: Installing Oracle Database Software
  • Creating Operating System Groups and Users
  • Types of Installations
  • Oracle Database Installation: System Requirements
Module 5: Creating an Oracle Database by Using DBCA
  • Creating a Container Database by Using DBCA
  • Planning the Database
  • Using the DBCA to Create a Database
  • Creating a Database Design Template
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets Are Used
  • Setting the NLS_LANG Initialization Parameter
  • Types of Databases
Module 6: Oracle Restart
  • Controlling Oracle Restart
  • Obtaining Help for the SRVCTL Utility
  • Using the SRVCTL Utility
  • Oracle Restart
  • Oracle Restart Configuration
  • Oracle Restart Process Startup
  • Choosing the Correct SRVCTL Utility
  • Starting Components by Using the SRVCTL Utility
Module 7: Introduction to Upgrading to Oracle Database 12c
  • Upgrade Paths
  • Upgrade Method Limitations
  • Database Upgrade Assistant: Advantages and Disadvantages
  • Upgrading to a New Release of Oracle Database
  • Defining Upgrade and Data Migration
  • Upgrade Methods
  • Manual Upgrade: Advantages and Disadvantages
  • Migration Methods
Module 8: Preparing to Upgrade to Oracle Database 12c
  • Requirements for Databases Using Oracle Label Security or Oracle Database Vault
  • Performance Testing
  • Developing a Test Plan
  • Planning the Upgrade
  • Requirement for Databases Using Oracle Warehouse Builder
  • Using the Pre-Upgrade Information Tool
  • Backing Up the Database
  • Preparing to Upgrade
Module 9: Upgrading to Oracle Database 12c
  • Manually Upgrading to Oracle Database 12c
  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Plugging a Non-CDB Database into a CDB
  • Key DBUA Features
  • Migrating a Pre-12.1 or 12.1 Non-CDB to CDB
Module 10: Performing Post-Upgrade Tasks
  • Understanding Auditing Implementation
  • Recommended Tasks After Database Upgrade
  • Enabling Unified Auditing
  • Required Tasks After Database Upgrade
  • Administering the Roles Required for Auditing
Module 11: Migrating Data by Using Oracle Data Pump
  • Creating a New PDB from PDB$SEED
  • Exporting from a Non-CDB and Importing into a PDB
  • Oracle Data Pump: Overview
  • Importing by Using a Network Link
  • Migrating by Using Oracle Data Pump
  • Creating a Container Database by Using DBCA
  • Data Pump Utility: Interfaces and Modes
  • Data Pump Export and Import Clients: Overview
Download Course Contents

Request More Information

Course Prerequisites
  • Oracle Linux 5 & 6 System Administration Ed 3
  • Oracle Database 12c: Introduction to SQL Ed 1.1
  • Oracle Database 12c: Administration Workshop Ed 2


Following will be helpful but not mandatory

  • Fundamental understanding of Linux operating system & Linux System Administration
  • Basic experience with SQL and use of PL/SQL packages

On completion of this training, you will know:

  • Upgrading database to Oracle Database 12c Release 2
  • Creating a container database
  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Configuring ASMLIB and create ASM disk groups
  • Applying the latest patch set updates to the Grid Infrastructure software
  • Installing Oracle Database 12c Release 2 software
  • Preparing the Linux operating system for Oracle software installation
  • Install Oracle Grid Infrastructure for an Independent Server & Oracle Database 12c software
  • Create an Oracle Database using DBCA