How to access oracle in Nodes for a firewalled XP Server in LAN

[Reshmi Jacob]

Hi

I am a beginner, don't know much about oracle. Pls help me in this....

Our oracle server is a system with Win XP OS. When the firewall is turned on, no network users can access the oracle database, if the firewall is off, all users can access. How can I solve this since the server MUST need this firewall ?

Regards
Reshmi

[goudelly]

Hi,

In Win-XP you have to add the oracle and oracle.exe in below given sequence :
Where you Oracle is there in Win-XP system.

Network icon on status bar (right click)-->status-->properties-->advanced-->settings-->exceptions

addport -- (oracle and port is 1521)
addprog -- (c:\oracle\ora90\bin\oracle.exe).

Now the oracle can acess your clients with Win-XP firewall enabled also.

Thanks,

Mohan Reddy G

Hi

I am a beginner, don't know much about oracle. Pls help me in this....

Our oracle server is a system with Win XP OS. When the firewall is turned on, no network users can access the oracle database, if the firewall is off, all users can access. How can I solve this since the server MUST need this firewall ?

Regards
Reshmi

[Reshmi Jacob]

Dear Mr. Mohan

Thank you, your solution solved my prob.

Thanks & regards
Reshmi