Re: Connecting via SQL Plus from Home to Work

Sorry to jump in on your thread here with a question, but if you allowed SQL*Net traffic to travel from the internet through your firewall and into your database server wouldnt that open your system up to potential security holes?

In article <36E1CD2D.13E0E401_at_rdbms.freeserve.co.uk>,   "Christopher M. Day" <christopher.day_at_rdbms.freeserve.co.uk> wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 08 1999 - 13:02:22 CST