I am trying to connect to my VM which is running Oracle Database XE 18c on Oracle Linux 7.6 and using bridged networking through Oracle SQL developer, however I have found no luck.
I have permanently allowed the Oracle Listener port (1521) through my interface's zone in FirewallD, disabled iptables and set SELinux to permissive.
The Oracle Database services on the server itself are fine and it seems all OK, but when I try to connect to my server (which is running on the LAN) through Oracle SQL Developer, I get this:
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection
So, I tried using nmap
to determine if the port on the host was opened or closed, and I got this back:
Host is up (0.0024s latency).
PORT STATE SERVICE
1521/tcp filtered oracle
Pinging the server works fine, it is only this port that remains blocked even when allowed through the system's firewall and SELinux. When capturing the packet being returned in Wireshark, I see this:
Destination unreachable (Host administratively prohibited)
So, my guesses are that the connection is definitely going through, but something somewhere is preventing it from continuing and I don't know what it is.
Note: For reference, I followed this tutorial to set up Oracle Database on my server, and I'm using a standard NBN carrier/home grade internet service if that helps.