Oracle Database : Install and Upgrade Workshop

Duration : 2 Days (16 Hours)

Oracle Database : Install and Upgrade Workshop Course Overview:

The Oracle Database Install and Upgrade Workshop course is a hands-on learning experience that provides an introduction to Oracle Database installation, configuration, and upgrades. The course is designed for database administrators, system administrators, managers, engineers, and database professionals who want to quickly learn and practice database installation and upgrades.
In this course, participants will install, configure, and upgrade Oracle Database 12c and 19c on Linux. They will explore the Oracle Universal Installer (OUI), Database Configuration Assistants (DBCA), Oracle Cloud Infrastructure, and Database Upgrade Assistants (DBUA). Participants will also learn how to use the Oracle Database Upgrade Guide and Oracle Database Error Messages for troubleshooting.
At the end of the course, participants will be able to install, configure, and upgrade an Oracle Database – both in a test environment and in a production environment. They will also gain skill in troubleshooting database installation problems, configuring databases to meet specific requirements, and managing data updates and upgrades.

Intended Audience:

  1. Database Administrators who manage, maintain, and support Oracle databases.
  2. IT professionals and system architects responsible for planning, acquiring, and configuring databases, ensuring compliance with best practices.
  3. Developers who develop applications that use Oracle databases.
  4. Junior to senior level technical personnel seeking to improve their proficiency in database installation and upgrades.
  5. Individuals who want to gain a comprehensive understanding of Oracle Database concepts and architecture.
  6. Those involved in Oracle database installation, upgrade, or migration projects.

Learning Objectives of Oracle Database : Install and Upgrade Workshop:

1. Understand core concepts related to installing and upgrading an Oracle database.
2. Become familiar with the tools and techniques used to install and upgrade the Oracle database.
3. Learn how to create and configure an instance.
4. Master how to perform a manual upgrade of the Oracle database.
5. Acquire the skills to install and configure Oracle Real Application Clusters (RAC).
6. Understand the steps involved in creating a database in Oracle Grid Infrastructure.
7. Develop skills for troubleshooting installation and upgrade problems.
8. Learn how to migrate an enterprise database from another platform to Oracle.
9. Acquire the techniques to migrate an existing Oracle database to a newer version.
10. Explore best practices for managing and patching your Oracle databases.

 Module 1: Oracle Database 12c R2: Overview
  • Oracle Database Innovation
  • Oracle Database Server Architecture: Overview
  • Process Architecture
  • Database Storage Architecture
  • Oracle Database Memory Structures
  • Objectives
  • Oracle Database Instance Configurations
  • Connecting to the Database Instance
  • Operating System Groups and Users
  • Environment Variables
  • Configuring the Oracle Software Owner Environment
  • Planning Your Installation
  • Using Oracle Universal Installer (OUI)
  • Installation Option: Silent Mode
  • Configuring Oracle Linux with Oracle RDBMS Pre-Install RPM
  • Post Patch steps using Datapatch
  • Determining the latest patch sets available using Oracle Support
  • Patching Using OPatch
  • Upgrading OPatch
  • Patching Using OPlan
  • Patching Using opatchauto
  • Overview of Patching
  • Types of patches
  • Creating Operating System Groups and Users
  • Types of Installations
  • Oracle Database Installation: System Requirements
  • Creating a Container Database by Using DBCA
  • Planning the Database
  • Using the DBCA to Create a Database
  • Creating a Database Design Template
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets Are Used
  • Setting the NLS_LANG Initialization Parameter
  • Types of Databases
  • Controlling Oracle Restart
  • Obtaining Help for the SRVCTL Utility
  • Using the SRVCTL Utility
  • Oracle Restart
  • Oracle Restart Configuration
  • Oracle Restart Process Startup
  • Choosing the Correct SRVCTL Utility
  • Starting Components by Using the SRVCTL Utility
  • Upgrade Paths
  • Upgrade Method Limitations
  • Database Upgrade Assistant: Advantages and Disadvantages
  • Upgrading to a New Release of Oracle Database
  • Defining Upgrade and Data Migration
  • Upgrade Methods
  • Manual Upgrade: Advantages and Disadvantages
  • Migration Methods
  • Requirements for Databases Using Oracle Label Security or Oracle Database Vault
  • Performance Testing
  • Developing a Test Plan
  • Planning the Upgrade
  • Requirement for Databases Using Oracle Warehouse Builder
  • Using the Pre-Upgrade Information Tool
  • Backing Up the Database
  • Preparing to Upgrade
  • Manually Upgrading to Oracle Database 12c
  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Plugging a Non-CDB Database into a CDB
  • Key DBUA Features
  • Migrating a Pre-12.1 or 12.1 Non-CDB to CDB
  • Understanding Auditing Implementation
  • Recommended Tasks After Database Upgrade
  • Enabling Unified Auditing
  • Required Tasks After Database Upgrade
  • Administering the Roles Required for Auditing
  • Creating a New PDB from PDB$SEED
  • Exporting from a Non-CDB and Importing into a PDB
  • Oracle Data Pump: Overview
  • Importing by Using a Network Link
  • Migrating by Using Oracle Data Pump
  • Creating a Container Database by Using DBCA
  • Data Pump Utility: Interfaces and Modes
  • Data Pump Export and Import Clients: Overview

Oracle Database : Install and Upgrade Workshop Course Prerequisites:

1. Fundamentals of Oracle Database Software Installation
2. Knowledge of the Operating System Environment
3. Knowledge of the Storage and Virtualization Technologies
4. Working knowledge of Oracle Database Architecture
5. Familiarity with the Different Types of Oracle Software
6. Understanding of the Oracle Networking Infrastructure
7. Working knowledge of Oracle Database Security
8. Working knowledge of Oracle Database Features and Facilities
9. Understanding of Oracle Database Backup and Recovery
10. Familiarity with Oracle Database Tuning & Troubleshooting

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.