In this section, we will see how to provision ATP database in Oracle cloud infrastructure (OCI). We need to follow below steps to create ATP database in OCI.

Login to your OCI account.

Go to Navigation Menu —>Oracle Database —–>Autonomous Database

Click on Create Autonomous Database.

Provide required details.

Provide ADMIN credentials as shown above.

Click on Create Autonomous Database.

It will take some time to create ATP database, refresh page. Once available, status will change to “AVAILABLE”.

Now let us connect this ATP database from SQL Developer.

To connect ATP database from SQL developer, we need to download wallet for this ATP database.

Go to Database Connection as shown below:

Select “Instance Wallet” and click on Download wallet.

Provide and confirm password and click on download.

It will download zip file.

Now open SQL developer and click on New Connection.

Provide any Name as Connection Name.

We need to provide same password which we have given while downloading wallet from OCI.

Configuration file will be wallet zip file which we have downloaded from OCI.

We can select Service as learningatpdb_high.

Click on Test.

Click on Connect to connect the DB.

In this way, we can provision ATP database in OCI and connect it from SQL developer.