Administering Oracle Database Classic Cloud Service
Oracle CloudAdministering Oracle Database Classic CloudServiceE48368-63February 2021
Oracle Cloud Administering Oracle Database Classic Cloud Service,E48368-63Copyright 2014, 2021, Oracle and/or its affiliates.This software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,any programs embedded, installed or activated on delivered hardware, and modifications of such programs)and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Governmentend users are "commercial computer software" or "commercial computer software documentation" pursuantto the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such,the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works,and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programsembedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oraclecomputer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in thelicense contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloudservices are defined by the applicable contract for such services. No other rights are granted to the U.S.Government.This software or hardware is developed for general use in a variety of information management applications.It is not developed or intended for use in any inherently dangerous applications, including applications thatmay create a risk of personal injury. If you use this software or hardware in dangerous applications, then youshall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure itssafe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware or hardware in dangerous applications.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks oftheir respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks areused under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc,and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registeredtrademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products,and services from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services unless otherwiseset forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will notbe responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,products, or services, except as set forth in an applicable agreement between you and Oracle.
ContentsPreface12AudiencexvDocumentation AccessibilityxvRelated DocumentsxvConventionsxvGetting Started with Database Classic Cloud ServiceAbout Oracle Database Classic Cloud Service1-1About Database Classic Cloud Service Database Deployments1-2Oracle Database Software Release1-3Oracle Database Software Edition1-3Oracle Database Type1-4Computing Power1-5Database Storage1-5Automatic Backup Configuration1-6Guidelines for Administering Database Classic Cloud Service DatabaseDeployments1-6Before You Begin with Database Classic Cloud Service1-8How to Begin with Database Classic Cloud Service Subscriptions1-9About Database Classic Cloud Service Roles and Users1-10Accessing the Oracle Database Classic Cloud Service Console1-10Using the Database Classic Cloud Service REST APIs1-11Typical Workflow for Using Database Classic Cloud Service1-11About Database Deployments in Oracle Cloud Infrastructure1-12Managing the Database Classic Cloud Service Life CycleCreating a Database Deployment2-1Creating a QuickStart Database Deployment2-2Standard Edition2-3Enterprise Edition2-4Extreme Performance2-4iii
Creating a Customized Database DeploymentCreating a Database Deployment Using a Cloud Backup32-15Creating a Cloud Backup of an On-Premises Database2-18Replacing the Database by Using the Oracle Database Classic Cloud ServiceConsole2-20Replacing the Database by Using ibkup Actions2-23Creating a Clone Database Deployment from a Snapshot2-31Creating a Hybrid DR Deployment2-32Viewing All Database Deployments2-37Viewing Detailed Information for a Database Deployment2-37Viewing Activities for Database Deployments in an Identity Domain2-38Stopping, Starting and Restarting a Database Deployment2-38Rebooting a Compute Node2-42Scaling a Database Deployment2-43Creating and Managing IP Reservations2-46Creating an IP Reservation2-46Using an IP Reservation when Creating a Database Deployment2-47Deleting an IP Reservation2-48Creating and Managing Snapshots of a Database Deployment2-48Deleting a Database Deployment2-50Tracking the Number of Database Deployments in an Account2-51Managing Network Access to Database Classic Cloud ServiceAbout Network Access to Database Classic Cloud Service3-1Generating a Secure Shell (SSH) Public/Private Key Pair3-2Generating an SSH Key Pair on UNIX and UNIX-Like Platforms Using the sshkeygen Utility3-2Generating an SSH Key Pair on Windows Using the PuTTYgen Program3-3Creating an SSH Tunnel to a Compute Node Port3-4Creating an SSH Tunnel Using the ssh Utility on Linux3-5Creating an SSH Tunnel Using the PuTTY Program on Windows3-5Enabling Access to a Compute Node Port3-7Enabling Port Access by Enabling an Automatically Created Access Rule3-8Enabling or Restricting Port Access by Creating an Access Rule3-8Enabling Access to Database Classic Cloud Service Using FastConnect Classic42-53-9Defining a Custom Host Name or Domain Name for Database Classic Cloud Service3-10Using Network Encryption and Integrity3-10Administering Database Classic Cloud ServiceAdding Temporary Storage to a Database Deployment4-1iv
Adding an SSH Public Key4-5Updating the Cloud Tooling on Database Classic Cloud Service4-6Check the Cloud Tooling and Image Versions4-6Updating the Cloud Tooling by Using the dbaascli Utility4-7Configuring Automatic Cloud Tooling Updates4-8Updating the Cloud Tooling by Using the raccli UtilityAdministering a Data Guard Configuration4-11Checking the Status of the Oracle Data Guard Configuration4-12Performing a Switchover Operation4-12Performing a Switchover Operation by Using the dbaascli UtilityPerforming a Manual Failover OperationPerforming a Manual Failover Operation by Using the dbaascli UtilityReinstating a Failed Primary DatabaseReinstating a Failed Primary Database by Using the dbaascli Utility4-134-144-154-164-17Changing the SYS Password4-17Configuring Clients for Automatic Failover4-18Preparing 12.2 Database Deployments for Patching4-18Preparing 12.2 Database Deployments Hosting Single-Instance Databases forPatching4-19Preparing 12.2 Database Deployments Hosting Oracle RAC Databases forPatching4-19Applying Linux OS Security Patches4-20Applying Linux OS Security Patches by Using the dbaascli Utility4-23Manually Applying Linux OS Security Patches4-25Administering Oracle REST Data Services (ORDS)54-104-26Adding a Signed SSL Certificate to Oracle REST Data Services4-27Stopping Oracle REST Data Services4-28Starting Oracle REST Data Services4-28Loading Data into the Oracle Database on Database Classic Cloud Service4-28Tuning Oracle Database Performance on Database Classic Cloud Service4-30Monitoring and Managing Oracle Database on Database Classic Cloud Service4-30Managing the Log and Diagnostic Files on Database Classic Cloud Service4-31Accessing Database Classic Cloud ServiceConnecting to a Compute Node Through Secure Shell (SSH)5-1Connecting to a Compute Node Using the ssh Utility on UNIX and UNIX-LikePlatforms5-1Connecting to a Compute Node Using the PuTTY Program on Windows5-2Accessing Enterprise Manager Database Express 18c5-4Accessing Enterprise Manager Database Express 12c5-6Accessing Enterprise Manager 11g Database Control5-8v
6Connecting Remotely to the Database by Using Oracle SQL Developer5-11Connecting Remotely to the Database by Using Oracle Net Services5-12Copying Files to or from a Database Classic Cloud Service Database Deployment5-15Backing Up and Restoring Databases on Database Classic CloudServiceAbout Backing Up Database Deployments on Database Classic Cloud Service6-1Viewing Backup Configuration Information6-3Viewing Backup Configuration Information by Using the bkup api Utility6-3Viewing Backup Configuration Information by Using the raccli Utility6-4Creating an On-Demand Backup6-4Creating an On-Demand Backup by Using the bkup api Utility6-5Creating an On-Demand Backup by Using the raccli Utility6-6Deleting a Backup6-6Updating the Password for Backing Up to the Storage Cloud6-7Updating the Password by Using the bkup api Utility6-8Updating the Password by Using the raccli Utility6-9Customizing the Current Backup Configuration6-9Customizing the Current Backup Configuration on Database DeploymentsHosting Single-Instance Databases6-10Customizing the Current Backup Configuration on Database DeploymentsHosting Oracle RAC Databases6-13Enabling and Reconfiguring the Automatic Backups Feature6-15Changing the Backup Configuration on Database Deployments Hosting SingleInstance Databases6-17Changing the Backup Configuration on Database Deployments Hosting OracleRAC Databases6-18Increasing Local Storage for Backups on Older Database Deployments6-19Disabling and Re-enabling Scheduled Backups6-22Recover Backups Using the dbaasapi Utility6-23Restoring from the Most Recent Backup6-24Restoring from the Most Recent Backup by Using the dbaascli Utility6-25Restoring from the Most Recent Backup by Using the raccli Utility6-26Restoring from a Specific BackupRestoring from a Specific Backup by Using the dbaascli UtilityRestoring to a Specific Point in Time6-276-286-29Restoring to a Specific Point in Time by Using the dbaascli Utility6-31Restoring to a Specific Point in Time by Using the raccli Utility6-32Retrieve the History of Scheduled Backup Results with the bkup api Utility6-33vi
Recreating an Unrecoverable Database Deployment From a Backup to CloudStorage7Patching Database Classic Cloud ServiceViewing Available PatchesViewing Available Patches by Using the dbaascli UtilityChecking Prerequisites Before Applying a Patch7-17-27-2Checking Patch Prerequisites by Using the dbaascli Utility7-4Checking Patch Prerequisites by Using the raccli Utility7-4Applying a Patch7-5Applying a Patch by Using the dbaascli Utility7-7Applying a Patch by Using the raccli Utility7-8Rolling Back a Patch or Failed PatchRolling Back a Patch or Failed Patch by Using the dbaascli Utility86-357-97-10Applying a Patch to a Test Deployment7-11Patching a Hybrid DR Deployment7-12The dbpatchm.cfg Configuration File7-13Configuring Database Features, Database Options, and CompanionProductsUsing Oracle Real Application Clusters (RAC) in Database Classic Cloud Service8-1Using Oracle Data Guard in Database Classic Cloud Service8-3More About Oracle Data Guard8-5Using Oracle Real Application Clusters (RAC) and Oracle Data Guard Together inDatabase Classic Cloud Service8-5Using Oracle Multitenant in Database Classic Cloud Service8-7Creating and Activating a Master Encryption Key for a PDB8-7Exporting and Importing a Master Encryption Key for a PDB8-9Using Oracle Database Vault in Database Classic Cloud Service8-9Configuring and Enabling Oracle Database Vault8-10Disabling Oracle Database Vault8-11Using Oracle Application Express in Database Classic Cloud Service8-11Accessing the Oracle Application Express Console8-12Upgrading from Oracle Application Express 4.2 or 5.0 to 5.1 for OracleDatabase 11g8-15Upgrading from Oracle Application Express 4.2 to 5.1 for Oracle Database 12c8-17Upgrading from Oracle Application Express 5.0 to 5.1 for Oracle Database 12c8-24Upgrading from Oracle Application Express 5.1.0 or 5.1.3 to 5.1.4 for OracleDatabase 11g8-29Upgrading from Oracle Application Express 5.1.0 or 5.1.3 to 5.1.4 for OracleDatabase 12c and Oracle Database 18c8-31vii
Upgrading from Oracle Application Express 5.1.0 or 5.1.3 or 5.1.4 to 18.1.0 forOracle Database 12.2 and Oracle Database 18c8-34Moving Oracle Application Express 5.1 from CDB ROOT to PDBs8-36Using Oracle SQL Developer Web in Database Classic Cloud Service8-41Enabling a Schema for SQL Developer Web8-42Accessing SQL Developer Web8-43Features of SQL Developer Web8-46Using the Demos PDB8-46Using Oracle Enterprise Manager Cloud Control with Database Classic CloudService8-47Using Oracle GoldenGate Cloud Service with Database Classic Cloud Service8-49Manually Configuring a Deployment’s Database for Oracle GoldenGate CloudService Replication98-50Migrating Oracle Databases to Database Classic Cloud ServiceChoosing a Migration Method9-1Migrating from Oracle Database 11g to Oracle Database 11g in the Cloud9-2Migrating from Oracle Database 11g to Oracle Database 12c in the Cloud9-3Migrating from Oracle Database 12c CDB to Oracle Database 12c in the Cloud9-4Migrating from Oracle Database 12c Non-CDB to Oracle Database 12c in the Cloud9-6Migration Methods9-8Data Pump Conventional Export/ImportData Pump Conventional Export/Import: ExampleData Pump Full TransportableData Pump Full Transportable: ExampleData Pump Transportable TablespaceData Pump Transportable Tablespace: Example9-89-99-109-119-139-14Remote Cloning a PDB9-16Remote Cloning Non-CDB9-17RMAN Cross-Platform Transportable PDB9-17RMAN Cross-Platform Transportable Tablespace Backup Sets9-18RMAN Cross-Platform Transportable Tablespace Backup Sets: ExampleRMAN Transportable Tablespace with Data PumpRMAN Transportable Tablespace with Data Pump: ExampleRMAN CONVERT Transportable Tablespace with Data PumpRMAN CONVERT Transportable Tablespace with Data Pump: Example9-199-219-229-239-24SQL Developer and INSERT Statements to Migrate Selected Objects9-27SQL Developer and SQL*Loader to Migrate Selected Objects9-27Unplugging/Plugging a PDB9-28Unplugging/Plugging Non-CDB9-28viii
10Upgrading Single Instance Database to Oracle Database 19c in theCloudUpgrade Overview10-1Upgrade Process10-2Task 1: Take Full Backup of SOURCE DB10-2Task 2: Provision SHELL DB Instance10-4Task 3: Get the spfile handle, controlfile handle, tde wallet that contains theautologin wallet, and the dbid from SOURCE DB VM10-5Task 4: Get Oracle Application Express (APEX) images directory from SOURCEDB10-8Task 5: Restore SOURCE DB backup and Oracle APEX images directory inTARGET DB10-9Task 6: Update PSM Metadata10-18Upgrade Validation10-19Post Upgrade Tasks10-2411Frequently Asked Questions for Database Classic Cloud Service12Troubleshooting Database Classic Cloud ServiceProblems Creating Deployments12-2I cannot create a deployment when I have many database deployments12-2I cannot create a deployment, even after waiting for an hour12-2I get a "SCRIPT execution errors" message when I try to create an deploymentwith backups to cloud storage12-2Problems Administering Deployments12-3I am required to change the password for the oracle user when I try to connectto a compute node12-3I get a Linux error 30, Read-only file system, when trying to connect to or workin my environment12-4I can’t use dbaascli to update my cloud tooling12-4Problems with Scaling12-5My scaling operation does not start12-5My deployment is too busy to allow scaling12-5After scaling the shape of my Data Guard configuration, I get an ORA-16792warning when I check the status of the configuration12-6Problems with Patching and Rollback12-6I receive a message stating that the virtual machines are unhealthy12-7I receive a message stating that the instance is busy with another operation12-7I cannot apply a patch due to a lack of storage space12-7My attempt to roll back the January 2015 Patch Set Update (Jan 2015 PSU) fails12-8ix
My attempt to roll back the April 2015 Patch Set Update (Apr 2015 PSU) failsProblems with Backing Up and Restoring12-10There is not enough space for my backup12-10I receive a message stating that there was an unexpected error during theduplicate command (ORA messages)12-10I receive a message stating that there was an unexpected error during theduplicate command (RMAN messages)12-11A backup fails with an ORA-19914 and ORA-2836112-12Problems with Oracle Data Guard Role Transitions12-12A message in the Activity area indicates that the reinstate operation failed12-12A message indicates a problem with the SYS password on the standbydatabase12-12After a role transition operation, I get an ORA-16792 warning when I check thestatus of the configuration12-13Problems with Single Instance Upgrades to Oracle Cloud Database 19c on OCC20.4A12-912-14My Upgrade Process Failed12-14I am Not Sure if Datapatch Succeeded or Failed12-14My Datapatch Process Failed12-15Characteristics of a Newly Created DeploymentCharacteristics Common Across Database Deployment TypesData SecurityA-1A-1Security of Data at RestA-2Security of Data in TransitA-2Hybrid Columnar Compression (HCC)A-3Tablespace EncryptionA-3Creating Encrypted TablespacesA-3Managing Tablespace EncryptionA-4Characteristics of a Single Instance Database DeploymentA-5Linux User AccountsA-6Storage Volumes and File System LayoutA-7Locations of Installed SoftwareA-8Network AccessA-8Oracle Database CharacteristicsA-10Location of Diagnostic and Log FilesA-10Characteristics of a Single Instance with Data Guard Standby Database DeploymentA-10Linux User AccountsA-11Storage Volumes and File System LayoutA-12Network AccessA-13Oracle Data Guard ConfigurationA-15Characteristics of a Database Clustering with RAC Database DeploymentA-15x
Linux User AccountsA-16Storage Volumes and File System LayoutA-18Network AccessA-20Characteristics of a Database Clustering with RAC and Data Guard StandbyDatabase DeploymentBCDA-21Linux User AccountsA-22Storage Volumes and File System LayoutA-24Network AccessA-25Oracle Data Guard ConfigurationA-26Oracle Cloud Pages for Administering Database Classic CloudServiceInstances PageB-1Activity PageB-5SSH Access PageB-7IP Reservations PageB-8QuickStarts PageB-9Overview PageB-10Access Rules PageB-15Backup PageB-16Patching PageB-17Snapshots PageB-17Create Instance: Instance PageB-18Create Instance: Instance Details PageB-21Create Instance: Confirmation PageB-27The oracle-dbcs-cli UtilityDownloading and Installing the oracle-dbcs-cli UtilityC-1Running the oracle-dbcs-cli UtilityC-2The Configuration File for oracle-dbcs-cli SubcommandsC-6The Data File for the oracle-dbcs-cli create SubcommandC-7The dbaascli Utilitydbaascli database bounceD-3dbaascli database changepasswordD-3dbaascli database startD-4dbaascli database statusD-4dbaascli database stopD-4dbaascli dataguard failoverD-4xi
dbaascli dataguard reinstateD-5dbaascli dataguard statusD-5dbaascli dataguard switchoverD-5dbaascli dbpatchm applyD-6dbaascli dbpatchm clonedbD-6dbaascli dbpatchm list patchesD-6dbaascli dbpatchm list toolsD-7dbaascli dbpatchm prereqD-7dbaascli dbpatchm rollbackD-8dbaascli dbpatchm switchbackD-8dbaascli dbpatchm toolsinstD-8dbaascli dv offD-9dbaascli dv onD-9dbaascli gg setupD-10dbaascli gg statusD-11dbaascli listener bounceD-11dbaascli listener startD-11dbaascli listener statusD-11dbaascli listener stopD-11dbaascli netsec configD-12dbaascli netsec config encryptionD-15dbaascli netsec config integrityD-16dbaascli netsec statusD-18dbaascli patch db applyD-18dbaascli patch db cleanupD-18dbaascli patch db listD-19dbaascli patch db prereqD-19dbaascli patch db switchbackD-19dbaascli patch os applyD-20dbaascli patch os listD-20dbaascli patch tools applyD-20dbaascli patch tools auto disableD-20dbaascli patch tools auto enableD-21dbaascli patch tools auto executeD-21dbaascli patch tools auto statusD-21dbaascli patch tools listD-22dbaascli orec duplicateD-22dbaascli orec keep listD-22dbaascli orec keep tagD-23dbaascli orec latestD-23dbaascli orec listD-23xii
EFGdbaascli orec pitrD-24dbaascli orec scnD-24dbaascli tde rotate masterkeyD-25dbaascli tde statusD-25The raccli Utilityraccli apply patchE-2raccli clean backupE-3raccli create backupE-3raccli create recoveryE-4raccli describe jobE-5raccli describe systemE-6raccli failover dataguardE-7raccli list backupE-8raccli list backupconfigE-9raccli list jobsE-10raccli list recoveryE-11raccli reinstate dataguardE-12raccli status dataguardE-12raccli switchover dataguardE-13raccli update backupconfigE-14raccli update databasepasswordE-16raccli update netsecE-17raccli update rdkE-19raccli update serverE-20raccli update tdeE-21The dbpatchmdg UtilityRunning the dbpatchmdg UtilityF-1dbpatchmdg apply asyncF-2dbpatchmdg precheck asyncF-2dbpatchmdg rollback asyncF-3Using Oracle DBaaS MonitorAbout Oracle DBaaS MonitorG-1Accessing Oracle DBaaS MonitorG-2Filtering the Display on DBaaS Monitor PagesG-4Administering the ListenerG-5Viewing Listener Status InformationG-5xiii
Starting the ListenerG-6Stopping the ListenerG-6Verifying that the Listener Knows of a ServiceG-6Starting and Stopping the Database InstanceG-7Starting the Database InstanceG-7Stopping the Database InstanceG-7Viewing and Modifying Initialization ParametersG-7Viewing User Account and Expiring Password InformationG-8Viewing Tablespace and Segment Space UsageG-9Changing the TDE Keystore PasswordG-9Viewing Alert Log Entries and Checking for ErrorsG-10Viewing Real Time SQL MonitorG-10Administering Pluggable DatabasesG-12Cloning a Pluggable DatabaseG-13Closing a Pluggable DatabaseG-13Creating a Pluggable DatabaseG-13Dropping a Pluggable DatabaseG-14Opening a Pluggable DatabaseG-14Plugging In a Pluggable DatabaseG-14Unplugging a Pluggable DatabaseG-15xiv
PrefaceThis document describes how to manage and monitor Oracle Database Classic CloudService and provides references to related documentation.Topics Audience Documentation Accessibility Related Documents ConventionsAudienceThis document is intended for Oracle Cloud users who want to manage and monitorOracle Database Classic Cloud Service.Documentation AccessibilityFor information about Oracle's commitment to accessibility, visit theOracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx acc&id docacc.Access to Oracle SupportOracle customers that have purchased support have access to electronic supportthrough My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx acc&id info or visit http://www.oracle.com/pls/topic/lookup?ctx acc&id trsif you are hearing impaired.Related DocumentsFor more information, see these Oracle resources: Getting Started with Oracle Cloud Using Oracle Cloud Infrastructure Object Storage Classic Using Oracle Cloud Infrastructure Compute ClassicConventionsThe following text conventions are used in this document:xv
PrefaceConvention MeaningboldfaceBoldface type indicates graphical user interface elements associated with anaction, or terms defined in text or the glossary.italicItalic type indicates book titles, emphasis, or placeholder variables for which yousupply particular values.monospaceMonospace type indicates commands within a paragraph, URLs, code inexamples, text that appears on the screen, or text that you enter.xvi
1Getting Started with Database ClassicCloud ServiceThis section describes how to get started with Oracle Database Classic Cloud Servicefor administrators and application owners.Topics About Oracle Database Classic Cloud Service About 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 InfrastructureAbout Oracle Database Classic Cloud ServiceOracle Database Classic Cloud Service provides you the ability to deploy Oracledatabases in the Cloud, with each database deployment containing a single Oracledatabase or an Oracle Data Guard configuration consisting of a primary Oracledatabase and a standby Oracle database. You have full access to the featuresand operations available with Oracle Database, but with Oracle providing thecomputing power, physical storage and (optionally) tooling to simplify routine databasemaintenance and management operations.When you create a database deployment, Database Classic Cloud Service createscompute nodes to host the database, using computing, storage and networkingresources provided by various Oracle Cloud infrastructure services.The deployment includes Oracle Database and supporting software. The softwareis installed for you, an Oracle database is created using values you provide whencreating the database deployment, and the database is started. Additionally, youcan direct Database Classic Cloud Service to set up automatic backups. Finally,the deployment includes cloud tooling that simplifies backup, recovery, patching andupgrade operations. You have root privilege, so you can load and run software in thecompute environment. You have full administrative privileges for the Oracle database.You are responsible for making any changes to the automated maintenance setup,and you are responsible for recovery operations in the event of a failure.Like many Oracle Cloud platform services, Database Classic Cloud Service relies onan underlying component of Oracle Cloud named Platform Service Manager (PSM) toprovide its service console and its REST API. As a result, you will find that the Oracle1-1
Chapter 1About Database Classic Cloud Service Database DeploymentsDatabase Classic Cloud Service console has the same “look and feel” as the serviceconsoles for other platform services like Oracle GoldenGate Cloud Service and OracleJava Cloud Service, and you will find that the endpoint structure and feature set of theDatabase Classic Cloud Service REST API is very similar to those of the REST APIsfor other platform services.The Platform Service Manager (PSM) component of Oracle Cloud uses SSH to accessthe compute nodes that comprise your database deployments, in order to performpredefined Platform Service actions like backup and patching. You initiate thesePlatform Service actions from the web console or REST API. A separate SSH key pairis used for each database deployment to perform this internal communication. ThisSSH key is not available for ad hoc usage. You cannot delete this key from computenodes or it will cause these Platform Service actions to fail. The key is only usedunder programmatic control and cannot be directly accessed by Oracle employees. AllSSH actions performed by the Platform Service Manager (PSM) component on yourcompute nodes are logged and can be audited. The Oracle Cloud Operations teamdoes not have access to any SSH keys residing on your compute nodes and has noway to access your compute nodes, unless you explicitly provide access to the keysfor troubleshooting purposes.Cloud Tooling for Database Classic Cloud ServiceIn addition to the capabilities of the web-based Oracle Database Classic Cloud Serviceconsole, Database Classic Cloud Service offers the following tools on the databasedelpoyment's compute nodes: Simple Automated Backups: use the bkup api utility (raccli on deploymentsthat use Oracle Real Application Clusters) to perform on-demand backups and tochange how automatic backups are configured. See Backing Up and RestoringDatabases on Database Classic Cloud Service. Simple Automated Recovery: use the orec subcommand of the dbaascli utility(raccli on deployments that use Oracle Real Application Clusters) to restore frombackups. See Backing Up and Restoring Databases on Database Classic CloudService. Simple Automated Patching: use the patch subcommand of the dbaascli utility(raccli on deployments that use Oracle Real Application Clusters) to applypatches. See Patching Database Classic Cloud Service. SQL Developer Web: use the Oracle SQL Developer Web browser-basedapplication to monitor the Oracle database and computing resources. See UsingOracle SQL Developer Web in Database Classic Cloud Service. Oracle SQLDeveloper Web is not available on deployments that use Oracle Real ApplicationClusters.About Database Classic Cloud Service DatabaseDeploymentsWhen you create a new database deployment on Oracle Database Classic CloudService, you use the Create Instance wizard, which steps you through the process ofmaking the choices that produce a database deployment tailored to your needs. Thesechoices include: Oracle Database Software Release1-2
Chapter 1About Database Classic Cloud Service Database Deployments Oracle Database Software Edition Oracle Database Type Computing Power Database Storage Automatic Backup ConfigurationOracle Database Software ReleaseWhen creating a database deployment on Oracl
Getting Started with Database Classic Cloud Service. About Oracle Database Classic Cloud Service1-1. About Database Classic Cloud Service Database Deployments1-2. Oracle Database Software Release1-3. Oracle Database Software Edition1-3. Oracle Database Type1-4. Computing Power1-5. Database Storage1-5. Automatic Backup Configuration1-6
viii Related Documentation The platform-specific documentation for Oracle Database 10g products includes the following manuals: Oracle Database - Oracle Database Release Notes for Linux Itanium - Oracle Database Installation Guide for Linux Itanium - Oracle Database Quick Installation Guide for Linux Itanium - Oracle Database Oracle Clusterware and Oracle Real Application Clusters
Oracle Cloud Infrastructure Data Integration 5D992.c NLR Oracle Cloud Watch Dog EAR99 NLR Oracle Compute Cloud Service Bare Metal VMI EAR99 NLR Oracle Container Cloud Service 5D992.c NLR Oracle Container Registry Cloud Service 5D992.c NLR Oracle DataFox Cloud Service 5D992.c NLR Oracle
Visit cloud.oracle.com for information on our free 30-day trial, and visit our Oracle Data Visualization Cloud Service web page. Connect. Oracle Events Oracle Blog Get Social. Twitter: Oracle Cloud Zone Facebook: Oracle Cloud Computing LinkedIn: Oracle Cloud Solutions YouTube: Oracle Cloud Computing Qualogy Leverages Data Storytelling
Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,
Cloud Database Battle: AWS vs. DIY vs. Oracle Cloud Database Premises The first premise of this research is that architecting the Oracle Cloud Database service to run on specialized hardware and software, either on-premises or in Oracle Cloud Infrastructure (OCI), allows the cloud database vendor to reduce costs significantly.
Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,
2 Installing Oracle Database and Creating a Database 2.1 Overview of Installing Oracle Database Software and Creating a Database 2-1 2.1.1 Checking Oracle Database Installation Prerequisites 2-2 2.1.2 Deciding on Oracle Database Installation Choices 2-3 2.1.2.1 Install Option for Oracle Database 2-3 2.1.2.2 Installation Class for Oracle .
Level 4 IS Business Analyst Minimum Standards and Grading Criteria This paper defines the minimum requirements for the knowledge, skills and behaviours defined in the standard, which are required for a pass. It also defines the criteria to be used for awarding the grade for merit or distinction. This paper should be read in conjunction with the Standard and Assessment Plan for the Level 4 IS .
