Oracle Database 12cR2 Install & Upgrade
 
 

Oracle Database 12cR2 Install & Upgrade

Course Code: O12CIU

Duration: 2 days

S8

Oracle Database 12cR2 Install & Upgrade Course Overview

This Oracle Database 12cR2 Install & Upgrade course is designed to give the Oracle database administrator practical experience in installing Oracle Database 12cR2 software. Delegates will learn how to create a container database and provision pluggable databases.

The delegate will learn and acquire skills as follows:

  • Installing Oracle Grid Infrastructure for a standalone server
  • Installing the Oracle Database software
  • Creating a database using the Database Configuration Assistant
  • Using Oracle Restart to manage components
  • Upgrading a database to Oracle Database 12cR2 using the Database Upgrade Assistant
  • Using a container database
  • Provisioning a pluggable database

Who will the Course Benefit?

This Oracle Database 12cR2 Install & Upgrade course is for anyone who needs to install and configure an Oracle 12cR1 or 12cR2 database or upgrade a 12cR1 or earlier database to Oracle 12cR2 database.

Course Objectives

This Oracle Database 12cR2 Install & Upgrade course is designed to give database administrators the knowledge and skills needed to install and configure an Oracle 12c database. The Oracle Database 12c administrator will gain practical experience in upgrading a database to Oracle 12c database.

Examinations

This course will aid the delegate in their preparation for the following exam:

  • Oracle Database 12cR2: Advanced Administration: 1Z0-073

Attending this course will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives. Studying this course and its associated reference materials can form part of the preparation to achieve certification. Experience, practice, self-study and aptitude are also key requirements for exam success.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Requirements

Delegates who wish to attend the Oracle Database 12cR2 Install & Upgrade course should have practical knowledge of administering an Oracle database. They should have attended the Oracle Database 12cR2 Administration course or have a good working knowledge of Oracle administration.

This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.

Pre-Requisite Courses

Follow-On Courses

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.


 

Course Contents

Oracle Database 12cR2 Install & Upgrade Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: OVERVIEW OF ORACLE DATABASE 12cR2

  • Overview of the Oracle Database 12cR2
  • Overview of Oracle Database 12cR2 architecture
  • Oracle Database instance configuration
  • Database storage architecture
  • Database logical and physical structures
  • Overview of container and pluggable database

Session 2: INSTALL ORACLE GRID INFRASTRUCTURE ON A STANDALONE SERVER

  • Overview of Grid Infrastructure for a standalone server
  • System requirements and prerequisites
  • Install Grid Infrastructure for a standalone server
  • Upgrade Grid Infrastructure for a standalone server

Session 3: INSTALL THE ORACLE DATABASE SOFTWARE

  • Plan an installation
  • System requirements and operating system prerequisites
  • Carry out pre-installation checks
  • Set environment variables
  • Install the Oracle Database software with the Oracle Universal Installer
  • Silent mode installation

Session 4: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

  • Selecting a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA
  • Create a database design template

Session 5: ORACLE RESTART

  • Overview of Oracle Restart
  • Configuration of Oracle Restart
  • Control Oracle Restart
  • The srvctl utility
  • Use srvctl help
  • Use the srvctl utility to start and stop and manage components

Oracle Database 12cR2 Install & Upgrade Training Course

Session 6: PREPARATION FOR UPGRADE TO ORACLE DATABASE 12cR2

  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • Upgrade process overview
  • Upgrade a CDB
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information tool
  • Backup the database
  • Install the Oracle Database 12cR2 software
  • Create the new Oracle home

Session 7: PERFORM AN UPGRADE TO ORACLE DATABASE 12cR2

  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Migrate a non-CDB to a CDB
  • Migrate a pre 12.1 or 12.1 non CDB database into a PDB
  • Plug in a non CDB database into a CDB

Session 8: POST UPGRADE TASKS

  • Carry out post upgrade tasks after a manual upgrade
  • Enable Unified Auditing
  • Administer the roles required for unified Auditing

Session 9: MIGRATE DATA WITH DATA PUMP

  • Migrate data with Data Pump
  • Import data using a Data Pump network link
  • Create a Container Database using the DBCA
  • Create a New PDB from PDB$SEED
  • Export from a non-CDB database and Import into a PDB
 

Oracle Database 12cR2 Install & Upgrade

Duration: 2 days

RRP: £895.00 exc. VAT 


Upcoming Scheduled Events
Next 6 months

London
Start Date   Spaces Book
01 Apr 2019   Spaces StayAhead - Course Running Book
 
28 May 2019   Spaces StayAhead - Course Running Book
 
08 Aug 2019   Spaces StayAhead - Course Running Book
 
Virtual Events StayAhead Virtual Courses available You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.
 

Course Reviews

Comprehensive and covered exactly what I needed to know.

Clive - Technology Consultant - Insurance


A great course with lots of practical work. Thanks!

Darren - Outsourcing


Very productive course!

Lee - Oracle DBA Team Leader - Outsourcing


 
 
 
        Home             Let Us Call You
 

 

Course Deliveries

Public Scheduled and Closed
Virtual
UK and Overseas

OUG

Oracle User Group - Membership Benefits

OUG

Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

StayAhead
Flexibility

Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!




Our Course Curriculum

 
 
 
 
 



Our Ratings

Instructor
Quality
 

97.42%

Course
Practical
 

92.55%

Overall
Courseware
 

94.2%

Overall
Course
 

96.41%

+44 (0)20 7600 6116
sales@stayahead.com
Copyright © 2019 StayAhead Training Ltd
Cookies   /   Privacy Policy