My Session at Oracle AI World: KNEX - Autonomous Database Journey

My Session at Oracle AI World: KNEX - Autonomous Database Journey

From this year onwards, Oracle has rebranded its flagship annual conference — Oracle Cloud World — to Oracle AI World, reflecting the company’s strong focus on Artificial Intelligence and its deep integration across Oracle products and solutions.

I was glad and truly honored to be part of this prestigious global event — not just as an attendee, but as a speaker representing real-world expertise and customer success stories.

My session, titled “Oracle Autonomous Database Best Practices and Lessons Learned: Customer Panel,” drew a full house of participants eager to explore practical insights and proven approaches for maximizing the value of Oracle Autonomous Database. The discussion was vibrant, with attendees keen to understand how AI-driven automation and optimization are transforming data management and performance tuning.

It was an incredible experience to share the stage with industry experts, exchange ideas, and connect with professionals from around the world — all united by the vision of making data smarter with AI.

I had covered following key topics:

- Our development use cases

- Evaluation criteria for adopting Autonomous Database

- Building blocks of our architecture

- Key lessons learned and takeaways from our implementation journey

It was an honor to co-present alongside Holger Friedrich, Sreedhar Mohan, Amar Kumar, and Peter Merkert, who shared their valuable experiences with the audience.

A truly amazing experience at Oracle AI World — learning, connecting, and exchanging ideas with the global community.

Many thanks to Vivek Sharma and Reiner Zimmermann for the opportunity to share our story on such a prestigious global platform.

Special thanks to Basheer Khan and Hadi Syed Abdul for all their continuous support throughout this journey.

Thanks & Regards,

Chandan Tanwani

Create Autonomous Database (ATP) with Priavte EndPoint

Create Autonomous Database (ATP) with Private EndPoint

As you know ATP database is a PaaS service, you will only get the hostname of the ATP database. Whatif we need the IP address of the ATP database. One scenario for this requirement is to set ATP as a backend set in a public load balancer. How do we keep the ATP database as a backend set in a public load balancer? It is not possible without Private endpoint IP as on date. You must require a private endpoint IP address to add as a backend set of load balancer.

I will cover the following things in my blog,

1) Create ATP database with private endpoint.

2) Create Public Load Balancer and Configure with ATP database as Backend set.

3) Configure Networking security rules to access ATP via Load Balancer.

In this blog, I am covering, "Create ATP database with private endpoint." 1st point only. 2nd and 3rd point will be seen in separate blogs articles respectively. 

Let's start,

Click on Create Autonomous Database button.

Enter Compartment Name = cbtrm

Provide Display Name = CBTATP

Database Name = CBTATP

You can choose different display name and database name. I am giving the same for both the fields for simplicity purposes.

As of date there is only one option available to choose for the database version i.e. 19c

Here minimum ECPU count is 2 and storage is 1024 gb.

Backup retention you can change. But I kept the default one.

Provide password for admin user.

And now in the Network access section. Choose "Private endpoint access only", select your VCN and Private subnet from the dropdown list.

Now, choose the license option.

I kept other things as default settings. Nothing changed. Below screenshots are for your reference only.

This is it. 

Click on "Create Autonomous Database" button

It will take 2-3 minutes to create Autonomous database.

You can see the ATP database is nor provisioned. 

You should note couple of things, like, Database Name, Resource aloocation, Network (here you can see the private endpoint IP address), backup etc.

In next section we will see how to connect to the ATP database using cloud shell and SQL Developer.

Hope this article will help you.

Thanks & Regards,

Chandan Tanwani