Wednesday, November 15, 2006

Oracle: When Windows XP's Firewall blocks Oracle connection

When client try to make connection to the listener (default using port 1521), the listener spawn new user-process. This user process use random port to handle the client's request. Mainly, oracle use two main program, which are " oracle.exe" for oracle-instance, and "tnslsnr.exe" for listener. We can check it through "Task Manager"
Windows firewall support port and program exception. We use both to make exception in Windows-Firewall.

From Control Panel --> Windows Firewall :
1. "Add Port" => 1521
2. "Add Program => browse to the ORACLE_HOME/bin for " oracle.exe" and "tnslsnr.exe"

Ok, now try to reconnect your client to the Oracle Server, and feel that your firewall configuration works... good luck!

5 comments:

Unknown said...

Thank you very much, it worked...

Anonymous said...

I congratulate, your idea is useful

Anonymous said...

It is simply magnificent phrase

Anonymous said...

I congratulate, this idea is necessary just by the way

There is a site on a theme interesting you. Hot Health

Anonymous said...

I really like when people are expressing their opinion and thought. So I like the way you are writing