Oracle Client Install
From: Matt <mbrook100_at_yahoo.co.uk>
Date: 14 May 2004 00:17:58 -0700
Message-ID: <c7b8aaad.0405132317.7bbc076f_at_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.
Date: 14 May 2004 00:17:58 -0700
Message-ID: <c7b8aaad.0405132317.7bbc076f_at_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?