Re: Connecting remote databases using analog phone line

You need to make sure that RAS is using the same protocols as that in the sql net
configuration eg. TCP/IP. Also check hostnames are correct and that the RAS address
if TCP/IP is static and not dynamic.

Check the tnsnames.ora file for info on the protocols and names expected.

Dan
Shawn Tee <ystee_at_singnet.com.sg> wrote in message news:37BD1A3C.6D0A77DC_at_singnet.com.sg...
> I need some advice on how to connect 2 oracle 8.0.5 database instances
> using RAS(Remote Access Service) on windows NT.
> Reason for doing this is that I need to post some data from one server
> to the other at the end of the day. The 2 servers will be located at
> different location connected by analog phone line.
> Currently, I'm able to browse the entire network neighbourhood but I'm
> not able to ping the RAS server. I'm trying to establish the connection
> using sql net. The error msg I received is
> "TNS could not connect to destination". Is the concept which I used
> correct? The configuration works if I run the 2 servers on the same
> physical LAN.
>
> thanks
> Shawn
>
Received on Sat Aug 21 1999 - 09:24:05 CDT