Re: Connecting Oracle DB through firewall

Neba,

For detailed solution to your problem, check the post from one of our users:

http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3ca61543497cffff;act=ST; f=3;t=23

Check the latest Oracle DBA forums for solutions to your problems: http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"Neba" <nebojsa.petrovic_at_avanturo.de> wrote in message news:20ddef7d.0203280836.14cb7f32_at_posting.google.com...
> Hello,
>
> I have installed OracleDB 8.1.7 on Windows2000 SP2 This machine is in
> our LAN.
> Oracle DB use listener for communication on port 1521.
>
> Client is in DMZ of frewall. Firewall is Nokia IP330 with Check Point
> Fw-1 4 software.
>
> If I try connect to Oracle DB from LAN everything working fine. But
> when I try connect to Oracle Db from DMZ I got some problems.
>
> If I open all ports on firewall for connection between DMZ and LAN, I
> can connect to Oracle DB (tnsping is OK and I can connect with other
> aplication e.g. with SQL+) and everything working fine!
>
> If I leave open only port 1521 on firewall, then I can reach OracleDb
> by tnsping, but when I try use SQL+ I got time out error.
>
> I looked in tnslistener.log file, and I saw that client for any
> connection chose new port number (on client side)!So if I open port
> 1521 it is OK for server side but is wrong for client side!
>
> How can I solve this problem?
> Is it possibly 'fix' port number on client side?
>
> Thanks!
>
>
> Nebojsa Petrovic
Received on Sat Mar 30 2002 - 20:55:08 CST