If you've been battling with Windows Firewall to enable a client connection to an Oracle database then I feel your pain. You've probably figured out that you need to enable port 1521 (the default connection port) but it still doesn't seem to do anything. However after I read this post it all became very clear.
Basically when a client makes its initial connection to the listener (via port 1521), the listener spawns a new user process that uses a random port to handle the client's request. If it's a random port then we can't define it in a firewall rule, however we can add the programs themselves.
Click Add Program... and create a rule for both oracle.exe and tnslsnr.exe located in <your_oracle_directory>/bin
0 comments:
Post a Comment