Oracle Database : Install and Upgrade Workshop 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

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

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
  • 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
  • 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
  • Creating Operating System Groups and Users
  • Types of Installations
  • Oracle Database Installation: System Requirements
  • 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
  • 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
  • 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
  • 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
  • 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
  • Understanding Auditing Implementation
  • Recommended Tasks After Database Upgrade
  • Enabling Unified Auditing
  • Required Tasks After Database Upgrade
  • Administering the Roles Required for Auditing
  • 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
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training Incl. Official Courseware
06 - 07 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too fast, we can offer Comfort Track for 32 hours

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
     

Request More Information

Add Name and Email Address of participant (If different from you)