Re: Oracle Client Install

On 14 May 2004 00:17:58 -0700, Matt <mbrook100_at_yahoo.co.uk> wrote:

> 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

is related to resolving service name from tnsnames.ora and sqlnet.ora. Got nothing to do with port and firewall.

>
> 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.

not really, it just can't find the correct service configuration matching service name from your connect string.

>
> 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

1. stop pulling your hair :)
2. dump your tnsnames and sqlnet config files incl. your connect string.