CODEWITHSUNDEEP
oracle-databaseazurecloudvirtual-machine
Terchila Marian
Terchila Marian

Reputation: 2520

Configure Oracle Virtual Machine on Azure

I'm trying to deploy an Oracle database on a virtual machine which is hosted on azure. So far I have been following their documentation

https://learn.microsoft.com/en-us/azure/virtual-machines/workloads/oracle/oracle-database-quick-create

I did everything step by step as they say over there, but ultimately I can't connect to it no matter how much I try it says request time out.

Strange thing is that I am able to ssh into it, but I can't access the database. I would like to mention that according to their documentation I forwarded the ports as shown below. I got no clue why exactly is not working. enter image description here

Upvotes: 1

Views: 623

Answers (2)

mlunap
mlunap

Reputation: 61

I had the same problem with the database, but I solved it by editing the listener.ora file. Change "(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))" to "(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))". enter image description here

Don't forget to restart the server.

Upvotes: 0

Nancy Xiong
Nancy Xiong

Reputation: 28224

The recommended value for the source port ranges is *, it means any. Inbound Port filtering is mainly used with the destination port ranges. It's the same configuration for port 1521,5502. You can change the source port ranges from a specific port to *

If it's still no luck, you need to verify if outbound traffic to these ports is allowed from your local machine or corporate company firewall. For example, run the PowerShell command on your local machine Test-NetConnection -ComputerName 13.92.x.x(VM pip) -Port 5502

Also, you need to make sure the database is startup before you want to connect to it.

It works on my side by full following that quick guide. enter image description here

NSG configuration

enter image description here

Upvotes: 1

Related Questions