From: adam@ip-plus.net   
      
   On 14 May 2004 00:17:58 -0700, Matt  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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)