Re: SQLNet through a firewall

sqlplus doesn't use sqlnet at all...
Sorry but this is blatant nonsense period.

By default the connection from server to client will use a different randomly selected port other than 1521 or 1526 or whatever you choose. In Oracle 8i you should be able to have them on one port by using the line use_shared_sockets = true
in sqlnet.ora

TNSPing80 only checks for the existence of the listener. It doesn't try to connect.
You should definitely have the address of the database only.

Hth,
--
Sybrand Bakker, Oracle DBA

John Hartley <jhartley_at_scc.com> wrote in message news:Vm_V3.6687$d6.10698_at_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 - 14:08:48 CST