Various Tutorials
  • About
  • Tutorials
    • 1. Instance for deployment
      • Create instance
      • Install and configure OCI CLI
      • OCI CLI small test
      • Install and configure Terraform
      • Terraform - small test
    • 2. OCI Networking &Terraform
      • 2.1 VCN (basics)
        • 2.1.1 Create a virtual network using Start VCN Wizard
        • 2.1.2 VCN & public subnet (step-by-step in Terraform)
        • 2.1.3 VCN & public subnet (new compartment)
        • 2.1.4 VCN, Terraform and Ansible (Nginx example)
        • 2.1.5 VCN & private subnet (step-by-step in Terraform)
      • 2.2
      • 2.3
    • 3. Untitled
    • 4. Untitled
    • 5. ATP and APEX
      • Setup Autonomous Database
        • Deploying ATP using OCI Interface
        • Deploy with OCI CLI
      • Setup APEX on ATP
      • Connect remotely to ATP
      • ATP, APEX and Jupyter
      • Demo
    • 6. MySQL
      • 6.1. The basics - OCI UI (MySQL DB System)
      • 6.2 The basics - OCI CLI (MySQL DB System)
      • 6.3 Access MySQL DB System
      • 6.4 HeatWave and MySQL DB Service
      • 6.5 Python SDK
      • 6.6 MySQL Replication (Compute Instances)
      • 6.7 Monitoring MySQL instances
        • Deploy MySQL instances
        • Monitoring tools
          • 1. Networking setup
          • 2. Prometheus setup
          • 3. MySQL Prometheus Exporter Setup
          • 4. Grafana setup
          • 5. Grafana metric graphs
    • 7. MySQL OCI &Terraform
      • 7.1 Deploy MySQL DB System with Terraform (basic tutorial)
      • 7.2 Deploy MySQL DB System with Terraform and access the system
      • 7.3 Endpoints
      • 7.4 Channels (troubleshooting)
        • Fixed MySQL source - MDS replication
      • 7.5 Channels (code)
Powered by GitBook
On this page
  1. Tutorials
  2. 5. ATP and APEX
  3. Setup Autonomous Database

Deploying ATP using OCI Interface

PreviousSetup Autonomous DatabaseNextDeploy with OCI CLI

Last updated 4 years ago

This is a very simple and straightforward example of how to set-up an Autonomous Database in Oracle Cloud.

Prerequisites: an Oracle Cloud account

1) Right from the Oracle Cloud page, as soon as you login, at "Get Started", proceed to expand "Quick Actions":

2) Select "Create an ATP database"

3) Select compartment where to create the database (in this case, the tenancy - the root compartment); provide a display and database name

4) Choose the deployment type, and make sure you configure the database to "Always Free".

When you choose the deployment type as "Always Free", your OCPU and Storage are automatically set-up, without the option of implemeting changes:

5) Choose a password for your "ADMIN" username.

6) Set-up a preferred type of access and license:

7) Once you have provided all the details, proceed to creation, by clicking "Create Autonomous Database"

8) As you as you click "Create Autonomous Database", you will be sent to the Provisioning page. The status of your database will be in "Provisioning" status as long as it is deployed and prepared.

9) Once your database is ready to to be used, the status will become "Available", and you will have access to certain tools:

SQL Developer

The ATP database is deployed with am SQL Developer Web. This allows you to access your instances and data.

For a Set-up, go to Tools, and select "Open SQL Developer Web". From there, you are sent to a page where you have to provide the ADMIN credentials you have setup earlier when deploying the ATP database

If no errors, you will be prompted to the SQL developer working environment (running a query just for testing):