Connecting via SQL Plus from Home to Work

From: Gene Hubert <ghubert_at_netpath.net>
Date: Sat, 06 Mar 1999 02:51:22 GMT
Message-ID: <20CB5F04EB04E954.9AE787A5788ABB0F.8375C908047C7620@library-proxy.airnews.net>

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 Fri Mar 05 1999 - 20:51:22 CST