From: fvanbortel@netscape.net   
      
   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.   
      
   OK - so you have no problems at all.   
   >   
   > I get the error TNS-03505: Failed to resolve name   
      
   Huh? When? Where? You just said you had no problems?   
   >   
   > 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.   
   >   
   No it's not - but the listener is just that, and will hand over   
   to any free port for the actual connection. That's where your   
   firewall gets in place.   
   Otoh, that's not the error you're getting.   
      
   Your client configuration is wrong. Wonder where you ran   
   the net assistant.   
      
   Versions and platforms may help, too (e.g. with use_shared_socket)   
   > 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   
      
      
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)