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