Re: Remote accessing a oracle server

I used this technique to work on a database in Helsinki from my offices in Vancouver using the Internet as the communications channel. It may not be terribly fast but it actually can work reasonably well if you don't fetch megabytes of data too often.

You can use the EasyNet Configuration tool (Oracle Net8 Easy Config under O8) to add a new service name. Choose the TCP/IP protocol and provide the IP address when it asks for the machine name. You will need to know the SID and both installations will have to be configured for TCP/IP. Thereafter it is no different from connecting to two instances of Oracle at the same site. You can connect directly using the service name or you can use any of the Oracle tools for distributed database communication.

Dinyar Ghyara wrote in message <884876368.1656356883_at_dejanews.com>...
>Hi, how do i access a reomte database at another site? what are the steps
>involved? I have 2 NT servers which will have Oracle installed on them.
>They will be connected via a leased line. Both these servers will have
>their own domains. I will need to have client of both the machines
>talking to Oracle on bothe the machines. Please Help. -Dinyar
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Thu Jan 15 1998 - 00:00:00 CST