Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure

  • Tuition USD $1,628
  • Reviews star_rate star_rate star_rate star_rate star_half 839 Ratings
  • Course Code ORCL-DBA-CLD
  • Duration 2 days
  • Available Formats Virtual, Classroom

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

Who Can Benefit

  • Administrator
  • Cloud Administrator
  • Database Administrator

Course Details

Topics

  • Oracle Cloud Platform for Database in the Cloud
    • Oracle Database Cloud Services
    • Journey to Autonomous Database
    • Subscribe to an Oracle Cloud Service
  • Getting Started with Oracle Cloud Infrastructure
    • Regions, Availability Domains, and Backbone Network
    • Comprehensive Virtual Network with Off-box Virtualization
    • Oracle Cloud Infrastructure Services
  • Oracle Cloud Infrastructure Essentials
    • Virtual Cloud Network (VCN) Service
    • Compute Service & Shapes
    • Object Storage Service & Block Volume Service
    • Load Balancing Service
    • DNS Service
  • Oracle Cloud Infrastructure: Database Service
    • Virtual Machine DB Systems
    • Bare Metal DB Systems
    • Exadata DB Systems
  • Bare Metal and Virtual Machine DB Systems
    • Compute
    • Shapes
    • Storage Options
    • DB Systems Storage Architecture
  • Creating and Managing Bare Metal and Virtual Machine DB Systems
    • Prerequisites to Launch DB System
    • Creating Virtual Cloud Network (VCN) for DB System
    • Using the Console to Launch 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
    • 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
  • Updating and Configuring a DB System on OCI
    • Update a DB System
    • Important Guidelines for OS Updates
    • Configure a DB System
    • Transparent Data Encryption
    • Scaling CPU & Storage
  • Patching a DB System on OCI
    • 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
    • Opening Ports on the DB System
    • Updating the Security List for the DB System
    • 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
    • Identity and Access Management Service
    • Principals, Authentication, Authorization
    • User Authentication
    • Instance Isolation
    • Network Security
    • User Authorization: OCI IAM
    • Data Encryption
  • Migrating Oracle Databases to OCI: Overview
    • Considerations for Choosing a Migration Method
    • Information Gathering, Analysis and Planning
    • Data Transfer Options (Online and Sync, Offline)
    • Security Considerations
    • Migration Options
  • 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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

ExitCertified was a good platform to use to develop the relevant skills and we learned a lot on how to actually spin up the tools and services we were learning about.

Very happy with the initial communication in getting me the materials and credentials to obtain resources for the course. Course videos, labs and guides were made available during and for 1 year after completion of the course.
Thomas was the classroom instructor and did a great job. He's knowledgeable, engaging and made the course enjoyable.

Simply great training provider that I can go for updating/acquiring my skill sets.

I received a link for automated set up. I do not like automated set up links since there's always a chance of compromise.

thorough course covering materials needed to understand aws, architecture, and their interactions. Labs helped

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward