HOME
 

Oracle Database 12cR2 Install & Upgrade

StayAhead Training
Course summary
Professional Training
2 days
895 GBP excl. VAT
Professional Training
Course Dates
Online courses
895 GBP
24/08/2022

Online courses
895 GBP
24/10/2022

London
895 GBP
24/08/2022

London
895 GBP
24/10/2022

Course description

Oracle Database 12cR2 Install & Upgrade

This Oracle Database 12cR2 Install & Upgrade course is designed to give the Oracle database administrator practical experience in installing Oracle Database 12cR2 Grid Infrastructure and Database software. Delegates will also learn the various methods that can be used to upgrade an earlier release of the Oracle database software to 12.2. learn how to create a container database and provision pluggable databases.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Versions supported 12cR2, 18c, 19c.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Understand the concepts of Multitenant architecture
  • Installing Oracle Grid Infrastructure for a standalone server
  • Installing the Oracle Database software in interactive mode
  • Installing the Oracle Database software in in silent mode and using response files
  • Creating a database with the Database Configuration Assistant in interactive mode
  • Creating a database with the DBCA in silent mode and using response files
  • Using Oracle Restart to manage software components
  • Preparing for an upgrade
  • Upgrading a database to Oracle Database 12cR2 using the DBUA in interactive and silent modes
  • Upgrading an Oracle database manually
  • Carrying out post-upgrade tasks
  • Transporting a database using Data Pump
  • Importing data using a Data Pump network link
Who will the Course Benefit?

This Oracle Database 12cR2 Install & Upgrade course is for anyone who needs to install and configure an Oracle 12cR2 database or upgrade an 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 12cR2 database. The Oracle Database 12cR2 administrator will gain practical experience in upgrading a database to Oracle 12cR2 database.

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 either the Oracle Database 12cR2 Administration course or the Oracle Database 18c 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
  • Oracle Database 19c Administration
Follow-On Courses
  • Oracle Database 19c Backup and Recovery with RMAN
  • Oracle Database 19c DBA Performance Tuning & Management
  • Oracle Database 19c Data Guard
  • Oracle Database 19c RAC and Grid Infrastructure Administration
  • Oracle Database 12cR2, 18c and 19c New Features for Administrators
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.
Oracle Database 12cR2 Install & Upgrade Training Course

Course Contents - DAY 1

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
  • Oracle Background processes
  • Database storage architecture
  • Database logical and physical structures
  • Overview of container and pluggable database

Session 2: ORACLE DATABASE 12c MULTITENANT ARCHITECTURE

  • Overview of Container and Pluggable databases
  • The benefits of Multitenant Architecture
  • Files in a multitenant database
  • The structure of the root container
  • The structure of a pluggable container
  • CDB_ and DBA_ views

Session 3: INSTALL ORACLE GRID INFRASTRUCTURE ON A STANDALONE SERVER

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

Session 4: INSTALL THE ORACLE DATABASE SOFTWARE

  • Plan an installation
  • System requirements and operating system prerequisites
  • Oracle Flexible Architecture and directory structures
  • Carry out pre-installation tasks and checks
  • Set environment variables
  • Install the Oracle Database software with the Oracle Universal Installer
  • The Oracle Inventory
  • Silent mode installation
  • Use response files
  • Database Software De-install

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

  • Select 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 using a response file with DBCA silent mode
  • Create a Database with DBCA silent mode
  • Delete a database with DBCA silent mode
  • Create a database design template
  • Carry out post database creation tasks
  • Read-Only homes from Oracle 18c

Session 6: MANAGE ORACLE RESTART

  • The Benefits of Grid Infrastructure for a standalone server
  • Overview of using Oracle Restart
  • The ohasd daemon
  • Use commands to manage the Oracle Restart Stack
  • Add components to Oracle Restart
  • Use the srvctl utility to manage, start and stop and manage components
  • Upgrade and patch the 12.2 home
Oracle Database 12cR2 Install & Upgrade Training Course

Course Contents - DAY 2

Session 7: PREPARATION FOR UPGRADE

  • Upgrade process overview
  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • Methods used to perform indirect upgrade
  • The Database Upgrade Assistant
  • Manual upgrade methods
  • Rolling Upgrade for Oracle Grid Infrastructure
  • Create an upgrade test plan
  • Carry out performance testing
  • Prepare to Upgrade a Database
  • Run the Pre-Upgrade Information tool
  • Check for compatibility issues
  • Use the ORAchk Utility
  • Backup the database
  • Create the new Oracle home
  • Install the Oracle Database 12cR2 software

Session 8: PERFORM AN UPGRADE TO ORACLE DATABASE 12cR2

  • Perform an upgrade of an Oracle Database to 12.2.0.n
  • Perform Post upgrade actions
  • Upgrade a database with the DBUA
  • Manually start a failed upgrade
  • Common installation errors
  • Run the DBUA in silent mode
  • Carry out post upgrade tasks
  • Migrate to Unified Auditing
  • Deprecated database features and parameters
  • De-supported database features and parameters

Session 9: MIGRATE DATA WITH DATA PUMP

  • Migrate data with Data Pump
  • Transport a database
  • Import data using a Data Pump network link
Oracle Database 12cR2 Install & Upgrade

This Oracle Database 12cR2 Install & Upgrade course is designed to give the Oracle database administrator practical experience in installing Oracle Database 12cR2 Grid Infrastructure and Database software. Delegates will also learn the various methods that can be used to upgrade an earlier release of the Oracle database software to 12.2. learn how to create a container database and provision pluggable databases.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Versions supported 12cR2, 18c, 19c.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Understand the concepts of Multitenant architecture
  • Installing Oracle Grid Infrastructure for a standalone server
  • Installing the Oracle Database software in interactive mode
  • Installing the Oracle Database software in in silent mode and using response files
  • Creating a database with the Database Configuration Assistant in interactive mode
  • Creating a database with the DBCA in silent mode and using response files
  • Using Oracle Restart to manage software components
  • Preparing for an upgrade
  • Upgrading a database to Oracle Database 12cR2 using the DBUA in interactive and silent modes
  • Upgrading an Oracle database manually
  • Carrying out post-upgrade tasks
  • Transporting a database using Data Pump
  • Importing data using a Data Pump network link
Who will the Course Benefit?

This Oracle Database 12cR2 Install & Upgrade course is for anyone who needs to install and configure an Oracle 12cR2 database or upgrade an 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 12cR2 database. The Oracle Database 12cR2 administrator will gain practical experience in upgrading a database to Oracle 12cR2 database.

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 either the Oracle Database 12cR2 Administration course or the Oracle Database 18c 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
  • Oracle Database 19c Administration
Follow-On Courses
  • Oracle Database 19c Backup and Recovery with RMAN
  • Oracle Database 19c DBA Performance Tuning & Management
  • Oracle Database 19c Data Guard
  • Oracle Database 19c RAC and Grid Infrastructure Administration
  • Oracle Database 12cR2, 18c and 19c New Features for Administrators
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.
Oracle Database 12cR2 Install & Upgrade Training Course

Course Contents - DAY 1

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
  • Oracle Background processes
  • Database storage architecture
  • Database logical and physical structures
  • Overview of container and pluggable database

Session 2: ORACLE DATABASE 12c MULTITENANT ARCHITECTURE

  • Overview of Container and Pluggable databases
  • The benefits of Multitenant Architecture
  • Files in a multitenant database
  • The structure of the root container
  • The structure of a pluggable container
  • CDB_ and DBA_ views

Session 3: INSTALL ORACLE GRID INFRASTRUCTURE ON A STANDALONE SERVER

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

Session 4: INSTALL THE ORACLE DATABASE SOFTWARE

  • Plan an installation
  • System requirements and operating system prerequisites
  • Oracle Flexible Architecture and directory structures
  • Carry out pre-installation tasks and checks
  • Set environment variables
  • Install the Oracle Database software with the Oracle Universal Installer
  • The Oracle Inventory
  • Silent mode installation
  • Use response files
  • Database Software De-install

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

  • Select 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 using a response file with DBCA silent mode
  • Create a Database with DBCA silent mode
  • Delete a database with DBCA silent mode
  • Create a database design template
  • Carry out post database creation tasks
  • Read-Only homes from Oracle 18c

Session 6: MANAGE ORACLE RESTART

  • The Benefits of Grid Infrastructure for a standalone server
  • Overview of using Oracle Restart
  • The ohasd daemon
  • Use commands to manage the Oracle Restart Stack
  • Add components to Oracle Restart
  • Use the srvctl utility to manage, start and stop and manage components
  • Upgrade and patch the 12.2 home
Oracle Database 12cR2 Install & Upgrade Training Course

Course Contents - DAY 2

Session 7: PREPARATION FOR UPGRADE

  • Upgrade process overview
  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • Methods used to perform indirect upgrade
  • The Database Upgrade Assistant
  • Manual upgrade methods
  • Rolling Upgrade for Oracle Grid Infrastructure
  • Create an upgrade test plan
  • Carry out performance testing
  • Prepare to Upgrade a Database
  • Run the Pre-Upgrade Information tool
  • Check for compatibility issues
  • Use the ORAchk Utility
  • Backup the database
  • Create the new Oracle home
  • Install the Oracle Database 12cR2 software

Session 8: PERFORM AN UPGRADE TO ORACLE DATABASE 12cR2

  • Perform an upgrade of an Oracle Database to 12.2.0.n
  • Perform Post upgrade actions
  • Upgrade a database with the DBUA
  • Manually start a failed upgrade
  • Common installation errors
  • Run the DBUA in silent mode
  • Carry out post upgrade tasks
  • Migrate to Unified Auditing
  • Deprecated database features and parameters
  • De-supported database features and parameters

Session 9: MIGRATE DATA WITH DATA PUMP

  • Migrate data with Data Pump
  • Transport a database
  • Import data using a Data Pump network link

Expenses

£895.00

Continuing Studies

Follow on courses: Oracle Database 19c Backup and Recovery with RMAN, Oracle Database 19c DBA Performance Tuning & Management, Oracle Database 19c Data Guard, Oracle Database 19c RAC and Grid Infrastructure Administration, Oracle Database 12cR2, 18c and 19c New Features for Administrators

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

Live Virtual Training with our live Course Instructor is offered for all our courses.  Take the course from the comfort of your office, home or any location of your choice, nationally and internationally.  Public schedule and Closed Company courses.  Flexibility...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Oracle Database 12cR2 Install & Upgrade.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

 Show phone number
www.stayahead.com


Reviews

Average rating 5

Based on 3 reviews.

Clive
Comprehensive and covered exactly what I needed to know.
Darren
Request information

Find out more about this Oracle Database 12cR2 Install & Upgrade course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here