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, select 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, select Inbound Rules.
-
In the Action panel on the right, select New Rule.
The New Inbound Rule Wizard appears.
-
On the Rule Type page, select Port and then select Next.
-
On the Protocol and Ports page, select TCP.
-
Select Specific local ports, and then type 1521. Select 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 select 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. Select Next.
-
On the Name page, type Oracle Listener Port as the name for the port exception. Optionally, you can type a description.
-
Select Finish.
-
In the center of the Inbound Rules panel, verify that the new exception name appears.