SQLNet through a firewall

From: John Hartley <jhartley_at_scc.com>
Date: Tue, 9 Nov 1999 14:15:43 -0500
Message-ID: <Vm_V3.6687$d6.10698@newsr2.maine.rr.com>

Hello -

I'm attempting to connect to an Oracle 8i server from a Windows Terminal Server using Metaframe Client ver 1.8.

We are using Raptor as our firewall. In a nutshell, we have configured the TNSNAMES.ORA to have the IP address of the Oracle DB Server as well as the firewall address.

I can TNSPing the SID from the Citrix machine(which is on a different segment of our LAN...Think of it as outside the firewall..) But, I cannot establish a SQLPlus session. I get an ORA-12203...TNS unable to connect to destination error! i thought that TNSPing uses is more of a verifiable connection that SQLNet was working versus SQLPlus, because SQLPlus doesn't use SQLNet AT ALL!!

My listener is set up on 1530, because 1521 we thought was deemed proprietary, in any case, we got the same error with 1521 and 1526 on the listener.

We have traced this and it looks like the port that the listener is sending back info on is refusing the packet.

Any ideas of hwere to look??? I'm pulling whats left of my hair out!!

Thanks - John
jhartley_at_scc.com Received on Tue Nov 09 1999 - 13:15:43 CST