Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connecting to Oracle database over the internet
dcrane_at_direct.ca wrote in message <879903231.9127_at_dejanews.com>...
>In article <63na5a$cpb_at_news9.noc.netcom.net>,
> "Craig M. Wall" <cwall_at_petersons.com> wrote:
>>
>> As far as I know, all client connections to remote databases over IP
require
>> the presence of SQL*Net connectivity software on both machines to provide
a
>> substrate or transport mechanism for non-native access methods such as
OLE,
>> ODBC, Livewire, Perl, etc.
>>
>> On the client side, you'll need Oracle's SQL*Net for TCP/IP, most likely
>> version 2.x. Then you must configure the tnsnames.ora file on the client
to
>> associate an alias for the instance name you are attempting to connect to
>> and it's IP address.
>>
>> Then you will use this alias in your tool's connect string (along with
>> username & password) when it logs into the database. This also assumes
that
>> if a firewall proxy server is in place it is configured to pass SQL*Net
>> packets or if it's just a router, that your remote IP address is allowed
to
>> be forwarded to the database host.
>>
>> Regards,
>> Craig M. Wall
>>
>> Steve wrote in message <345f54d3.6648326_at_news.ais.net>...
>> >I am trying to attach to an Oracle server running on a remote system
>> >through it's IP address on the internet. The web server is a sun
>> >machine and I am looking for a way to do this through Perl. How do
>> >you connect to remote Oracle servers through their IP over the
>> >internet? Thanks.
>> >
>> >Steve
>
>ACtually, SimbaExpress from Simba TEchnologies (http://www.simba.com)
>let's you connect to Oracle over the Net without having to put SQLNet on
>the client machine. It uses a 3-tier structure to make ODBC over the Net
>FAST and manageable.
>
>To see what I mean, point your browser at
>http://www.simba.com/demos/online.html and try out one of their online
>demos. You just download an app that contains the ODBC driver (no need
>for SQLNet on your computer) and you can connect to an Oracle db over the
>Net
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
But SimbaExpress does not remove the need to purchase and install the client version of SQL*Net which must still be configured properly whether it's located on the client, N-tier or server side.
So just to be clear, even with Simba's solution, SQL*Net client must still provide the conduit for remote client ODBC access to an Oracle database.
Regards,
Craig M. Wall Sr. Oracle DBA / Manager of Oracle Technology Received on Wed Nov 19 1997 - 00:00:00 CST