This sounds like a different problem. If your network engineer has a packet
sniffer, I'd ask him to check out stuff from both sides of the firewall.
There are three areas that could be a problem...
Client: You don't have your client configured right. Client config is
pretty easy, but there are a number of things that can easily go wrong.
Firewall: If you have ports 1500-1700 open right now, this is probably not
an issue. You might try moving this machine inside the firewall if possible
and giving it a try
Server: Oracle also has to be configured to listen for connections on the
network. If you've never been doing this before, its probably not configed
that way.
Lots of possibilities still...
Brian
-----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
