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
-
Private EPAS cluster on BigAnimal
-
Oracle database on Azure VM within private network
-
A load Balancer within the Oracle server subnet
-
A private link service within the Oracle server subnet
-
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 :
-
Select the same resource group which we have been used while creating the Virtual machine on which the oracle database is deployed.
-
SKU will be ‘Standard’.
-
Type should be Internal
-
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:
-
Select the same resource group which we have used while creating Virtual machine on which oracle database is deployed.
-
Outbound settings
-
Select the Load balancer and Load balancer frontend IP address as created above.
-
Access security
-
Review + create
Step 3: Create private endpoint
-
Basics
-
Resource group should be associated to pg cluster virtual machine
-
Resource
-
Copy alias from overview of private link service created above.
-
Virtual Network
-
Select virtual network as EPAS virtual network.
-
Review + create
Step 4: Approve private link service
-
After selecting the private link service from Private Link Center -> Pending connections, click on ‘Approve’ to approve the link service.