Oracle Database 12c Install and upgrade workshop – Institute of Software Technologies

Oracle Database 12c Install and upgrade workshop

Oracle Database 12c Install and upgrade workshop

This Oracle Database 12c: Install and Upgrade Workshop gives you detailed information to help you install Oracle Database 12c Release 2 software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases.

 Duration: 40 Hours

This Course covers the following:

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 Con­figuration
  • Connecting to the Database Instance

Oracle Software Installation Basics

  • Operating System Groups and Users
  • Environment Variables
  • Confi­guring the Oracle Software Owner Environment
  • Planning Your Installation
  • Using Oracle Universal Installer (OUI)
  • Installation Option: Silent Mode
  • Confi­guring Oracle Linux with Oracle RDBMS Pre-Install RPM

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
  • Installing Oracle Database Software
  • Creating Operating System Groups and Users
  • Types of Installations Oracle Database Installation: System Requirements

 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

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

Using the DEFINE and VERIFY command

  • Upgrade Paths
  • Upgrade Method Limitations
  • Database Upgrade Assistant: Advantages and Disadvantages
  • Upgrading to a New Release of Oracle Database
  • De­ning Upgrade and Data Migration
  • Upgrade Methods
  • Manual Upgrade: Advantages and Disadvantages
  • Migration Methods

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

 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

 Performing Post-Upgrade Tasks

  • Understanding Auditing Implementation
  • Recommended Tasks After Database Upgrade
  • Enabling Uni­ed Auditing
  • Required Tasks After Database Upgrade
  • Administering the Roles Required for Auditing

 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

Suggested Prerequisites:

• Basic knowledge of Linux operating system

• Basic knowledge of Linux System Administration

• Working knowledge of SQL and use of PL/SQL packages

Required Prerequisites:

• Oracle Linux 5 & 6 System Administration

• Oracle Database 12c: Introduction to SQL

• Oracle Database 12c: Administration Workshop

You will learn how to:

• Upgrade database to Oracle Database 12c

• Create a container database

• Install Oracle Grid Infrastructure for a Standalone Server

• Configure ASMLIB and create ASM disk groups

• Apply the latest patch set updates to the Grid Infrastructure software

• Install Oracle Database 12c Release 2 software

• Use Oracle Restart to manage components

• Prepare the Linux operating system for Oracle software installation

• Install Oracle Grid Infrastructure for an Independent Server

• Install Oracle Database 12c software

• Create an Oracle Database using DBCA

• Install the latest patch set updates to the Oracle database software

This course prepares you for the following certifications:
Oracle Certified Associate (OCA) – (Database Admin)

How you will be assessed?

Theory
50%
Practical
50%
Exam
50%

Deadline

7th Feb 2020

Deadline

7th March 2020

Deadline

7th Sept 2020