Re: Using Oracle SQL over the Internet

From: Eric Keen <ekeen_at_dps-corp.com>
Date: 1998/02/13
Message-ID: <34E4E1AA.1D376294_at_dps-corp.com>#1/1


Ian Jones wrote:
>
> On Thu, 12 Feb 1998 15:08:35 -0800, "David Howlett"
> <amulet_at_ix.netcom.com> wrote:
>
> >Is it possible for one computer to access an Oracle SQL database on another
> >computer, over the Internet?
> Normal SQL*Net will work find (but slowly!) IF you can sort out the
> firewall restrictions. You will need to open up port 1521.
> >
I get descent performance using 128K ISDN (even 64K works). Once you take the 1st hit and a route is established - it's OK.
> >One computer is an NT Server which contains some access tables and some ASP
> >pages. The ASP pages need to open an Oracle SQL table on a different
> >computer. This is normally done through an ODBC System DNS driver.
> >
> >(I know that some products set up a Internet server service which is
> >accessible over the Internet by a specified port. Such as IP address
> >2.2.2.2 port 83. Does Oracle have such a provision? How does JDBC operate?)

I wouldn't use 83

$ grep 83 /etc/services

mit-ml-dev      83/tcp                          # MIT ML Device
mit-ml-dev      83/udp                          # MIT ML Device




> >
> >A lot of questions, I know.
> >
> >
> >
> >
 
-- 
Only 640 days left to stock up on canned goods, fuel & ammo before
2000/1/1
Received on Fri Feb 13 1998 - 00:00:00 CET

Original text of this message