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
  • Setup APEX
  • Create applications
  1. Tutorials
  2. 5. ATP and APEX

Setup APEX on ATP

PreviousDeploy with OCI CLINextConnect remotely to ATP

Last updated 4 years ago

Prerequisites: an Oracle Database of which version is compatible with APEX

Before we proceed to Setting up the APEX, check "Setup Autonomous Database".

Setup APEX

We have just created an ATP database, named "testing".

1) Let's go to the Menu, and select "Autonomous Transaction Processing"

2) Select the name of the database from "Display Name"

3) Go to "Tools", and select "Open Apex"

4) Provide the password of the ADMIN user you have setup for your ATP database:

5) Proceed to "Create Workspace":

6) Provide a database user, a password for it, and a workspace name:

You will be sent to this page, "Administration Services". If you take a look at the upper message, you need to sign out in order to access your workspace

7) Sign out... and sign in...

If you go to your SQL Developer Page, you will notice that ZACK user (or the user you have chosen) has been created.

Create applications

8) Now you have access to "App Builder", "SQL Workshop", "Team Development" and "App Gallery"

9) To create your first application, go to "App Builder":

... select "Create a New App"

And from there, you are sent to three option of how to build that new App: