How to Provision Autonomous Database Service in Oracle Database@Google Cloud

 

 How to Provision Autonomous Database Service in Oracle Database@Google Cloud

 

Introduction

Provisioning- and basic management functions for Oracle Autonomous Database instance is done from the Oracle Autonomous Database@Google Cloud. Additional management functions are available within the Oracle Cloud infrastructure portal via the link that Oracle Autonomous Database from Oracle Autonomous Database@Google Cloud Console.

We are going through the process of provisioning and Oracle Autonomous Database in Oracle Database@Google Cloud.

 

Acknowledgements:

-         Author: Donatien Mbadi Oum, Oracle Cloud Architect, Senior Database Administrator

-         Last update: Août 2025

 

 

Prerequisites:

-         Access to Google Cloud, OCI tenancy and Oracle Database@Google Cloud

-         A Google Cloud Project

-         A Google Virtual Private Network (VPC) and Subnet

Note: In this guide, we are going to allow connection to the database from anywhere,

Step1: Open your Google Cloud and click on Console to connect

 

Step2: Select your Google Project

 

 

Step3: From your Search page, Navigate to Oracle Database@Google Cloud:

 

Step4: Click on Explore service under Autonomous Database.

 

 

Step5: On Autonomous Database page, click on Create.

Step5: Provide the details

-         Instance details

o   Instance ID

o   Database name

o   Database display name

o   Region

Note: Parameters Instance ID, Database name and database display name can be different.

-         Workload configuration details:

You have option to select Data Warehouse, Transaction Processing, JSON or APEX

 

 

-         Database configuration

 

-         Backup retention

-         Administrator credentials

Provide your database administrator password

-         Networking

We choose to access to the database from anywhere

-         Click on Create

-         The database is now created

 Step6: Database connection

-         Click on your database display name and click on Connections

-         Download the Wallet

-         Set a password for the wallet and Download

Step7: Connect to your Database

-         To connect to the database, we are using SQL Developer.

-         Right click on Oracle connections and the click on New connection

-         Connection parameters:

Provide:

o   Connection Name

o   Username and password (Admin user)

o   Connection type (Cloud Wallet) and select your downloaded wallet zip file

- Test the Database connection

Click on Connect, create an database tables and insert data