Virtual Linux systems using the Windows system Oracle Database

Premise: The local Oracle database is working properly.

Database: Oracle 11g

Virtual machine: vmware_workstation_full_12.5.2

Native System: Windows 7 Ultimate Edition

Virtual machine system: OpenSUSE LINUX

Network adapter The IP address of the VMware networks Adapter VMnet8 and the IP address of the virtual machine system can ping each other on the same network segment

VMnet8 IP:192.168.14. 1

Virtual machine IP:192.168.14. 131

Windows ip:192.168.1.111

Ping Linux system 192.168.14.131 in Windows can ping the

Ping Windows system 192.168.1.111 in virtual Linux can also ping the

The database can be used normally in Windows, and Plsql can connect properly.

However, the virtual machine is an Oracle database that cannot connect to Windows.

Attempt to telnet 192.168.1.111 1521 connection failed in Linux

In window, try Telnet 192.168.1.111 1521 cannot open the connection to the host on port 1521 ....

Here, the preliminary judgment is the reason for the firewall. Using commands to view netstat-a

Found the reason: The connection is limited to 127.0.0.1 that is the local connection, check the data found that the monitoring error, when the listener is set to localhost, this situation will occur

WORKAROUND: Simply change the listener to the name of the host

Locate the Listener.ora file for H:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN under the Oracle installation directory

Will

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
)

Switch

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = PC201701061306) (PORT = 1521))
)
)

Where PC201701061306 is the name of the machine.

attempt to telnet 192.168.1.111 1521 connection succeeded in window .

Virtual Linux systems using the Windows system Oracle Database