Outbound network traffic setting example for BigAnimal cluster with private connectivity

Description 

At this article, there are step by step instructions of how to set up dblink to remote Oracle server for EnterpriseDB PostgreSQL Advanced Server (EPAS) cluster with private network connectivity at BigAnimal in Azure.

It shows an example of how to configure the outbound network traffic setting for BigAnimal cluster using Azure private endpoint and private link service.

Prerequisite

1. Private EPAS cluster on BigAnimal

2. Oracle database on Azure VM within private network

3. A load Balancer within the Oracle server subnet

4. A private link service within the Oracle server subnet

5. Private endpoint created on Azure for BigAnimal EPAS cluster 

Network settings to create dblink to access remote Oracle database from EPAS cluster at BigAnimal

Step 1: Create Load balancer

• Basic :

1. Select the same resource group which we have been used while creating the Virtual machine on which the oracle database is deployed.

2. SKU will be ‘Standard’.

3. Type should be Internal

4. Region should be identical to the region where the oracle virtual machine has been deployed

• Frontend IP configuration:

Click on ‘+Add a frontend IP configuration’ to add frontend IP configuration.

Virtual Network should be a virtual machine’s Virtual network/subnet where Oracle database is deployed.

     

After adding configuration it will be listed out as given below.

• Backend pools

Click on ‘+ Add a backend pool’

Click on ‘+Add’ button to add the virtual machine on which the oracle database is deployed.

Backend pool is added as given below

• Inbound rules

Click on ‘Add a load balancing rule’

Create health probe

You will need to add an oracle port here. If the port gets changed you will need to create 

a health probe with the changed port.

After adding ‘Load balancing rule’ it will be listed out in Inbound rules

• Review + create

Step 2: Create private link service

• Basics:

1. Select the same resource group which we have used while creating Virtual machine on which oracle database is deployed.

• Outbound settings

1. Select the Load balancer and Load balancer frontend IP address as  created above.

• Access security

• Review + create

Step 3: Create private endpoint

• Basics

1. Resource group should be associated to pg cluster virtual machine

• Resource

1. Copy alias from overview of private link service created above.

• Virtual Network

1. Select virtual network as EPAS virtual network.

• Review + create

Step 4: Approve private link service

1. After selecting the private link service from Private Link Center -> Pending connections, click on ‘Approve’ to approve the link service.

       2. Refresh the page to see the updated status in Private Link Center -> Private link services.

       3. Also can check the connections approved through Private Link Center -> Private endpoints.

Step 5: Check for dblink

Connect to EPAS database and create dblink for oracle database on private virtual machine.

To overcome above issue you will need to set ‘Inbound port rules’ in 

Virtual machine -> Networking

Recheck for dblink.