Oracle Autonomous Database is a cloud-based data platform that simplifies database management by automating routine tasks like backups, patching, and tuning. One of the most popular flavors of this service is Autonomous Transaction Processing (ATP), optimized for OLTP workloads such as financial, retail, and business applications.
In this blog post, I’ll walk you through the steps to create an ATP Database instance in Oracle Cloud Infrastructure (OCI).
🚀 Prerequisites
Before you begin, ensure you have:
-
Access to Oracle Cloud console (https://cloud.oracle.com)
-
Necessary permissions to create database and network resources
-
A VCN (Virtual Cloud Network) and subnet in place (or permission to create one)
🛠️ Step-by-Step Guide
Navigate to https://cloud.oracle.com and sign in with your credentials. After successful login you will be redirected to Oracle Cloud Console Homepage.
From the Oracle Cloud Console, open the Navigation Menu and go to Oracle Database. Under this section, select Autonomous Database to proceed with creating a new instance.
Autonomous Databases screen will appear. Click on Create Autonomous Database button to start creating the ATP DB instance.
Create Autonomous Database Serverless screen will appear. Enter the Display name, Database name for your new ATP Database. Also, select the workload type as Transaction Processing for creating ATP Database
Select the Always Free option to create Always Free ATP DB and then choose the version of database available from the list:
Enter the password for ADMIN user of the database, select the network access and then click on Create button
ATP Database will start provisioning and will take sometime
Once database provisioning is completed, click on Database actions and then select SQL
- Database Actions | SQL page will appear and logged in user will be ADMIN. Click on Run Statement button to run the displayed SQL query
Result of SQL query will be displayed
You can also run the other queries like below:
Now, go to cloud console again and click Navigation Menu → Oracle Database → Autonomous Database
You will see the ATPDB1 that we just created. Click on the name of Database
On this screen, click on Database Connection
Select the Wallet Type as Instance Wallet, and click on Download wallet button
Choose any secure password for the wallet and click on Download button
Wallet Wallet_ATPDB1.zip will be downloaded
Now, open SQL Developer and click on New Connection button
After providing these details click on Test button, once Test is success, then save the connection and click Connect button.
You can then run queries on this connected database:
Comments
Post a Comment