Course Name

Oracle Database: Deploy, Patch and Upgrade Workshop

  • Duration: 2 Day(s)
  • Date: 28 Oct, 2024
  • Price: R19, 500.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

The Oracle Database: Deploy, Patch and Upgrade Workshop course is a comprehensive training program designed to educate learners on the fundamental aspects of Oracle Database deployment, patching, and upgrade.

It provides hands-on experience and expert guidance on managing Oracle Database environments efficiently.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Database Administrators (DBAs)
  • IT Managers overseeing database solutions
  • Systems Administrators responsible for database infrastructure
  • Oracle Technical Consultants
  • Database Architects
  • Data Center Support Engineers
  • Technical Support Staff
  • IT professionals involved in Oracle Database migrations or upgrades
  • Oracle Developers looking to expand their knowledge on database administration tasks

Course Objectives

By the end of this course, you will be able to:

  • Understand the core architectural components of Oracle Database and differentiate between physical and logical structures.
  • Successfully install Oracle Grid Infrastructure for a standalone server and configure ASM for storage.
  • Perform an Oracle Database software installation, including system requirements assessment and silent mode installation.
  • Create an Oracle Database using the Database Configuration Assistant (DBCA), and decide between non-CDB and CDB architectures.
  • Utilize Oracle Restart to manage database components and understand the SRVCTL utility for process control.
  • Explore various database upgrade methods, including direct upgrade and rolling upgrade techniques.
  • Prepare for database upgrades by developing test plans, performing backups, and using pre-upgrade tools.
  • Execute database upgrades using the Database Upgrade Assistant (DBUA) or manual upgrade processes.
  • Complete post-upgrade tasks, including the transition to Unified Auditing.
  • Migrate data efficiently using Oracle Data Pump and network link imports.

Course Content

  • 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
  • Installing Oracle Grid Infrastructure for a Standalone Server
    • 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
  • Installing Oracle Database Software
    • 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
  • Creating an Oracle Database by Using DBCA
    • 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)
  • Using Oracle Restart
    • 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
  • Introduction to Upgrading to Oracle Database
    • Upgrade Methods
    • Data Migration Methods
    • Supported Releases for Direct Upgrade
    • Overview of Upgrade Process
    • Performing a Rolling Upgrade
    • Upgrading a CBD
  • Preparing to Upgrade to Oracle Database
    • 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 to Oracle Database
    • Upgrading by Using the Database Upgrade Assistant (DBUA)
    • Manually Upgrading to Oracle Database
    • Migrating a non-CDB to a CDB
  • Performing Post-Upgrade Tasks
    • Migrating to Unified Auditing
    • Performing Post-Upgrade Tasks Following a Manual Upgrade
  • Migrating Data by Using Oracle Data Pump
    • Data Pump Overview
    • Migrating by Using Data Pump
    • Importing by Using a Network Link
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

The Oracle Database: Deploy, Patch and Upgrade Workshop course is a comprehensive training program designed to educate learners on the fundamental aspects of Oracle Database deployment, patching, and upgrade.

It provides hands-on experience and expert guidance on managing Oracle Database environments efficiently.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

  • Database Administrators (DBAs)
  • IT Managers overseeing database solutions
  • Systems Administrators responsible for database infrastructure
  • Oracle Technical Consultants
  • Database Architects
  • Data Center Support Engineers
  • Technical Support Staff
  • IT professionals involved in Oracle Database migrations or upgrades
  • Oracle Developers looking to expand their knowledge on database administration tasks

Course Objectives

By the end of this course, you will be able to:

  • Understand the core architectural components of Oracle Database and differentiate between physical and logical structures.
  • Successfully install Oracle Grid Infrastructure for a standalone server and configure ASM for storage.
  • Perform an Oracle Database software installation, including system requirements assessment and silent mode installation.
  • Create an Oracle Database using the Database Configuration Assistant (DBCA), and decide between non-CDB and CDB architectures.
  • Utilize Oracle Restart to manage database components and understand the SRVCTL utility for process control.
  • Explore various database upgrade methods, including direct upgrade and rolling upgrade techniques.
  • Prepare for database upgrades by developing test plans, performing backups, and using pre-upgrade tools.
  • Execute database upgrades using the Database Upgrade Assistant (DBUA) or manual upgrade processes.
  • Complete post-upgrade tasks, including the transition to Unified Auditing.
  • Migrate data efficiently using Oracle Data Pump and network link imports.

Course Content

  • 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
  • Installing Oracle Grid Infrastructure for a Standalone Server
    • 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
  • Installing Oracle Database Software
    • 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
  • Creating an Oracle Database by Using DBCA
    • 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)
  • Using Oracle Restart
    • 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
  • Introduction to Upgrading to Oracle Database
    • Upgrade Methods
    • Data Migration Methods
    • Supported Releases for Direct Upgrade
    • Overview of Upgrade Process
    • Performing a Rolling Upgrade
    • Upgrading a CBD
  • Preparing to Upgrade to Oracle Database
    • 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 to Oracle Database
    • Upgrading by Using the Database Upgrade Assistant (DBUA)
    • Manually Upgrading to Oracle Database
    • Migrating a non-CDB to a CDB
  • Performing Post-Upgrade Tasks
    • Migrating to Unified Auditing
    • Performing Post-Upgrade Tasks Following a Manual Upgrade
  • Migrating Data by Using Oracle Data Pump
    • Data Pump Overview
    • Migrating by Using Data Pump
    • Importing by Using a Network Link

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US