Oracle Database: Deploy, Patch and Upgrade Workshop Ed 1

Duration : 2 Days (16 Hours)

Oracle Database: Deploy, Patch and Upgrade Workshop Ed 1 Course Overview:

The Oracle Database: Deploy, Patch, and Upgrade Workshop Ed 1 course is a comprehensive one-day training program that focuses on the practical aspects of managing Oracle databases. It covers fundamental topics related to Oracle database support and maintenance, with a particular emphasis on deploying and rolling out databases. Participants also gain familiarity with the database patching and upgrade processes, along with best practices for each of these tasks.

The course is designed with a combination of lectures, hands-on activities, demonstrations, and self-assessments to provide a well-rounded learning experience. In the practical skills section, participants have the opportunity to gain hands-on experience in various database tasks, including patching, upgrading, patch set upgrades, and database cloning.

Throughout the course, students learn how to extend the database life cycle, troubleshoot issues, and ensure high database availability. By the end of the training, participants should have a strong understanding of database patching, database upgrades, and the database versioning process, empowering them with valuable skills to manage Oracle databases effectively.

Intended Audience:

  • Database Administrators and Architects
  • IT Professionals for Oracle database upgrades
  • IT Professionals with technical expertise in Oracle databases
  • System Architects and System Administrators
  • Younger IT Professionals seeking to learn Oracle database installation fundamentals.

Learning Objectives of Oracle Database: Deploy, Patch and Upgrade Workshop Ed 1:

1. Learn the essential skills to install, configure, and patch Oracle Database 12c.
2. Understand the importance of staying up to date with regular patching and upgrading.
3. Develop an understanding of Oracle Database architecture and how to deploy various components.
4. Explore strategies to protect your data, develop additional configuration options and protect your system from malicious users.
5. Learn how to apply patches and upgrade to the latest version of the Oracle Database.
6. Gain practical experience with hands-on labs and complete a series of assignments to assess your understanding.

 Module 1: Oracle Database Overview
  • Oracle Database Introduction
  • Oracle Database Architecture Overview
  • Oracle Database Instance Configurations
  • Oracle Database Memory Structures
  • Process Structures
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Container and Pluggable Database Overview
  • Overview of Oracle Grid Infrastructure for a Standalone Server
  • System Requirements for Oracle Grid Infrastructure
  • Configuring Storage for Oracle Automatic Storage Management (ASM)
  • Installing Oracle Grid Infrastructure for a Standalone Server
  • Upgrading Oracle Grid Infrastructure for a Standalone Server
  • Planning Your Installation
  • System Requirements for Oracle Database
  • Preparing the Operating System
  • Using 4 KB Sector Disks
  • Setting Environment Variables
  • Checking the System Requirements
  • Using the Oracle Universal Installer (OUI)
  • Performing a Silent Mode Installation
  • Planning the Database Storage Structure
  • Choosing non-CDB or CDB
  • Types of Databases (based on workload)
  • Choosing the Appropriate Character Set
  • Understanding How Character Sets are Used
  • Setting the NLS_LANG Initialization Parameter
  • Using the Database Configuration Assistant (DBCA)
  • Oracle Restart Overview
  • Oracle Restart Process startup
  • Controlling Oracle Restart
  • Choosing the Correct SRVCTL Utility
  • Oracle Restart Configuration
  • Using the SRVCTL Utility
  • Obtaining Help for the SRVCTL Utility
  • Starting Components by Using the SRVCTL Utility
  • Upgrade Methods
  • Data Migration Methods
  • Supported Releases for Direct Upgrade
  • Overview of Upgrade Process
  • Performing a Rolling Upgrade
  • Upgrading a CBD
  • Developing a Test Plan
  • Performance Testing
  • Requirements for Databases Using Oracle Label Security or Oracle Database Vault
  • Requirement for Databases Using Oracle Warehouse Builder
  • Using the Pre-Upgrade Information Tool
  • Backing Up the Database
  • Installing the Oracle Database Software
  • Preparing the New Oracle Home
  • Upgrading by Using the Database Upgrade Assistant (DBUA)
  • Manually Upgrading to Oracle Database
  • Migrating a non-CDB to a CDB
  • Migrating to Unified Auditing
  • Migrating to Unified Auditing
  • Data Pump Overview
  • Migrating by Using Data Pump
  • Importing by Using a Network Link

Oracle Database: Deploy, Patch and Upgrade Workshop Ed 1 Course Prerequisites:

• A working understanding of basic Windows and Linux operating system administration.
• A working understanding of basic database concepts, such as SQL and PL/SQL.
• A working knowledge of how to install and configure any Oracle database.
• Experience with either Oracle Database 11g Release 2 or Oracle Database 12c Release 1 or 2.
• Experience with Oracle Grid Infrastructure and Oracle Database software.
• Working knowledge of Oracle Enterprise Manager Cloud Control 12c.
• Working knowledge of Oracle Database configuration assistant (DBCA).

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.