Oracle Database 12cR2 Install & Upgrade

2 Day Course
Hands On
Code O12CIU

Book Now - 3 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


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

Target Audience

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.

Additional Information

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

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Overview of Oracle Database 12cR2 (6 topics)

  • 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

Install Oracle Grid Infrastructure on a Standalone Server (5 topics)

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

Install the Oracle Database Software (6 topics)

  • 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

Create a Database with the Database Configuration Assistant (DBCA) (7 topics)

  • 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

Oracle Restart (6 topics)

  • 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

Preparation for Upgrade to Oracle Database 12cR2 (12 topics)

  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • Upgrade process overview
  • Rolling upgrade 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

Perform an Upgrade to Oracle Database 12cR2 (5 topics)

  • 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
  • lug in a non CDB database into a CDB

Post Upgrade Tasks (3 topics)

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

Migrate Data with Data Pump (5 topics)

  • 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


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.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Sep Oct Nov Dec Jan Feb
Virtual Classroom (London)
2 Days $1,230
Virtual Classroom (London)
2 Days $1,230

Course PDF


Share this Course


Recommend this Course