Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connect trough firewall

Re: connect trough firewall

From: Johannes Blankenstein <jbla_at_giraffe.snafu.de>
Date: Tue, 19 May 1998 20:35:55 GMT
Message-ID: <Et817v.G4H@giraffe.snafu.de>


In article <6jpbe1$6n0$1_at_goof.de.uu.net>,

        "Eckhard Schaede" <schaede_at_trans-net.de> writes:
> I twant to connect to a remote Oracle-Database 7.3 behind a firewall. The
> TCP/IP-Ports 1526 and 1521 are open. The Database-Alias was created by
> SQLNetEasyConfiguration on WinNT4.0.
> When I try to connect, I get "Invalid username/password", but username and
> password are correct.
> Does Oracle use other ports for transmitting the password?

I had the same problem some weeks ago. When I called Oracle custommer support they told me that you need a firewall which supports SQL*NET. We where lucky! Our firewall does support SQL*NET. ;-)

You have to define within your firewall that the ports 1521 and 1526 are used for SQL*NET V1 or V2. Then the firewall will examine the returned packages for this port and will dynamicaly open a random port for your SQL connection. The definition within your firewall is similar to the definition of FTP or TELNET.

I hope this will help.

        Hannes

--
Johannes Blankenstein; Berlin; Germany
Email: jbla_at_giraffe.snafu.de

         jbla_at_giraffe.in-berlin.de Received on Tue May 19 1998 - 15:35:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US