Oracle Database 12c: Install and Upgrade Workshop
CLASS DATE(s):
Request a Class

COURSE LENGTH: 2 Days

COURSE COST: $1195.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

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 AND PREREQUISITES

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

Recommended:

Data Modeling: Logical Database Design
Oracle Database 12c: SQL Fundamentals (Levels I & II)

PREREQUISITE COURSES  

*Course Cost listed does not include the cost of courseware. Please refer to your Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course to run is subject to a minimum enrollment. Courses maybe run as a virtual instructor led if the minimum enrollment is not met.

COURSE TOPICS:


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