How to get started with Oracle Autonomous Database on Oracle Database@Google Cloud

September 19, 2024 | 5 minute read
Tony Politano
Distinguished Engineer
Tammy Bednar
Senior Director of Product Management
Text Size 100%:

Oracle Database@Google Cloud, part of Oracle’s multi-cloud portfolio, enables applications running in Google Cloud regions to use Oracle Exadata Database Service and Oracle Autonomous Database as Oracle Cloud Infrastructure (OCI) resources collocated in the same regions. Google Cloud applications and services such as Looker and Vertex AI can now have low-latency, native access to Oracle databases running on Exadata Cloud Infrastructure and take advantage of Oracle Database 23ai features like AI Vector Search.

A previous blog explored setting up Exadata Database Service on Google Cloud.  We will now review setting up an Oracle Autonomous Database on Google Cloud.  Both the Exadata Database Service and Autonomous Database run on an Exadata platform, with Autonomous Database offering complete automation and value-added capabilities - including automatic patching, security, backup, and a suite of tools for developing apps, integrating, and analyzing data. Both Exadata Database Service and Autonomous Database include dozens of unique features that deliver differentiated capabilities for OLTP, analytics, AI, mixed workloads, and database consolidation.

Tight integration between the Google Cloud Console and OCI lets you get started faster and launch an Autonomous Database in minutes without having to procure or deploy hardware, VM clusters, or storage.  As a serverless offering, when you launch an Autonomous Database in Google Cloud, Oracle handles the deployment, scaling, and securing of the underlying infrastructure so you can concentrate on building apps that use the database. Oracle Autonomous Database also automatically configures and executes backups for automatic data protection. All backup and recovery capabilities can also be handled via OCI console, API calls, or Command Line Interface (CLI).

Setting up Oracle Database@Google Cloud

Using Google Cloud’s public offer, your journey to running Oracle Autonomous Database on Google Cloud is activated with an Oracle subscription configured from your Google Cloud account or between existing Google Cloud and OCI accounts. Federating identities between these tenancies is accomplished by simply configuring permissions and roles. OCI automatically creates predefined groups with corresponding policies to grant access to all projects within your Google Cloud entitlement.

The Oracle Autonomous Database on Google Cloud architecture requires a Google Cloud project and a Virtual Private Cloud to provide networking for application resources within a Google Cloud region. Using the OCI managed network, the VPC application subnet connects to Oracle Autonomous Database on Google Cloud operating in an OCI child site collocated in the same Google Cloud region. Similar to Exadata Database Service, the subnets for Autonomous Database extend into the OCI tenancy VCN and are accessible to other resources in OCI.

Single Step Deployment

Launching an Oracle Autonomous Database in Google Cloud is a single-step process.  Using the console, you provide the required information (this is shown as multiple screenshots here, but is just a single screen when you use the console):

Enter your instance details, including region, and select the workload type for the database.

Add ADB Instance

Select your license type (included or BYO), database version (19c or 23ai), CPU and Storage size, backup retention period (defaults to 60 days), network, and subnet.

ADB GCP database information

Add a password for the Administrator and Create the database.

Create the database

Once created, you can examine or change the settings on the console.

Confirmation screen

Simplified multi-cloud

With Oracle Autonomous Database on Google Cloud, you can simplify multi-cloud management and operations with streamlined purchasing through the Google Cloud Marketplace using existing Google Cloud commitments. Tight integration between the Google Cloud Console and OCI lets you get started faster and have an Autonomous Database running in minutes. The Oracle Autonomous Database handles all maintenance and patching automatically.  In addition, Oracle Autonomous Database on Google Cloud is self-repairing. For example, self-repairing capabilities such as backups, recovery, patching, and failover within a database are accomplished by self-driving database attributes, which automate such processes. Similarly, self-securing capabilities such as end-to-end encryption, data validation, corruption identification, isolation, and repair are “always on” for the database and all backups.

architecture

Start Small, Scale Fast

Oracle Autonomous Database allows you to start with a single database to achieve immediate benefits, and you can rapidly scale to handle your entire database estate.  There is no need to procure or manage specific hardware or VM clusters, as Oracle manages the underlying Exadata infrastructure. 

Oracle Autonomous Database on Google Cloud also allows you to save money by taking advantage of Oracle Autonomous Datbase Elastic Pools.  Elastic Pools will enable you to consolidate the billing of your Autonomous Database in terms of their compute resource allocation and provide up to 87% cost savings. You can benefit by creating and using Elastic Pools when you need many databases that can scale up and down elastically without downtime.  Elastic Pools provide the financial benefit of consolidation without physically consolidating databases to a common frame, rack, or VM cluster.  With pool capacity shapes up to 4096 ECPU, customers can start with a pool capacity as low as 128 ECPU and scale up as needed.  Additionally, since Autonomous Databases do not need to be physically consolidated, you can combine the billing of production, development, and test databases to the same Elastic Pool, further driving down the total cost of ownership.

Summary

With Oracle Database on Google Cloud, your organization can now run mission-critical Oracle Database applications in Google Cloud. Oracle Autonomous Database on Google Cloud can provide a fully autonomous database running on Exadata, including self-patching, self-repairing, and self-securing.  You can easily migrate on-premises Oracle databases to Google Cloud. You can take advantage of the high availability, performance, and scalability of Oracle Autonomous Database on Exadata Cloud Infrastructure. With this new deployment option for Oracle Database, you can now combine applications and services running in Google Cloud with the advantages of Exadata Database Service and Oracle Autonomous Database.

 

Learn more about Oracle Cloud Infrastructure

Learn more about Oracle on Google Cloud

Learn more about OCI’s distributed cloud

Learn more about Oracle Database servicesOracle Autonomous Databaseand Oracle Exadata Database Service.

Learn more about Autonomous Database Elastic Pools.

Tony Politano

Distinguished Engineer

Tony is a Distinguished Engineer at Oracle. Tony's expertise includes Autonomous Database, Mulit-Cloud, Data Warehousing, DBaaS, and Exadata. He has published multiple books and articles on business and technology and was one of the original contributors to the Cloud Data Management Capabilities (CDMC) framework. He holds a B.S. in Computer Science, M.S. in Management and has completed Ph.D. work (ABD) at Stevens Institute in N.J. He also holds multiple Oracle, GCP and AWS certifications.

Show more

Tammy Bednar

Senior Director of Product Management

Tammy has worked in the computer industry for more than 26 years. Oracle hired her in the Database Support Organization 26 years ago and she has been involved with database releases since version 6.0.36. Tammy started her product management career with the database High Availability team with Recovery Manager (RMAN), database backup and recovery,  and Database Security development team, focusing on auditing, Oracle Audit Vault and Oracle Database Firewall, and Oracle Database Appliance. Tammy is an outbound product manager and focuses on the Exadata Database Cloud Services and Oracle Enterprise & Standard Database Services.

Show more

Previous Post

Oracle APEX Generative Development

Michael Hichwa | 8 min read

Next Post


Database Performance Tuning with PerfHub in AHF 24.9

Gareth Chapman | 8 min read
Oracle Chatbot
Disconnected