-1

I have Oracle 12c installed on a windows server 2016 in Azure. I have a database populated locally, and need to access it remotely. I have allowed following through firewall within the machine:

\dbhome_1\bin\oracle.exe
\dbhome_1\bin\tnslsnr.exe

I need to access this database over sql developer on a remote machine. How do I know which ports to allow over the network security group?

David Makogon
  • 69,407
  • 21
  • 141
  • 189
Shantanu Pandey
  • 59
  • 3
  • Which ports does Oracle require? I'd guess that ports are pretty well documented by Oracle. And a quick web search for `"oracle 12c ports"` turns up quite a bit... – David Makogon Sep 17 '17 at 12:55
  • I've already added 1521 and 5500 in both the local firewall and azure management portal, but still not able to connect remotely – Shantanu Pandey Sep 17 '17 at 13:33
  • @ShantanuPandey If you only want to use PLSQL to connect your sql, you need open port 1521(by default). Do you check your instance is running or your listener is listening? – Shui shengbao Sep 18 '17 at 02:22

1 Answers1

1

How do I know which ports to allow over the network security group?

Please refer to this link.

According to your description, I think you want to use function SQL*Net 2, you need open port 1521(by default) on Azure NSG and Widows firewall.

Currently, you need check your instance and listener is listening. Please use lsnrctl

lsnrctl status [listener_name]

You also could use tnsping to test connection.

Also, you should check netstat -ant|findstr 1521. Please ensure the port is listening on 0.0.0.0.

Shui shengbao
  • 18,746
  • 3
  • 27
  • 45