OCI - Creating a ATP Database instance

Create Database Instance

Continuing from my OCI series: Moving On-Premises Oracle Apex application to OCI Oracle Autonomous Transaction Processing

We will provision a 'Serverless deployment' instance of the database. 

• On the navigation menu on the left, select Autonomous Transaction Processing under Database
• Click "Create Autonomous Database"

• Compartment: Use default (for new accounts, you will need to provide a name)
• Display Name: Descriptive name for the database
• Database Name
• Workload Type: Select 'Autonomous Transaction Processing'
• Deployment Type: Serverless
• Configuration: Always Free
• (OCPU:1, Storage: .02TB-2GB)
• User Name/Password
• License Type: Included
• Tags

Create Database

The Create Autonomous Transaction Processing Database dialog closes. On the console, the State field indicates that the database is Provisioning. When creation is completed, the State field changes from Provisioning to Available.

For details see the official documentation here:

Provisioning Autonomous Transaction Processing

Now that the database is ready, let's connect to it:

OCI - ATP Database - Basic connectivity - SQL Developer
OCI-Oracle ATP- Connect via SQLPlus on Linux

Next: OCI-Oracle ATP- Import Data from on-prem

Sachin

Chief Architect
Oracle Apex Enthusiast
BuzzClan