Tel: 01423 534630 • Email: info@tts-uk.com
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.
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
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.
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
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.
Oracle Database 12cR2 Administration
Oracle Database 18c Administration
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.
Administration and Course Materials
Course Structure and Agenda
Delegate and Trainer Introductions
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
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
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
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
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
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
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
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
Migrate data with Data Pump
Transport a database
Import data using a Data Pump network link