Oracle Database 18c Install & Upgrade

This Oracle Database 18c Install & Upgrade course is designed to give the Oracle database administrator practical experience in installing Oracle Database 18c 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 18c.

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

Versions supported 12cR2, 18c, 19c.

Course Objectives

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

Who will the Course Benefit?

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

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 18c 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

Requirements

Delegates who wish to attend the Oracle Database 18c 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 Linux/UNIX is recommended but is not essential.

Where Oracle 18c courses are listed in the Pre-requisite Courses section equivalent Oracle 12c courses would also suffice.

Pre-Requisite Courses

Oracle Database 12cR2 Administration
Oracle Database 18c Administration

Examinations

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

Oracle Database Administration II: 1Z0-083

Attending this course together with the following courses will help delegates gain many of the skills and product knowledge requirements as outlined in the exam objectives:

Oracle Database 18c Backup and Recovery with RMAN
Oracle Multitenant Administration

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.

• Course content

  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 18c home

  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 18c software

  Session 8: PERFORM AN UPGRADE TO ORACLE DATABASE 18c

  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