Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure

Course Details
Code: D105579GC10
Tuition (USD): $1,544.00 • Virtual (2 days)
$1,628.00 • Classroom (2 days)

Oracle Database Cloud Service offers autonomous and user-managed Oracle Database solutions. User-managed solutions are Bare Metal, Virtual Machine, and Exadata DB systems that you can customize with the resources and settings that meet your needs.

This training is your first step in getting started with Virtual Machine and Bare Metal DB Systems. You also get to learn the essential skills required for a DBA to create and manage Oracle Cloud Infrastructure resources such as network and storage.

This course is ideal for DBAs and Data Management Professionals who are looking to enhance their cloud database administration skills. Taking this hands-on training will prepare DBAs for Cloud DBA certification exams.

Learn To:

  • Describe Oracle Cloud Platform for Database in the Cloud
  • Understand key terms such as Regions, Availability Domains, VCN, Shapes
  • Identify the features of Virtual Machine (VM) DB Systems
  • Identify the features of Bare Metal (BM) DB Systems
  • Create Virtual Cloud Network (VCN) for DB System
  • Describe the steps involved in creating and managing VM & BM DB Systems
  • Connect to a DB System on OCI
  • Update, Configure, and Patch DB Systems
  • Monitor a Database on OCI
  • Backup and Recover a Database on OCI
  • Identify OCI Security Features
  • Identify the process involved in migrating a database to OCI

Skills Gained

  • Describe what Oracle Cloud Platform has to offer for database deployments in the cloud
  • Identify the building blocks of Oracle Cloud Infrastructure (OCI)
  • Describe the essentials of Oracle Cloud Infrastructure
  • Get familiar with OCI terminology such as tenant
  • region
  • availability domain
  • shapes
  • Describe the steps involved in launching Bare Metal and Virtual Machine DB Systems
  • Create and manage a Virtual Machine (VM) DB System
  • Describe the administrative tasks involved in managing a VM DB System
  • Explain how security in implemented in each layer of Oracle Cloud Infrastructure
  • Describe what you can do to secure your DB system
  • Get an overview of migrating database to Oracle Cloud Infrastructure

Prerequisites

  • General understanding of Oracle Cloud technology
  • Experience in Oracle Database 11g and/or 12c Administration

Course Details

Course Overview

  • Course Objectives
  • Target Audience
  • Prerequisites
  • Course Roadmap
  • Course Practices

Oracle Cloud Platform for Database in the Cloud

  • Oracle Database Cloud Services
  • Oracle Cloud Infrastructure (OCI): Specifically Architected for Oracle Databases
  • OCI Security Features: Overview for Database Service
  • Journey to Autonomous Database
  • Autonomous or User Managed
  • Subscribe to an Oracle Cloud Service
  • Universal Credits
  • Bring Your Own License

Getting Started with Oracle Cloud Infrastructure

  • Regions, Availability Domains, and Backbone Network
  • Inside a Region – High Availability Building Blocks
  • Inside an AD – High Scale, High Performance Network
  • Comprehensive Virtual Network with Off-box Virtualization
  • Oracle Cloud Infrastructure – Innovation at Its Core
  • Oracle Cloud Infrastructure Services
  • Key Differentiators

Oracle Cloud Infrastructure Essentials

  • Virtual Cloud Network (VCN) Service
  • OCI VPN: Overview
  • Compute Service: Bare Metal and Virtual Machines
  • Available Shapes: Processor and Memory Resources
  • Local NVMe SSD Devices
  • Object Storage Service and Block Volume Service
  • Load Balancing Service
  • DNS Service

Oracle Cloud Infrastructure: Database Service

  • Database Service: Use Cases
  • Virtual Machine DB Systems VM DB Systems Storage Architecture
  • Bare Metal DB Systems BM DB Systems Storage Architecture
  • Exadata DB Systems Storage Architecture
  • Scaling Exadata DB Systems
  • Database Editions, Versions, and Options
  • DB Systems: Managing, Patching, Automatic backups, Backup / Restore
  • High Availability and Scalability

Bare Metal and Virtual Machine DB Systems

  • Compute: Bare Metal and Virtual Machines
  • Database Editions, Versions, and Options
  • Shapes for Virtual Machine Bare Metal DB Systems
  • Storage Options for Virtual Machine Bare Metal DB Systems
  • Virtual Machine DB Systems Storage Architecture
  • Bare Metal DB Systems Storage Architecture

Creating and Managing Bare Metal and Virtual Machine DB Systems

  • Managing the Database Systems Overview
  • Prerequisites to Launch DB System
  • Creating Virtual Cloud Network (VCN) for DB System
  • Using the Console to Launch DB System
  • Using Console to Check the Status of DB System
  • Using Console to Start, Stop, Reboot, and Terminate DB System
  • Using the Console to Manage BYOL Database Licenses
  • Using the API Operations Setting Up DNS for a DB System

Connecting to a DB System on OCI

  • Create TNS Entry for PDBs
  • Prerequisites for SSH Access to the DB System
  • Connecting to a DB System with SSH
  • Connecting to a Database with Oracle SQL Developer
  • Connecting to a Database on 1-Node Multi-Node DB System
  • Troubleshooting Connection Issues

Updating and Configuring a DB System on OCI

  • Update a DB System
  • Bash Profile Essential Firewall Rules
  • Important Guidelines for OS Updates
  • Configure a DB System
  • Network Time Protocol (NTP)
  • Transparent Data Encryption
  • Scaling CPU Storage

Patching a DB System on OCI

  • Patching Prerequisites Patching DB Systems
  • Performing Patch Operations on DB System on Database Using Console
  • Viewing Patch History of a DB System of a Database
  • Performing Patching Using CLI
  • Check the Installed Patches Patch Server Components
  • Patch Database Home Components
  • Applying Interim Patches
  • Identify the Root Cause of the Patching Operation Failure

Configuring and Monitoring a Database on OCI

  • Monitoring a Database
  • Connect to EM Express Console
  • Connect to EM Database Control Console
  • Opening Ports on the DB System
  • Updating the Security List for the DB System
  • Update an Existing Security List
  • Special Considerations to Create and Configure a New PDB
  • Creating and Activating a Master Encryption Key for a New PDB

Backing Up and Recovering a Database on OCI

  • Object Storage, Local Storage Swift Object Storage
  • Backing Up to Oracle Cloud Infrastructure Object Storage Using Console RMAN
  • Enable or Disable Automatic Backups for a Database
  • Create an On-Demand Full Backup of a Database Delete a Full Backup from Object Storage
  • Installing the Backup Module on the DB System Configuring RMAN
  • Backing Up to Local Storage Using the Database CLI
  • Recovering a Database Using Console, RMAN from a CLI Backup
  • Recovering a Database from the Oracle Cloud Infrastructure Classic Object Store

Oracle Cloud Infrastructure Security

  • OCI Security Features: Overview for Database Service
  • Identity and Access Management Service
  • Principals, Authentication, Authorization
  • User Authentication: OCI Security Credentials
  • Instance Isolation: OCI Database Bare Metal (BM) Instance
  • Network Security: Virtual Cloud Network (VCN)
  • User Authorization: OCI IAM
  • Data Encryption

Migrating Oracle Databases to OCI: Overview

  • Why Migrate to Oracle Cloud Infrastructure
  • Managing Oracle Database: On-Premises Versus Oracle Cloud Infrastructure
  • What Can You Migrate to Oracle Database Cloud
  • Considerations for Choosing a Migration Method
  • Migration: Information Gathering, Analysis and Planning
  • Migration: Data Transfer Options (Online and Sync, Offline)
  • Migration: Security Considerations
  • Migration Options
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward