Oracle Database 12c R2: Install and Upgrade Workshop Ed 2

Oracle Database 12c R2: Install and Upgrade Workshop Ed 2 Certification Training Course Overview

Oracle Database 12c: Install and Upgrade Workshop training course teaches you with key information to install Oracle Database 12c software. In this course, students will also learn how to create a container database and provision pluggable databases. Students will be introduced to Oracle Database Cloud Service also during this course.
 
Audience:
  • Administrator
  • Database Administrator

Oracle Database 12c R2: Install and Upgrade Workshop Ed 2 (16 Hours) Download Course Contents

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

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

04 - 05 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 2600
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 Overview
  • Oracle Database 12c 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
Module 2: 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
Module 3: 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
Module 4: 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)
Module 5: 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
Module 6: Introduction to Upgrading to Oracle Database 12c
  • Upgrade Methods
  • Data Migration Methods
  • Supported Releases for Direct Upgrade
  • Overview of Upgrade Process
  • Performing a Rolling Upgrade
  • Performing a Rolling Upgrade
Module 7: Preparing to Upgrade to Oracle Database 12c
  • 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 12c Software
  • Preparing the New Oracle Home
Module 8: Upgrading to Oracle Database 12c
  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Manually Upgrading to Oracle Database 12c
  • Migrating a non-CDB to a CDB
Module 9: Performing Post-Upgrade Tasks
  • Migrating to Unified Auditing
  • Performing Post-Upgrade Tasks Following a Manual Upgrade
Module 10: Migrating Data by Using Oracle Data Pump
  • Data Pump Overview
  • Migrating by Using Data Pump
  • Importing by Using a Network Link
Download Course Contents

Request More Information

Course Prerequisites
  • Basic Computer Knowledge.

After completion of this course; you will be able to:

  • Gain an understanding of the Oracle Database Cloud Service
  • Install Oracle Grid Infrastructure for a Standalone Server
  • Use Oracle Restart to manage components
  • Upgrade database to Oracle Database 12c
  • Create a container database
  • Create an Oracle Database
  • Install Oracle Database 12c software