The Windows Firewall state is On by default to block incoming connections on most TCP network ports. As a result, an Oracle client reports errors when it requires an incoming connection from an Oracle server. You must adjust the Windows Firewall settings after installing Oracle client software to allow exceptions for the needed incoming connections.
If the Windows Firewall state is Off on the Oracle client, then you do not need to change the configuration.
Open the Windows Firewall Control Panel
-
Open Windows Firewall.
The Windows Firewall control panel appears.
-
In Public networks, verify that the Windows Firewall state is On.
-
In Control Panel Home, click Advanced settings.
The Windows Firewall with Advanced Security management console appears.
Add an Exception for the Oracle Listener Port
-
In the left panel of the Windows Firewall with Advanced Security management console, click Inbound Rules.
-
In the Action panel on the right, click New Rule.
The New Inbound Rule Wizard appears.
-
On the Rule Type page, select Port and then click Next.
-
On the Protocol and Ports page, select TCP.
-
Select Specific local ports, and then type 1521. Click Next.
The default Oracle listener port is 1521. Your network configuration might require
a different port number.
-
On the Action page, select Allow the connection and then click Next.
-
On the Profile page, select the needed options for Domain, Private, and Public, as required by your network configuration and allowed by the security policy of your company. Click Next.
-
On the Name page, type Oracle Listener Port as the name for the port exception. Optionally, you can type a description.
-
Click Finish.
-
In the center of the Inbound Rules panel, verify that the new exception name appears.