Oracle Autonomous Database 23ai on Oracle Cloud
In my previous posts, I had demonstrated how you can configure Oracle Database 23ai Free on Oracle VM or on docker. In this post, we will see how we can configure Oracle Autonomous Database 23ai on Oracle Cloud free Tier. It is fairly simple to setup. So let’s jump into it together!!!
Once you have logged into you Oracle Cloud account, click on the Navigation Menu on the left-hand top corner and then click on Oracle Database. From the options available, click on Autonomous Database.
Database Creation
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-54.png?w=1800)
Now click on Create Autonomous Database.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-55.png?w=1800)
Provide a valid Database Name and Display Name.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-56.png?w=1267)
Select the workload type, here I will select Transaction Processing.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-58.png?w=1249)
Deployment Type will be selected as Serverless. From the drop-down, choose the database version as 23ai.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-57.png?w=1263)
Set the ADMIN user password.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-59.png?w=1234)
I will leave the default settings for the remaining options and click on Create Autonomous Database.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-60.png?w=1274)
It’ll take a few minutes for the instance to be provisioned.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-61.png?w=1637)
Once the instance is provisioned, you’ll notice that the status will be updated.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-62.png?w=1530)
That’s all the steps you need to follow to create 23ai instance up and running.
SQL Developer Setup
Once you have the database up and running, click on Database Connection and then click on Download Wallet.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-63.png?w=1800)
When prompted, provide the ADMIN password for downloading the Wallet.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-64.png?w=959)
Now, open SQL Developer, and add a new connection. Provide a valid connection name. Provide ADMIN username and password. Select Cloud Wallet for Connection Type. Browse and add the Wallet that you downloaded and click on Test.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-65.png?w=767)
Click on Connect and voila, you can now access Oracle Cloud ATP 23ai instance from SQL Developer.
![](https://blog.rishoradev.com/wp-content/uploads/2024/05/image-66.png?w=1527)
Happy learning!!!
Pingback: User Creation in ORACLE Cloud Autonomous Database 23ai | RishOraDev's Oracle Blogs
Pingback: Upload File from OCI Object Storage to Oracle ATP | RishOraDev's Oracle Blogs