Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Aug 22, 2022 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 2 | $2,700 USD | Purchase |
Oct 24, 2022 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 2 | $2,700 USD | Purchase |
Dec 1, 2022 | 11:00 | 07:00 | EST | Toronto - In Class or by Video Conference | 2 | $2,700 USD | Purchase |
Oracle Database: Deploy, Patch and Upgrade Workshop
Description: This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. Expert Oracle instructors will teach you how to create a container database and provision pluggable databases. In this course, you will be introduced to Oracle Database Cloud Service.
Versions Supported: 19c, 18c, 12c
Duration: 2 Days
Learn to:
- Install Oracle Grid Infrastructure for a Standalone Server.
- Use Oracle Restart to manage components.
- Upgrade an existing Oracle Database.
- Create a container database and provision pluggable databases.
- Gain an understanding of the Oracle Database Cloud Service.
Course Objectives:
- Install Oracle Grid Infrastructure for a Standalone Server
- Configure ASMLIB and create ASM disk groups
- Apply the latest patch set updates to the Grid Infrastructure software
- Install Oracle Database software
- Use Oracle Restart to manage components
- Prepare the Linux operating system for Oracle software installation
- Upgrade Oracle Database
- Create a container database
- Install Oracle Grid Infrastructure for an Independent Server
- Create an Oracle Database using DBCA
- Install the latest patch set updates to the Oracle database software
Audience:
- Data Warehouse Administrator
- Database Administrator
- Database Designer
- Support Engineer
- Technical Administrator
Topics:
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