No, sorry. According to
http://www.isi.edu/in-notes/iana/assignments/port-numbers, the "Well-known"
ports are 0-1023, the "registered" ports are 1024-49151, and the
"dynamic/private" ports are 49152-65535, so logically it should be that last
range. But I don't know if Oracle followed the rules.
On a client NT machine currently connected to the DB you could run "netstat"
at a command prompt and see what port it's using this time - do it a few
times and you might see a pattern.
-----Original Message-----
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 5:35 PM
To: CF-Talk
Subject: RE: Oracle Port?
Interesting. Would you know the range of ports needed given method 1?
I opened 1500-1700 (due to references I found for 1521, 1526 and 1610) but
am still having problems (TNS: unable to connect to destination) although
it could be something else...
> This is actually an interesting problem. If you look in the TNSNAMES.ORA
> file on a machine that connects to the Oracle database you will see an
entry
> for the database you care about with a "Port=" line; this port has to be
> open to the database. However, by default Oracle 8 on NT does something
> special: the client connects to the port named, and then the client and
the
> server negotiate a new port on the database server to be used for all the
> real communication. So even if you open the named port, your client won't
> be able to query the database because it's trying to submit the query
using
> a new port that not's open in the firewall.
>
> Your choices:
> 1) Teach the firewall to allow access to the DB server on any port
> 2) Get the firewall admin to install an Oracle-specific "SQL*Net Proxy"
> 3) Teach the database server not to renegotiate but just use the port
> identified in TNSNAMES.ORA for all activity.
>
> I've only used method 3. This involves something called "Shared Socket".
> You can search the Oracle Metalink support database for "Shared Socket" or
> document ID 124140.1, which describes how to do it.
>
>
> Enjoy!
>
> -----Original Message-----
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 16, 2001 2:17 PM
> To: CF-Talk
> Subject: Oracle Port?
>
>
> I'm setting up remote access to a db server behind a IP firewall. I need
> to know what ports to open to that machine so I can access the db from
> coldfusion. The db server is Oracle 8.0.5 on NT.
>
>
> Tony Schreiber, Senior Partner Man and Machine, Limited
> mailto:[EMAIL PROTECTED] http://www.technocraft.com
>
> http://www.linktoss.com _______The Fastest Way to Send a Link to Anyone!
> http://www.digitacamera.com ______________DigitA Camera Scripts and Tips
> http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300
> http://www.cfug-sfl.org ___________South Florida Cold Fusion Users Group
> http://www.simplemessageboard.com____Free Forum Software for Cold Fusion
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
