Re: Not able to connect to Oracle database through VPN

On Feb 7, 1:52 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Ravi wrote:
> > Port 1500 is open on firewall. Tnsnames entry
>
> > tv92.tcrix=
> >   (DESCRIPTION =
> >     (ADDRESS_LIST =
> >       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.5.79)(PORT = 1500))
> >     )
> >     (CONNECT_DATA =
> >       (SERVER = DEDICATED)
> >       (SERVICE_NAME = tv92.tcrix)
> >       (INSTANCE_NAME = tv92a)
> >     )
> >   )
>
> > Please check trace file if anybody can figure out something, we are
> > facing this issue since last 3months.
>
> You have a firewalled VPN, then? What if you disable the firewall
> for the VPN connections?
> (Why do you have your VPN firewalled anyway?!? VPN through a
> firewall - yes, but firewalling a VPN?)
>
> --
>
> Regards,
> Frank van Bortel

I firewall my VPN:
 (Oracle Server)-(Firewall)-(VPN Server)-(Firewall)-(Internet)

Why? So that I can control the type of traffic flowing through the VPN based on port and protocol and the requesting client. Such a setup helps control the damage a remote system can do to the corporate network, as well as control what the computers on the corporate network can do to damage the remote system.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Thu Feb 07 2008 - 17:27:53 CST