Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• 1 Getting Started with Database Classic Cloud Service
  • About Oracle Database Classic Cloud Service
  • About Database Classic Cloud Service Database Deployments
    • Oracle Database Software Release
    • Oracle Database Software Edition
    • Oracle Database Type
    • Computing Power
    • Database Storage
    • Automatic Backup Configuration
  • Guidelines for Administering Database Classic Cloud Service Database Deployments
  • Before You Begin with Database Classic Cloud Service
  • How to Begin with Database Classic Cloud Service Subscriptions
  • About Database Classic Cloud Service Roles and Users
  • Accessing the Oracle Database Classic Cloud Service Console
  • Using the Database Classic Cloud Service REST APIs
  • Typical Workflow for Using Database Classic Cloud Service
  • About Database Deployments in Oracle Cloud Infrastructure
• 2 Managing the Database Classic Cloud Service Life Cycle
  • Creating a Database Deployment
  • Creating a QuickStart Database Deployment
    • Standard Edition
    • Enterprise Edition
    • Extreme Performance
  • Creating a Customized Database Deployment
  • Creating a Database Deployment Using a Cloud Backup
    • Creating a Cloud Backup of an On-Premises Database
    • Replacing the Database by Using the Oracle Database Classic Cloud Service Console
    • Replacing the Database by Using ibkup Actions
  • Creating a Clone Database Deployment from a Snapshot
  • Creating a Hybrid DR Deployment
  • Viewing All Database Deployments
  • Viewing Detailed Information for a Database Deployment
  • Viewing Activities for Database Deployments in an Identity Domain
  • Stopping, Starting and Restarting a Database Deployment
  • Rebooting a Compute Node
  • Scaling a Database Deployment
  • Creating and Managing IP Reservations
    • Creating an IP Reservation
    • Using an IP Reservation when Creating a Database Deployment
    • Deleting an IP Reservation
  • Creating and Managing Snapshots of a Database Deployment
  • Deleting a Database Deployment
  • Tracking the Number of Database Deployments in an Account
• 3 Managing Network Access to Database Classic Cloud Service
  • About Network Access to Database Classic Cloud Service
  • Generating a Secure Shell (SSH) Public/Private Key Pair
    • Generating an SSH Key Pair on UNIX and UNIX-Like Platforms Using the ssh-keygen Utility
    • Generating an SSH Key Pair on Windows Using the PuTTYgen Program
  • Creating an SSH Tunnel to a Compute Node Port
    • Creating an SSH Tunnel Using the ssh Utility on Linux
    • Creating an SSH Tunnel Using the PuTTY Program on Windows
  • Enabling Access to a Compute Node Port
    • Enabling Port Access by Enabling an Automatically Created Access Rule
    • Enabling or Restricting Port Access by Creating an Access Rule
  • Enabling Access to Database Classic Cloud Service Using FastConnect Classic
  • Defining a Custom Host Name or Domain Name for Database Classic Cloud Service
  • Using Network Encryption and Integrity
• 4 Administering Database Classic Cloud Service
  • Adding Temporary Storage to a Database Deployment
  • Adding an SSH Public Key
  • Updating the Cloud Tooling on Database Classic Cloud Service
    • Check the Cloud Tooling and Image Versions
    • Updating the Cloud Tooling by Using the dbaascli Utility
    • Configuring Automatic Cloud Tooling Updates
    • Updating the Cloud Tooling by Using the raccli Utility
  • Administering a Data Guard Configuration
    • Checking the Status of the Oracle Data Guard Configuration
    • Performing a Switchover Operation
      • Performing a Switchover Operation by Using the dbaascli Utility
    • Performing a Manual Failover Operation
      • Performing a Manual Failover Operation by Using the dbaascli Utility
    • Reinstating a Failed Primary Database
      • Reinstating a Failed Primary Database by Using the dbaascli Utility
    • Changing the SYS Password
    • Configuring Clients for Automatic Failover
  • Preparing 12.2 Database Deployments for Patching
    • Preparing 12.2 Database Deployments Hosting Single-Instance Databases for Patching
    • Preparing 12.2 Database Deployments Hosting Oracle RAC Databases for Patching
  • Applying Linux OS Security Patches
    • Applying Linux OS Security Patches by Using the dbaascli Utility
    • Manually Applying Linux OS Security Patches
  • Administering Oracle REST Data Services (ORDS)
    • Adding a Signed SSL Certificate to Oracle REST Data Services
    • Stopping Oracle REST Data Services
    • Starting Oracle REST Data Services
  • Loading Data into the Oracle Database on Database Classic Cloud Service
  • Tuning Oracle Database Performance on Database Classic Cloud Service
  • Monitoring and Managing Oracle Database on Database Classic Cloud Service
  • Managing the Log and Diagnostic Files on Database Classic Cloud Service
• 5 Accessing Database Classic Cloud Service
  • Connecting to a Compute Node Through Secure Shell (SSH)
    • Connecting to a Compute Node Using the ssh Utility on UNIX and UNIX-Like Platforms
    • Connecting to a Compute Node Using the PuTTY Program on Windows
  • Accessing Enterprise Manager Database Express 18c
  • Accessing Enterprise Manager Database Express 12c
  • Accessing Enterprise Manager 11g Database Control
  • Connecting Remotely to the Database by Using Oracle SQL Developer
  • Connecting Remotely to the Database by Using Oracle Net Services
  • Copying Files to or from a Database Classic Cloud Service Database Deployment
• 6 Backing Up and Restoring Databases on Database Classic Cloud Service
  • About Backing Up Database Deployments on Database Classic Cloud Service
  • Viewing Backup Configuration Information
    • Viewing Backup Configuration Information by Using the bkup_api Utility
    • Viewing Backup Configuration Information by Using the raccli Utility
  • Creating an On-Demand Backup
    • Creating an On-Demand Backup by Using the bkup_api Utility
    • Creating an On-Demand Backup by Using the raccli Utility
  • Deleting a Backup
  • Updating the Password for Backing Up to the Storage Cloud
    • Updating the Password by Using the bkup_api Utility
    • Updating the Password by Using the raccli Utility
  • Customizing the Current Backup Configuration
    • Customizing the Current Backup Configuration on Database Deployments Hosting Single-Instance Databases
    • Customizing the Current Backup Configuration on Database Deployments Hosting Oracle RAC Databases
  • Enabling and Reconfiguring the Automatic Backups Feature
    • Changing the Backup Configuration on Database Deployments Hosting Single-Instance Databases
    • Changing the Backup Configuration on Database Deployments Hosting Oracle RAC Databases
    • Increasing Local Storage for Backups on Older Database Deployments
  • Disabling and Re-enabling Scheduled Backups
  • Recover Backups Using the dbaasapi Utility
  • Restoring from the Most Recent Backup
    • Restoring from the Most Recent Backup by Using the dbaascli Utility
    • Restoring from the Most Recent Backup by Using the raccli Utility
  • Restoring from a Specific Backup
    • Restoring from a Specific Backup by Using the dbaascli Utility
  • Restoring to a Specific Point in Time
    • Restoring to a Specific Point in Time by Using the dbaascli Utility
    • Restoring to a Specific Point in Time by Using the raccli Utility
  • Retrieve the History of Scheduled Backup Results with the bkup_api Utility
  • Recreating an Unrecoverable Database Deployment From a Backup to Cloud Storage
• 7 Patching Database Classic Cloud Service
  • Viewing Available Patches
    • Viewing Available Patches by Using the dbaascli Utility
  • Checking Prerequisites Before Applying a Patch
    • Checking Patch Prerequisites by Using the dbaascli Utility
    • Checking Patch Prerequisites by Using the raccli Utility
  • Applying a Patch
    • Applying a Patch by Using the dbaascli Utility
    • Applying a Patch by Using the raccli Utility
  • Rolling Back a Patch or Failed Patch
    • Rolling Back a Patch or Failed Patch by Using the dbaascli Utility
  • Applying a Patch to a Test Deployment
  • Patching a Hybrid DR Deployment
  • The dbpatchm.cfg Configuration File
• 8 Configuring Database Features, Database Options, and Companion Products
  • Using Oracle Real Application Clusters (RAC) in Database Classic Cloud Service
  • Using Oracle Data Guard in Database Classic Cloud Service
    • More About Oracle Data Guard
  • Using Oracle Real Application Clusters (RAC) and Oracle Data Guard Together in Database Classic Cloud Service
  • Using Oracle Multitenant in Database Classic Cloud Service
    • Creating and Activating a Master Encryption Key for a PDB
    • Exporting and Importing a Master Encryption Key for a PDB
  • Using Oracle Database Vault in Database Classic Cloud Service
    • Configuring and Enabling Oracle Database Vault
    • Disabling Oracle Database Vault
  • Using Oracle Application Express in Database Classic Cloud Service
    • Accessing the Oracle Application Express Console
    • Upgrading from Oracle Application Express 4.2 or 5.0 to 5.1 for Oracle Database 11g
    • Upgrading from Oracle Application Express 4.2 to 5.1 for Oracle Database 12c
    • Upgrading from Oracle Application Express 5.0 to 5.1 for Oracle Database 12c
    • Upgrading from Oracle Application Express 5.1.0 or 5.1.3 to 5.1.4 for Oracle Database 11g
    • Upgrading from Oracle Application Express 5.1.0 or 5.1.3 to 5.1.4 for Oracle Database 12c and Oracle Database 18c
    • Upgrading from Oracle Application Express 5.1.0 or 5.1.3 or 5.1.4 to 18.1.0 for Oracle Database 12.2 and Oracle Database 18c
    • Moving Oracle Application Express 5.1 from CDB$ROOT to PDBs
  • Using Oracle SQL Developer Web in Database Classic Cloud Service
    • Enabling a Schema for SQL Developer Web
    • Accessing SQL Developer Web
    • Features of SQL Developer Web
  • Using the Demos PDB
  • Using Oracle Enterprise Manager Cloud Control with Database Classic Cloud Service
  • Using Oracle GoldenGate Cloud Service with Database Classic Cloud Service
    • Manually Configuring a Deployment’s Database for Oracle GoldenGate Cloud Service Replication
• 9 Migrating Oracle Databases to Database Classic Cloud Service
  • Choosing a Migration Method
  • Migrating from Oracle Database 11g to Oracle Database 11g in the Cloud
  • Migrating from Oracle Database 11g to Oracle Database 12c in the Cloud
  • Migrating from Oracle Database 12c CDB to Oracle Database 12c in the Cloud
  • Migrating from Oracle Database 12c Non-CDB to Oracle Database 12c in the Cloud
  • Migration Methods
    • Data Pump Conventional Export/Import
      • Data Pump Conventional Export/Import: Example
    • Data Pump Full Transportable
      • Data Pump Full Transportable: Example
    • Data Pump Transportable Tablespace
      • Data Pump Transportable Tablespace: Example
    • Remote Cloning a PDB
    • Remote Cloning Non-CDB
    • RMAN Cross-Platform Transportable PDB
    • RMAN Cross-Platform Transportable Tablespace Backup Sets
      • RMAN Cross-Platform Transportable Tablespace Backup Sets: Example
    • RMAN Transportable Tablespace with Data Pump
      • RMAN Transportable Tablespace with Data Pump: Example
    • RMAN CONVERT Transportable Tablespace with Data Pump
      • RMAN CONVERT Transportable Tablespace with Data Pump: Example
    • SQL Developer and INSERT Statements to Migrate Selected Objects
    • SQL Developer and SQL*Loader to Migrate Selected Objects
    • Unplugging/Plugging a PDB
    • Unplugging/Plugging Non-CDB
• 10 Upgrading Single Instance Database to Oracle Database 19c in the Cloud
  • Upgrade Overview
  • Upgrade Process
    • Task 1: Take Full Backup of SOURCE DB
    • Task 2: Provision SHELL DB Instance
    • Task 3: Get the spfile handle, controlfile handle, tde wallet that contains the autologin wallet, and the dbid from SOURCE DB VM
    • Task 4: Get Oracle Application Express (APEX) images directory from SOURCE DB
    • Task 5: Restore SOURCE DB backup and Oracle APEX images directory in TARGET DB
    • Task 6: Update PSM Metadata
  • Upgrade Validation
  • Post Upgrade Tasks
• 11 Frequently Asked Questions for Database Classic Cloud Service
• 12 Troubleshooting Database Classic Cloud Service
  • Problems Creating Deployments
    • I cannot create a deployment when I have many database deployments
    • I cannot create a deployment, even after waiting for an hour
    • I get a "SCRIPT execution errors" message when I try to create an deployment with backups to cloud storage
  • Problems Administering Deployments
    • I am required to change the password for the oracle user when I try to connect to a compute node
    • I get a Linux error 30, Read-only file system, when trying to connect to or work in my environment
    • I can’t use dbaascli to update my cloud tooling
  • Problems with Scaling
    • My scaling operation does not start
    • My deployment is too busy to allow scaling
    • After scaling the shape of my Data Guard configuration, I get an ORA-16792 warning when I check the status of the configuration
  • Problems with Patching and Rollback
    • I receive a message stating that the virtual machines are unhealthy
    • I receive a message stating that the instance is busy with another operation
    • I cannot apply a patch due to a lack of storage space
    • My attempt to roll back the January 2015 Patch Set Update (Jan 2015 PSU) fails
    • My attempt to roll back the April 2015 Patch Set Update (Apr 2015 PSU) fails
  • Problems with Backing Up and Restoring
    • There is not enough space for my backup
    • I receive a message stating that there was an unexpected error during the duplicate command (ORA messages)
    • I receive a message stating that there was an unexpected error during the duplicate command (RMAN messages)
    • A backup fails with an ORA-19914 and ORA-28361
  • Problems with Oracle Data Guard Role Transitions
    • A message in the Activity area indicates that the reinstate operation failed
    • A message indicates a problem with the SYS password on the standby database
    • After a role transition operation, I get an ORA-16792 warning when I check the status of the configuration
  • Problems with Single Instance Upgrades to Oracle Cloud Database 19c on OCC 20.4
    • My Upgrade Process Failed
    • I am Not Sure if Datapatch Succeeded or Failed
    • My Datapatch Process Failed
• A Characteristics of a Newly Created Deployment
  • Characteristics Common Across Database Deployment Types
    • Data Security
      • Security of Data at Rest
      • Security of Data in Transit
    • Hybrid Columnar Compression (HCC)
    • Tablespace Encryption
      • Creating Encrypted Tablespaces
      • Managing Tablespace Encryption
  • Characteristics of a Single Instance Database Deployment
    • Linux User Accounts
    • Storage Volumes and File System Layout
    • Locations of Installed Software
    • Network Access
    • Oracle Database Characteristics
    • Location of Diagnostic and Log Files
  • Characteristics of a Single Instance with Data Guard Standby Database Deployment
    • Linux User Accounts
    • Storage Volumes and File System Layout
    • Network Access
    • Oracle Data Guard Configuration
  • Characteristics of a Database Clustering with RAC Database Deployment
    • Linux User Accounts
    • Storage Volumes and File System Layout
    • Network Access
  • Characteristics of a Database Clustering with RAC and Data Guard Standby Database Deployment
    • Linux User Accounts
    • Storage Volumes and File System Layout
    • Network Access
    • Oracle Data Guard Configuration
• B Oracle Cloud Pages for Administering Database Classic Cloud Service
  • Instances Page
  • Activity Page
  • SSH Access Page
  • IP Reservations Page
  • QuickStarts Page
  • Overview Page
  • Access Rules Page
  • Backup Page
  • Patching Page
  • Snapshots Page
  • Create Instance: Instance Page
  • Create Instance: Instance Details Page
  • Create Instance: Confirmation Page
• C The oracle-dbcs-cli Utility
  • Downloading and Installing the oracle-dbcs-cli Utility
  • Running the oracle-dbcs-cli Utility
  • The Configuration File for oracle-dbcs-cli Subcommands
  • The Data File for the oracle-dbcs-cli create Subcommand
• D The dbaascli Utility
  • dbaascli database bounce
  • dbaascli database changepassword
  • dbaascli database start
  • dbaascli database status
  • dbaascli database stop
  • dbaascli dataguard failover
  • dbaascli dataguard reinstate
  • dbaascli dataguard status
  • dbaascli dataguard switchover
  • dbaascli dbpatchm apply
  • dbaascli dbpatchm clonedb
  • dbaascli dbpatchm list_patches
  • dbaascli dbpatchm list_tools
  • dbaascli dbpatchm prereq
  • dbaascli dbpatchm rollback
  • dbaascli dbpatchm switchback
  • dbaascli dbpatchm toolsinst
  • dbaascli dv off
  • dbaascli dv on
  • dbaascli gg setup
  • dbaascli gg status
  • dbaascli listener bounce
  • dbaascli listener start
  • dbaascli listener status
  • dbaascli listener stop
  • dbaascli netsec config
  • dbaascli netsec config encryption
  • dbaascli netsec config integrity
  • dbaascli netsec status
  • dbaascli patch db apply
  • dbaascli patch db cleanup
  • dbaascli patch db list
  • dbaascli patch db prereq
  • dbaascli patch db switchback
  • dbaascli patch os apply
  • dbaascli patch os list
  • dbaascli patch tools apply
  • dbaascli patch tools auto disable
  • dbaascli patch tools auto enable
  • dbaascli patch tools auto execute
  • dbaascli patch tools auto status
  • dbaascli patch tools list
  • dbaascli orec duplicate
  • dbaascli orec keep list
  • dbaascli orec keep tag
  • dbaascli orec latest
  • dbaascli orec list
  • dbaascli orec pitr
  • dbaascli orec scn
  • dbaascli tde rotate masterkey
  • dbaascli tde status
• E The raccli Utility
  • raccli apply patch
  • raccli clean backup
  • raccli create backup
  • raccli create recovery
  • raccli describe job
  • raccli describe system
  • raccli failover dataguard
  • raccli list backup
  • raccli list backupconfig
  • raccli list jobs
  • raccli list recovery
  • raccli reinstate dataguard
  • raccli status dataguard
  • raccli switchover dataguard
  • raccli update backupconfig
  • raccli update databasepassword
  • raccli update netsec
  • raccli update rdk
  • raccli update server
  • raccli update tde
• F The dbpatchmdg Utility
  • Running the dbpatchmdg Utility
  • dbpatchmdg apply_async
  • dbpatchmdg precheck_async
  • dbpatchmdg rollback_async
• G Using Oracle DBaaS Monitor
  • About Oracle DBaaS Monitor
  • Accessing Oracle DBaaS Monitor
  • Filtering the Display on DBaaS Monitor Pages
  • Administering the Listener
    • Viewing Listener Status Information
    • Starting the Listener
    • Stopping the Listener
    • Verifying that the Listener Knows of a Service
  • Starting and Stopping the Database Instance
    • Starting the Database Instance
    • Stopping the Database Instance
  • Viewing and Modifying Initialization Parameters
  • Viewing User Account and Expiring Password Information
  • Viewing Tablespace and Segment Space Usage
  • Changing the TDE Keystore Password
  • Viewing Alert Log Entries and Checking for Errors
  • Viewing Real Time SQL Monitor
  • Administering Pluggable Databases
    • Cloning a Pluggable Database
    • Closing a Pluggable Database
    • Creating a Pluggable Database
    • Dropping a Pluggable Database
    • Opening a Pluggable Database
    • Plugging In a Pluggable Database
    • Unplugging a Pluggable Database