Re: tnsping works but session can't establish

sbrandt <member_at_dbforums.com> wrote in message news:<1776045.1031183816_at_dbforums.com>...
> I hope someone can help out on this. I am trying to connect to a Oracle
> 8.1.7 database on a remote server. The SID and Listener are fine as I
> can TNSPING and establish a session if I am VPN'd to the remote machine.
> My question is, why can I not establish a database session without being
> VPN'd? TNSPING works without VPN, but I recieve a TNS time out if I try
> to connect without the VPN session established.
>
> Scott

Is there a firewall between the two IP addresses? Even though the ping gets through actually establishing a session requires Oracle Net to open a port for the session different from the one the original request comes in on and access to this port could be blocked. At metalink Oracle support has a document on using Oracle Net with a firewall that may be of interest.

Maybe someone else will have a better idea, but I have heard similar complaints that were traced to firewalls.

HTH -- Mark D Powell -- Received on Thu Sep 05 2002 - 15:47:35 CEST