Oracle Database 18c Install and Upgrade

Who will the Course Benefit? 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 a 12cR1 or earlier database to Oracle 12cR2 database.

Versions supported 18c, 12c.

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

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

View Course Contents - DAY 1 Oracle Database 18c 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
• 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

View Course Contents - DAY 2

Oracle Database 18c Install & Upgrade Training Course

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

Examinations Examinations

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

• Oracle Database Administration II: 1Z0-083

Oracle Database Administration II: 1Z0-083 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 Database 18c Backup and Recovery with RMAN Oracle Database 18c Backup and Recovery with RMAN

• Oracle 18c Container and Pluggable Database Administration

Oracle 18c Container and Pluggable Database Administration Oracle 18c Container and Pluggable Database 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.

Exams are not included as part of the course. Examinations Examinations

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

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

Oracle Database 12cR2: Advanced Administration: 1Z0-073 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.

Course Contents

View Course Contents - DAY 1

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

View Course Contents - DAY 2

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

Course Contents View Course Contents - DAY 1

...more Oracle Database 18c Install & Upgrade Training Course

Oracle Database 18c Install & Upgrade Training Course Oracle Database 18c Install & Upgrade Training Course

Use the srvctl utility to start and stop and manage components View Course Contents - DAY 2