Re: Oracle Database Server 7.3 access through PPTP over internet

HongMing,

We are doing the same thing here so that our contractors (me included) can work from home at night instead of staying in the office and sleeping on the couch... *grin*.

For OUR system, Win95/NT home clients accessing Oracle 8 on a SUN server through Firewall-1, we've had to do the following:

1. Make sure there is a rule on your firewall allow SQLNet type queries to pass through when destination IP is your DB server. (You might be able to limit this to only allow SQL queries to pass through when originating from certain client IP's.)
2. Make sure that your client machine has the server name and/or IP address properly configured into it's appropriate SYSTEM level "hosts" file. On Win95/NT this is either "hosts" or "lmhosts" found in somewhere in the Windows/WinNT directory tree. On a UNIX system this would probably be "hosts" in your /etc directory. Something like this: 205.xxx.xxx.xx DBServerName should be added to your hosts file.
3. If you're going to use any old 3rd party product just to send SQL queries and that's all, then you should be ready to go. If you're using an Oracle Client to do the accessing then you might have to make sure that your TNSNAMES.ORA file is properly configured on your client to know the name and other info about your DBServer. By "name" I mean the name that you enter when you're asked for a Host Name or Connection String by the client.

Anyway... that scenario works like a charm for us.

Good luck...

James Arvigo
Consultant DBA / Intranet Developer
Austin, TX

HONGMING wrote:

> I am trying to access Oracle Server 7.3 through VPN.
>
> Aftter I dialed to ISP and made the connection successful, I launched PPTP
> client in my station and connected to PPTP server which is located in remote
> office. There is Watchguard installed as firewall in between.
>
> I can use IP ping as well as TNS ping without problem. When I was in
> SQLPlus to connect DB Server, the system give the message as 'TNS cannot
> find the detination'.
>
> Is there anyone know the reason ?
Received on Sat Aug 08 1998 - 03:29:47 CDT