Menu

Tel: 01423 534630    Email: info@tts-uk.com

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

Duration: 2 days
Price: £895 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.