Re: Connection causes client to lockup

Port 1521 is used to get the initial connection. Oracle then chooses a random open port and sends the client back the new address, making it difficult if your traffic is coming through a firewall. Check out Note 2064550.102 in MetaLink for some work-arounds to avoid opening up your firewall. (Go to 'TECHNICAL LIBRARIES' and then choose the 'Firewalls' section).

John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL

Nick Kelsey <nickkelsey_at_hotmail.com> wrote in message news:BiAj6.1920$5M5.129285_at_news1.frmt1.sfba.home.com...
> Hi,
>
> I have just set up a Oracle 8.1.6 (personal edition) server.
>
> On that computer and on a second computer on the LAN I can connect
 correctly
> (Using Net Configuration Assistant to test the connection or SQL to log
 in).
>
> When I try to connect to the server from a remote computer that is
 connected
> using a VPN the Net Configuration Assistant or SQL programs lock up
> (application not responding) when they try to connect.
>
> At first I thought it must be the VPN, but if I use telnet to test the
> oracle port (eg telnet 10.1.1.146 1521) the TCP connection is established
> correctly. This means that TCP is working, the VPN is working, and the
> firewall is letting the packets through in both directions.
>
> My TNSNAMES.ORA file contains the following:
>
> # TNSNAMES.ORA Network Configuration File:
> E:\Oracle\Ora81\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
> TRAINING =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.146)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = training.forgelink)
> )
> )
>
> Any help or suggestions would be appreciated.
>
> Thanks
>
> Nick
>
>
>
Received on Sun Feb 18 2001 - 02:03:18 CET