Re: Connecting via SQL Plus from Home to Work

Gene,

As Thomas and John pointed out that a firewall could be inplace, its worth noting that unless the NT server has USE_SHARED_SOCKET configured under the Oracle reg key, you would not be able to specify a port# to go through' the firewall (it would vary). (so if your listener is configured for port# 1521 then specify this to your network guys ;)

Chris.

Gene Hubert wrote:
>
> I admittedly don't know much about the internet and am primarily a
> developer/dba. There's probably a huge mistake/misundrestanding here,
> but I thought I could install Oracle client on my NT4 computer at home
> and connect to the database at work via my ISP. Can someone kindly
> provide some assistance.
>
> I've done pretty much the same stuff I've done many times at work and
> I can't connect. I installed Oracle 8.0.5 client and set up a service
> name with the same IP address that I use at work. The connection test
> fails with ORA-12203 TNS: unable to connect to destination.
>
> Same result when trying to connect from SQL Plus. I can't ping the IP
> address nor can I TNSping it. I can see that something is being sent
> out my modem when I try to connect.
>
> I am able to use ftp to connect to a remote UNIX box where I maintain
> a web site. I am connected to my ISP when doing the above.
>
> Many thanks in advance,
>
> gene hubert
Received on Sat Mar 06 1999 - 18:49:49 CST