Course Code: 1179

Oracle Database 12c: Install and Upgrade Workshop

Class Dates:
5/20/2019
8/5/2019
Length:
2 Days
Cost:
$1195.00
Class Time:
Technology:
Oracle,Server
Delivery:

Overview

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

    Learn To:
    - Install Oracle Grid Infrastructure for a Standalone Server.
    - Use Oracle Restart to manage components.
    - Upgrade an existing Oracle Database to Oracle Database 12c.
    - Create a container database and provision pluggable databases.

  • Audience
  • Database administrators
    Application designers and developers
    Web server administrators
    System administrators
    Implementation specialists
    Data center support engineers
    Chief Information Officers (CIO) and other information technology (IT) management professionals

Prerequisites

Course Details

  • Objectives
  • Configuration of a host system for installation of the optional grid infrastructure and performing such an installation.
  • Configuration of a host system for installation of the Oracle 12c Enterprise Edition of the database and performing such an installation.
  • Using the Oracle Restart framework and integrating Oracle ASM, the Oracle 12c RDBMS, the Oracle Listener and ASM disk groups into the framework.
  • Troubleshooting tips to address installation and configuration issues on various platforms.
  • Recommendations for an optimal host system configuration.
  • Using Oracle ASM storage as an alternative to the file system
  • Using the Database Configuration Assistant (DBCA) to create and manage database instances.
  • Developing a database upgrade plan and performing an upgrade to the Oracle 12c database.
  • Oracle Database Architecture Overview
  • The Database Instance
  • Database Memory Structures
  • Database Process Structures
  • Database Storage Architecture
  • Oracle CLUSTERWARE
  • Configuring The Host For Standalone Installation
  • Host Configuration Overview
  • Choosing A Database Host and An Operating System
  • Proprietary Unix Vs. Open-Source Linux
  • Making The OS Selection
  • Prepare An Oracle Linux Installation and Perform Oracle Linux Installation
  • Step 1 – Confirm General System Requirements
  • Step 2 – Confirm The Operating System Platform
  • Step 3 – Confirm Linux Package Requirements
  • Step 4 – Confirm Network Configuration
  • Configure Host For Virtualization,
  • VM Technologies
  • Configure Oracle Linux For Virtualization
  • Configuring The Host For Standalone Installation continue
  • Step 1 – Download Linux Updates
  • Step 2 – Check Linux Kernel
  • Step 3 – Download Latest yum Configuration File
  • Step 4 – Enable Oracle Linux Add-ons
  • Step 5 - Install VirtualBox
  • Oracle Optimal Flexible Architecture
  • OFA Goals
  • ORACLE_BASE
  • ORACLE_HOME
  • Database Files
  • Multiple ORACLE_HOMEs
  • Database Software Upgrades and Multiple Oracle Software Installations
  • Grid Infrastructure Configuration
  • Configure The Linux Installation
  • About ASM Devices
  • Configure Linux Devices For ASM
  • Partitioning A Device
  • Oracle ASMLib
  • Configure MS Windows Devices
  • Perform The Installation, Download
  • Unpack The Installation Package and Launch The Installation Session
  • The Installation Dialog and Verify The Installation
  • Operating System Confirmation
  • Oracle Utilities Setup, SQL*Plus Confirmation, Using EM Cloud Control
  • Troubleshooting Problems
  • Database Installation Configuration continued
  • Configure A Linux Installation
  • System Groups & Users
  • Configure Kernel Parameters
  • Create The Physical Directories
  • Configure MS Windows Installation
  • Prerequisite CHECKS & FIXUP Utility
  • Database Installation
  • About The Installation , The Installation Tools
  • About The Installation Dialog, The Installation Session Log
  • Perform Installation On Linux , Download, Unpack The Installation Files
  • Set Environment Variables, Launch The Installation
  • Server Class Installation Dialog , More About The Global Database Name
  • About Enterprise Manager Cloud Control , Secure The New Database
  • Perform Installation On Windows, Launch The Installation
  • Post-Installation Configuration, Required Environment Variables
  • Defining The Environment Variables, About SSH
  • Verify The Installation, SQL*Plus Confirmation, Operating System Confirmation
  • Firewall Configuration
  • Accessing EM Database Express
  • Creating Databases Using Dbca
  • About DBCA
  • DBCA Templates
  • Are You Sure?
  • Default Configuration Database
  • Advanced Mode Database
  • File Location Variables
  • Database Vault and Label Security
  • Configure An Existing Database
  • Delete A Database
  • Manage Templates
  • Manually Create A Database
  • The CREATE DATABASE Command
  • Using Oracle RESTART
  • What Is Oracle RESTART?
  • What Oracle Restart Does
  • Is Oracle Restart Deprecated?
  • Registering With Oracle Restart
  • More About srvctl, Terminal Session Configuration
  • Component Status Using SRVCTL, Database Status
  • Grid Infrastructure Status, Oracle Home Status
  • Configuration Using SRVCTL, Examining A Database Configuration
  • Examining The Listener Configuration and The ASM Configuration
  • Manual Registration, Listener Configuration Modification
  • Database Configuration Modification, STARTUP/SHUTDOWN Using SRVCTL
  • Why Use SRVCTL?, Managing Oracle Restart, Obtaining Oracle Restart Status, Start/Stop Oracle Restart
  • Preparing For A Database Upgrade
  • What Is A Database Upgrade?
  • Database Upgrade Methods, Real World Database Upgrade
  • About The Database Version, Direct Upgrade
  • The COMPATIBLE Database Parameter
  • PRE-UPGRADE Preparations, Oracle Warehouse Builder
  • Oracle Label Security (OLS)
  • Oracle Database Vault
  • Locating The Older Database Installations
  • The PRE-UPGRADE Information Tool
  • Pre-Upgrade Information Tool Files
  • Run The Pre-Upgrade Information Tool
  • Examining The Pre-Upgrade Information Tool Results
  • Upgrade To Oracle Database 12C
  • Launch DBUA
  • Database Upgrade Dialog
  • Post-Upgrade Tasks
  • Post-Upgrade Checklist
  • Enable Unified Auditing
  • Migrate To Unified Auditing
  • Database Parameter Changes
  • Enable New Features
  • Source Destination Specific Post-Upgrade Tasks