Hello,
I am using a Mac running OS X Yosemite (10.10.5). I have 2 VMs... Virtual box has Oracle Linux and a Parallels VM has Windows 7 Professional. I have 3 IP addresses (Linux 192.168.1.223; Windows 192.168.1.224; Mac 192.168.1.168) and I am able to ping each machine from the other. I have set up the bridge adapter for both VMs, selecting wifi and I'm trying to connect from my Windows VM to the Linux one. (Eventually I want to run Oracle software from Windows environment connecting to Oracle db on Linux environment). I have tried with the network promiscuous level set to deny, allow all VMs and allow all. I have tried to open up the firewall completely to make sure traffic is allowed to be passed from all ports (specifically interested in 22, 1521 for now) using :
iptables -P INPUT ACCEPT
iptables -P OUTPUT ACCEPT
iptables -P FORWARD ACCEPT
iptables -F
service iptables save
When I type "telnet 192.168.1.223 1521" from my Mac I get:
Elizabeths-MBP:~ emy$ telnet 192.168.1.223 1521
Trying 192.168.1.223...
Connected to lizlinux.fios-router.home.
Escape character is '^]'.
Connection closed by foreign host.
... and the listener log captures this:
2018-01-16T12:24:35.104166-05:00
16-JAN-2018 12:24:35 * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.168)(PORT=64706)) * <unknown connect data> * 12547
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
When I try to connect via SQL Developer from the Windows machine I get:
Status: Failure - Test failed: IO Error: An existing connection was forcibly closed by the remote host, connect lapse 359 ms., Authentication lapse 0 ms.
...and the listener log captures this:
16-JAN-2018 12:38:14 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=emy))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp) (HOST=192.168.1.224)(PORT=57279)) * establish * orcl * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
Both VMs can connect to the internet. The windows machine is able to connect to another client I have (through a Securelink connection) and the SQL Developer application can access their databases.
I'm not very knowledgable about networking. Do you have any suggestions of what I can do? Are there any websites with documentation that will help me?
Thanks!