Re: Connecting via SQL Plus from Home to Work

Maybe your work as a firewall on the IP that you have your database server. I had the same problem, so I had to talk to my IS department. They had to open a hole in the firewall to let me connection from the Internet.

John

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