Course Code: 1179

Oracle Database 12c: Install and Upgrade Workshop

Class Dates:
2 Days
Class Time:


  • 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


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
  • 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
  • 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
  • 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