Re: Connect to remote server via RAS and SQL*PLus

We're running tcp both in our office and the remote office.

RAS is configured to assign a tcp address to the dialup connection

I assume the tnsnames file on my machine needs to have the sid and server name of the remote server and these need to correspond to the listener.ora on the remote server.

I cant think of what else I may be missing but will start with pinging the server.

Thanks

Prasad Chavali wrote:
>
> Yes you can connect to SQL*Plus from RAS. When you dial-in what kind of
> settings you have on the connection. You need to setup the TCP/IP
> connection (DHCP or Server Assigned). Once you dial in, if you can ping
> your server, you can connect through SQL. If you are using some other
> networking protocal like named pipes or SPX, you need to setup the same
> through dial-up also.
>
> When you are in the office, what is the Protocol to the database?
>
> HTH
>
> Prasad Chavali
> pchavali_at_assettech.com
> Frank Calfo wrote in message <01bda5f0$20594fa0$e4010180_at_frank>...
> >I'm running Oracle 7.3.4 Workgroup server on an NT 4.0 box in a remote
> >office which is not part of our lan.
> >I would like to be able to run SQL*Plus from my office and connect to that
> >remote database over a dial up connection.
> >I setup RAS on the remote server and can connect to it via Win 95 dial up
> >networking.
> >I have sql*net configured on both the remote server and my pc
> >I can connect to the server from my pc when the server is on our lan.
> >But I cannot connect to it over the dial up connection. I get ORA-12333.
> >
> >Is it possible to connect to a remote database over a dial up connection.
> >If so, how?
> >
> >Thanks
Received on Thu Jul 09 1998 - 08:20:58 CEST