Re: Not able to connect to Oracle database through VPN

On Feb 7, 8:52 am, Ravi <sainiravik..._at_gmail.com> 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.
>
> *********TNSPING OUTPUT*************
> C:\>tnsping tv92.tcrix
>
> TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production
> on 07-FEB-2
> 008 19:10:51
>
> Copyright (c) 1997, 2003, Oracle.  All rights reserved.
>
> Used parameter files:
> C:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora

What is the operating system of the server, and the client?

Is your setup similar to this:
(Server)-(VPN Server)-(Firewall)-(Internet)-(Firewall)-(Client)

If the above is the case, the firewall on the server side will only see the encrypted VPN packets, which may be using UDP ports 500, 4500, or something else.

If your setup looks like this:
(Server)-(Firewall)-(VPN Server)-(Firewall)-(Internet)-(Firewall)- (Client)

In the above, there is a firewall between the Oracle server and the VPN server, so then you will need to determine the ports that need to be open on that firewall to allow Oracle's packets to pass through the firewall for VPN connectivity. You may also need to make certain that the client and server do not negotiate a different set of port numbers to use for communication.

Have you tried using a packet capture utility on the client side?

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