How to connect a local VM Oracle from an Azure Linux VM?

Question

How to connect a local VM Oracle from an Azure Linux VM?

Scott Yang 0

I created an Azure Red Hat Enterprise Linux 8.7 (Ootpa) VM running on Azure Japan East POD.

In my laptop, I have started one local Window VM with Oracle running using portal 1521 for client access.

I want remotely send request from Azure Linux VM to my local Window VM to access that Oracle.

Could you tell me how can I setup the Outbound port rules based on that Azure Vmware?

Thanks a lot.

Scott

Rashid Ali 0 Reputation points

2023-05-19T00:28:51.4666667+00:00
To set up outbound port rules on your Azure Red Hat Enterprise Linux (RHEL) VM, you can follow these steps:

Identify the port number used by Oracle for client access on your local Windows VM. In this case, you mentioned port 1521.

Go to the Azure portal (portal.azure.com) and navigate to your Azure VM.

Click on "Networking" in the left-hand menu.

Under "Settings," click on "Network interfaces."

Select the network interface associated with your Azure RHEL VM.

In the network interface settings, click on "Network security group."

On the network security group page, click on "Inbound security rules."

Click on "Add" to create a new inbound security rule.

Configure the inbound security rule as follows:

Source: Select "IP Addresses" and enter the IP address range of your local Windows VM or select "Any" to allow connections from any IP.

Source port ranges: Leave this as "*" to allow connections from any source port.

Destination: Select "Any" to allow connections to any destination IP.

Destination port ranges: Enter the port number used by Oracle (1521 in this case).

Protocol: Select "TCP" as Oracle typically uses TCP for client connections.

Action: Select "Allow" to allow the inbound connections.

Priority: Set an appropriate priority value to determine the order of evaluation if there are multiple rules.

Click on "Add" to create the inbound security rule.

Once the rule is created, it will allow outbound connections from your Azure RHEL VM to your local Windows VM on the specified port (1521).

Please note that these steps assume you have already set up the necessary network connectivity between your Azure RHEL VM and your local Windows VM, such as establishing a VPN or ensuring proper network configuration.

Additionally, make sure to review and apply appropriate security measures to protect your Oracle database and consider the implications of opening the specified port for inbound connections.

Remember to consult Azure documentation or seek professional guidance for specific Azure networking configurations and security best practices.
Scott Yang 0 Reputation points

2023-05-20T04:02:06.79+00:00

Thanks for the guide. But it does not work.

2 answers

Your answer

Scott Yang 0 Reputation points

2023-05-20T04:02:06.79+00:00

Thanks for the guide. But it does not work.

Answer 1

deherman-MSFT 38,021 Microsoft Employee Moderator

@Scott Yang

You have a Red Hat VM running on Azure VMware solution and want to allow outbound internet access to your local VM on port 1521. Let me know if I am misunderstanding the issue.

You can enable outbound access in Azure for VMware by configuring Outbound Internet access using Managed SNAT in the Azure portal. Here are the steps:

Log in to the Azure portal and then search for and select Azure VMware Solution.
Select the Azure VMware Solution private cloud.
In the left navigation, under Workload Networking, select Internet Connectivity.
Select Connect using SNAT button and select Save.

Hope this helps. Let me know if you have any questions or issues.

If you still have questions, please let us know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts.

If the answer has been helpful, we appreciate hearing from you and would love to help others who may have the same question. Accepting answers helps increase visibility of this question for other members of the Microsoft Q&A community.

Thank you for helping to improve Microsoft Q&A!

User's image

Scott Yang 0 Reputation points

2023-05-19T00:14:54.9+00:00

@deherman-MSFT

Thanks for your quick response.

My Request Is: I am going to install an Oracle client in Azure Linux VM. Then use Oracle client to access to a on-premise local Oracle DB which is in running in my laptop VMware.

The Azure Linux Public IP looks like 20.222.a.b

And my Laptop Vmware Public IP looks like 111.192.x.y.

Now, from Azure Linux, I cannot ping 111.192.x.y any portal. So that I cannot use Oracle client to access that on-Premise Oracle DB.

I need the connectivity between 20.222.a.b and 111.192.x.y is open so that I can access Oracle DB from Azure Linux and also read the data out of Oracle DB and back to Azure Linux VM.

Here are the result following up your suggestion.

1. Log in to the Azure portal and then search for and select Azure VMware Solution.

Scott: there is no available "Azure VMware Solution private cloud" I can select. Should I click "Create" button?

**

**

2.I tried to create "Azure VMware Solution private cloud"

Scott: I am using a Azure Free Trail Subscription. I am facing the "Insufficient Quota for the chosen combination of Subscription and Location. Please make sure selections for both fields are correct." issue.

How can I successfully to create an Azure VMware Solution private cloud?

And whether creating "Azure VMware Solution private cloud" is mandatory for my case?
Scott Yang 0 Reputation points

2023-05-19T00:49:03.8466667+00:00

@deherman-MSFT

I also tried Outbound Rules below to allow 1521 port communication for Any source IP and Any target IP.

And I also disabled the Window system firewall in my local Window VM.

But it still does not work.

Does "Setting Outbound Rules" and Disable Window System Firewall can help for this case?

Thanks,

Scott

Answer 2

deherman-MSFT 38,021 Microsoft Employee Moderator

@Scott Yang

I think there was some confusion since you marked this as Azure VMware Solution. From your screenshots it looks like you have a normal Azure Linux VM and you are not using Azure VMware. Your network security group already has an outbound rule which allows all outbound traffic to the internet.

The issue is likely with the VMware configuration on your laptop. Please ask your question on the VMware Community forum. The experts there should be familiar with the configuration and be able to assist you.

Scott Yang 0 Reputation points

2023-05-20T04:02:29.3033333+00:00

Thanks a lot for your help and guide.

Share via

How to connect a local VM Oracle from an Azure Linux VM?

2 answers

Your answer