Local LAN It machine Oracle database, "appear ora-12170:tns: Connection Timeout" error

Today, using the laptop's Plsql developer to connect to Oracle on another desktop in the LAN, the login process is slow, and then reports

Ora-12170:tns occurred: Connection timeout

Such a mistake, Baidu a long time to find a solution.

It is said that the window firewall does not allow Oracle to communicate with the outside, so you need to add an exception or exception port to the window firewall.

Another computer in my local area network (with Oracle) installs the Win7 system. The following settings will solve the problem.

Click "Start"-> "Control Panel"-> "Windows Firewall"-> "Advanced Settings"

Right-click above "Inbound Rules", select "New Rule"-> Select "Port, click Next-> Select" Specific local port "and enter 1521 port, click Next->

Select "Allow connection", click Next-> here to let it be selected by default, click Next-> input rule name, in order to see the name of the idea, here I entered is oralce_in_port, click Complete,

This completes the inbound rule.

It is also necessary to set up outbound rules just to set up an inbound rule that cannot be connected to another computer's Oracle from the LAN.

The setup of outbound rules is similar to the establishment of inbound rules, so this is no longer demonstrated here.

By completing the set of inbound rules and outbound rules, the normal script machine can connect to another Oracle database server in the local area network.