Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Connecting via SQL Plus from Home to Work

Re: Connecting via SQL Plus from Home to Work

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 06 Mar 1999 02:56:39 GMT
Message-ID: <36e49910.2990129@192.86.155.100>


A copy of this was sent to ghubert_at_netpath.net (Gene Hubert) (if that email address didn't require changing) On Sat, 06 Mar 1999 02:51:22 GMT, you 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.
>

is your machine at work behind a firewall?

>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.
>

is that machine outside the firewall?

>Many thanks in advance,
>
>gene hubert
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Mar 05 1999 - 20:56:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US