Welcome to ONLC Training Centers


Oracle Database 12c: Install and Upgrade Workshop Course Outline

 (2 days)
Version 12c

Overview
This course offers a step-by-step guide for the installation of the optional Oracle 12c grid infrastructure followed by the installation of an Oracle 12c database. The primary focus is the configuration of a Linux host system, with helpful hints for other supported platforms such as Oracle Linux, Unix and MS Windows. This textbook starts with a bare-metal server system and guides one through the process of an operating system installation, operating system configuration and finally the Oracle grid infrastructure and Oracle database installations.

This Course includes practical tips learned from many real-world installations. We include topics about the preparation of disks as Oracle Automatic Storage Management (ASM) candidate devices, troubleshooting installation issues and verifying the validity of an apparently successful installation.

While this course module applies specifically to the installation of the Enterprise Edition of the Oracle database, it covers basic topics that apply to any Oracle software installation. Therefore, this material is also useful for the installation of other Oracle products such as the Oracle Database Client, specialized options for a database server installation, and so on.

Target Audience
The target audience for this textbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:
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
Oracle Database 12c: SQL Fundamentals (Levels I & II)

Certification
This textbook considers subjects helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".

Objectives
Among the specific topics addressed are these:
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.

Course Outline

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
Choosing An Operating System
Proprietary Unix Vs. Open-Source Linux
Making The OS Selection
Prepare An Oracle Linux Installation
Perform Oracle Linux     Installation
Configure The     Linux Host
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
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
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

Grid Infrastructure Installation
Perform The Installation
Download
Unpack The Installation Package
Launch The Installation Session
The Installation Dialog
Verify The Installation
Operating System Confirmation
Oracle Utilities Setup
SQL*Plus Confirmation
Using     EM Cloud Control
Troubleshooting Problems

Database Installation Configuration
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
Examining 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
Develop A Database Upgrade Plan
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
View outline in Word

OIU12C

Attend hands-on, instructor-led Oracle Database 12c: Install and Upgrade Workshop training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $1195

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com