Oracle Database Cloud Administration

This Oracle Database Cloud for Oracle DBAs training teaches you how to administer the Oracle Database Cloud Service. It's ideal for existing DBAs who want to learn how to deploy and administer an Oracle Database environment in the cloud.

Expert Oracle University instructors will provide an overview of what the Oracle Public Cloud offers in terms of services. Learn how to sign in to an Oracle Public Cloud account, create a database deployment and learn how to delete, stop, restart, patch and upgrade a database deployment.

Furthermore, you'll develop the knowledge and skills to add storage for the database deployment, containers, and perform on-demand backup and recovery operations. Instructors will deep-dive into security information, which includes configuring network access rules from tools and other database deployments, managing database deployment security at the compute node and the database levels, managing encryption of data at rest and in transit, and auditing the operations performed on the database deployment. You will also get an overview of various migration methods available for migrating Oracle Database to Oracle Cloud.

Finally, you'll learn what can be tuned in a database deployment, along with how to use the DBaaS Monitor. Instructors will focus on the Waits, Sessions, and Alerts section, as well as how to access Enterprise Manager Database Express and use the Performance Hub and Tuning Advisor. You'll also walk away with the ability to scale the database deployment to get more CPU and RAM resources.


Suggested Prerequisite

  • Experience in Oracle Database 11g and / or 12c Administration

Required Prerequisite

  • Oracle Database 12c R2: Administration Workshop Ed 3
  • Oracle Database 12c R2: Managing Multitenant Architecture Ed 2


Overview of Cloud Services

  • Oracle Database Cloud Offerings
  • Oracle Cloud Data as a Service (DaaS)
  • Universal Credits & Bring Your Own License
  • Oracle Cloud Infrastructure as a Service (IaaS)
  • Oracle Database Cloud Offerings & Oracle Cloud Subscription Offerings
  • Oracle Cloud Services
  • Oracle Cloud Platform as a Service (PaaS)
  • Oracle Cloud Software as a Service (SaaS)

Creating a Database Deployment

  • Overview of a Database Deployment and an Database Instance & Database Cloud Service Architecture
  • Automated Database Provisioning, Features and Tooling
  • Comparison: DBCS Deployment and an On-Premises Database
  • Software Editions: Included Capabilities, General Purpose Shapes, High Memory Shapes
  • How SSH Key Pairs are Used, Creating an SSH Key Pair
  • Additional Database Configuration Options
  • Using the Wizard to Create a Database Deployment, Creating a QuickStart Database Deployment
  • Storage Used for Database Files & File System Layout

Administering a Database Deployment

  • Oracle Cloud User Roles and Privileges & Administering Users, Roles, and Privileges
  • Configuring Connections to the Compute Node
  • Managing Compute Node Users
  • Using the Oracle Cloud My Services Dashboard
  • Managing Database Users and Privileges
  • Patching & Upgrading a Database Deployment
  • Scaling a Database Deployment
  • Viewing the Service Details & Using the Database Cloud Service Console

Backing Up and Recovering

  • Using Utilities to Back Up and Recover the Database Deployment
  • Performing Recovery by Using the dbaascli Utility
  • Backing Up and Recovering Database Deployments
  • Performing Recovery by Using the Console
  • Creating an On-Demand Backup
  • Changing the Backup Destination
  • Choosing a Backup Destination & Default Backup Configuration
  • Customizing the Backup Configuration

Use Case: Create a Database Deployment by Using a Production Database Backup

  • High-level Steps for Rapid Provisioning
  • Prerequisites for Restoring a Database Backup Using Backup Cloud Service
  • Creating a Database Deployment From a Production Database Backup

Overview of Oracle Cloud Security

  • User Authentication: Database Access
  • Enforcing Security in a Database Deployment
  • Physical and Operating System Security of the Compute Node
  • Cloud Security Guidelines
  • User Authentication: Services and Compute Node Access

Configuring Network Access to a Database Deployment

  • Accessing the Database Using Various Tools
  • Implementing Fine-Grained Control of Network Traffic
  • Describing Network Access to the Compute Node and Database
  • Controlling Network Traffic & Network Security
  • Creating Security Lists & Configuring Connections to the Compute Node
  • Defining Security Rules

Using Oracle DBaaS Monitor

  • Managing the Database
  • Managing and Monitoring the Listener
  • Monitoring the Operating System
  • Monitoring the Database

Implementing Database Deployment Security

  • Restricting Access to the Database
  • Transparent Data Encryption (TDE): Overview
  • Secure Access to Configuration Files on the Compute Node
  • Backing Up Operating System and Database Configuration Files
  • Auditing: Database
  • Protecting Data in the Database Deployment
  • Tablespace Encryption by Default
  • Auditing: Compute Node Connections and Actions

Use Case: Configure Network Isolation

  • Achieving Network Isolation: Use Case
  • Creating Security IP Lists
  • Creating Security Lists
  • Adding Instances to Security Lists
  • Permitting Access to Oracle Cloud Service Instances

Overview of Migrating to Oracle Database Cloud Service

  • Choosing a Method: Unplug/Plug and Remote Cloning Considerations
  • Choosing a Migration Method: Considerations
  • Choosing a Migration Method: Information Gathering
  • Applicable Migration Methods
  • Choosing a Method: RMAN, SQL*Loader, and GoldenGate Considerations
  • Choosing a Method: Oracle Data Pump Considerations

Using SQL Developer to Migrate

  • Using SQL Developer and SQL*Loader to Migrate Selected Objects
  • Using SQL Developer and INSERT Statements to Migrate Selected Objects
  • Overview of Using SQL Developer

Use Case: Automated Patching of Database Cloud Service

  • Applying Patches to Database Cloud Service Deployments

Overview of DBCS Performance Management

  • Performance Management in the Database Cloud Environment
  • General Tuning Session
  • Tuning Methodology
  • What Can be Tuned in a DBCS Environment?
  • Effective Tuning Goals
  • Performance Monitoring and Tuning

Tuning Performance Issues

  • Tools for Performance Management
  • Identifying Performance Issues by Using the DBaaS Monitor
  • Using ADDM to Diagnose Performance Issues
  • DBaaS Monitor: Database Information & Operating System Information
  • Identifying Performance Issues by Using SQL Developer
  • Using the Enterprise Manager Database Express Performance Hub
  • Using the SQL Tuning Advisor
  • Identifying Performance Issues by Using Enterprise Manager Database Express

Performance Management

  • Scaling Up CPU and Memory
  • Database Deployment Scaling: Overview
  • Database Resource Manager
  • Determining When to Scale Up the Database Deployment
  • Using Resource Manager to Control PDB Resource Usage
  • Controlling Resource Usage by Consumer Groups

Using REST APIs to Manage Oracle Database Cloud Service

  • ORDS and Database Cloud Service
  • What is Oracle REST Data Services (ORDS)?
  • Key Principles of Representational State Transfer (REST)
  • What Does ORDS Do?
  • Using cURL and REST APIs
  • Using REST APIs with Database Cloud Service
  • Reference: REST API HTTP Status Codes
  • Using REST APIs in Oracle Cloud

Deleting a Database Deployment

  • How Can You Delete a Database Deployment?
  • What Happens When You Delete a Database Deployment?

Use Case: Creating a Cloned Database Deployment from a Snapshot

  • Creating a Cloned Database Deployment from a Snapshot

Om kursen

Pris: 19 950,00 kr

exklusive moms

Längd 3 dagar
Kurskod A642

Kursen hålls på begäran

Kontakta oss för mer information.

Telefon: 08-562 557 50