Note:

• This tutorial requires access to Oracle Cloud. To sign up for a free account, see Get started with Oracle Cloud Infrastructure Free Tier.
• It uses example values for Oracle Cloud Infrastructure credentials, tenancy, and compartments. When completing your lab, substitute these values with ones specific to your cloud environment.

Provision Oracle Autonomous Database in Oracle Database@Google Cloud

Introduction

In this tutorial, we will go through the entire process of provisioning an Oracle Autonomous Database in Oracle Database@Google Cloud.

Note: As with all your Google Cloud projects, use your specific resource naming convention and tagging to help you identify your project resources.

Objectives

• Provision Oracle Autonomous Database in Oracle Database@Google Cloud. Place it in your desired resource group and Google Cloud region, and configure it according to your requirements.

Prerequisites

• Access to Google Cloud, OCI tenancy, and Oracle Database@Google Cloud.

• A Google Cloud project.

• A Google Virtual Private Network (VPC).

Create an Oracle Autonomous Database in Oracle Database@Google Cloud

1. Go to the Google Cloud Console and navigate to Oracle Database@Google Cloud.

   

2. Click Autonomous Database and + CREATE.

   

3. In the Instance details section, enter the following information.

   • Instance ID: Enter the instance ID. ID is permanent.

   • Database name: Enter the database name. The name must contain only letters and numbers, starting with a letter. Max 30 characters.

   • Database display name: Enter a user-friendly database display name.

   • Region: Select the Region. Region choice is permanent.

   

4. In the Workload configuration section, select the preferred workload type from the choices listed.

   • Data Warehouse
   • Transaction Processing
   • JSON
   • APEX

   

5. In the Database configuration section, enter the following information.

   • License type: Select the license type from the two choices available.

     • License included
     • Bring your own license

   • ECPU count: Enter the ECPU count with a minimum of 2 and a maximum of 512.

   • Select Enable compute auto scaling, to allow the system to expand up to three times the specified ECPU count as demand increases.

   • Storage (TB): Enter the storage with a mininum of 1 TB and a maximum of 384 TB.

   • Select Enable storage auto scaling to allow the system to expand up to three times the reserved storage.

   

6. In the Backup retention section, enter the desired number of days for the backup retention period. Minimum 1 and maximum 60.

   

7. In the Administrator credentials section, enter the desired Password and confirm it in the second field.

   The default administrator user for an Autonomous Database is ADMIN.

   Note: Password must be 12 to 30 characters and contain at least one uppercase letter, one lowercase letter, and one number. The password cannot contain the double quote (“) character or the username “admin”.

   

8. In the Networking section, enter the following information.

   • Network project: Select the appropriate network project.

   • Associated network: Select the associated network of VPCs.

   • Subnet range: Enter the subnet range for your Oracle Autonomous Database in CIDR notation. Ensure the provided range does not overlap with the subnets in the selected VPC networking above.

   • Select Require mutual TLS (mTLS) authentication. If enabled, mTLS will be required to authenticate connections to your Oracle Autonomous Database.

   Note: TLS connections allow you to connect to your Oracle Autonomous Database without a wallet, if you use a JDBC thin driver with JDK8 or above. TLS connections require you to use an access control list (ACL) or private endpoint.

   

9. In the Operational notifications and announcements contacts section, enter an email address and click + ADD CONTACT to enter more email addresses.

   

10. In the Advanced settings section, enter the following information.

    • Patch level: Select the patch level.

      • Early
      • Regular

    • Character set: Select the right character set for your needs. The AL32UTF8 character set is recommended by default.

    • National character set: Select the national character set. AL16UTF16 is selected by default.

    

11. View status of submitted Autonomous Database request

    

12. Access the Autonomous Database Details

    

Related Links

• Accelerating cloud transformation with Google Cloud and Oracle

• Oracle on Google Cloud

• Oracle Autonomous Database

• About Autonomous Database Workload Types

• Oracle Autonomous DatabaseTechnical Overview

Acknowledgments

• Author - Anwar Belayachi (Senior Principal Solution Architect - OCI Multicloud)

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.

---

Title and Copyright Information

Provision Oracle Autonomous Database in Oracle Database@Google Cloud

G14194-01

September 2024

Copyright ©2024,

Oracle and/or its affiliates.