Oracle Client Install

From: Matt <mbrook100_at_yahoo.co.uk>
Date: 14 May 2004 00:17:58 -0700
Message-ID: <c7b8aaad.0405132317.7bbc076f@posting.google.com>

Hi, we've got a database sitting behind a firewall running on port 1522. when I set up a tnsnames connection through the net8 assistant it all works fine, and tests are successful, but I can't tnsping the entry, connect through sqlplus etc.

I get the error TNS-03505: Failed to resolve name

We think that it's ignoring the entry for port 1522 in the tnsnames and continuing to use the 1521 default - the firewall isn't open on 1521, so we can the traffic getting stopped.

can't see any other tnsnames.ora file on the machine, set up oracle_home environment variable, pulling my hair out.....

any suggestions?
thanks alot Received on Fri May 14 2004 - 02:17:58 CDT