Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 12c: Install & Upgrade Workshop
Oracle Training 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 course 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.


Oracle Training Audience

The target audience for this course is all Oracle professionals. Among the specific groups for whom this course 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
Oracle Training Prerequisites

These are recommended prerequisites for this course:
  • DATA MODELING: LOGICAL DATABASE DESIGN
  • ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II)
Oracle Training Certification

This course considers subjects helpful for certification as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration".


Oracle Training 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 duration

2 Days

Oracle Training 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
  • Enable New Features
  • Source Destination Specific Post-Upgrade Tasks

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved