From: spamcop@waxhaw.net   
      
   The windows file tnsnames.ora had contrl characters   
   that messed up SQLPLUS!!   
      
   On Wed, 18 Aug 2004 11:33:15 -0400, 91YJ_Renegade wrote:   
      
   > why can I TNSPING but I can not connect using SQLPLUS?   
   >   
   > Oracle 10g   
   > Slackware 10 install 2.6.6 kernel   
   >   
   > exports   
   > ORACLE_BASE=/home/oracle   
   > ORACLE_HOME=/home/oracle/product/10g   
   > ORACLE_SID=ora9i   
   > ORACLE_TERM=xterm   
   >   
   >   
   > error in sqlplus:   
   > bash-2.05b$ sqlplus wells/blah@test   
   >   
   > SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 18 11:30:06 2004   
   >   
   > Copyright (c) 1982, 2004, Oracle.  All rights reserved.   
   >   
   > ERROR:   
   > ORA-12154: TNS:could not resolve the connect identifier specified   
   >   
   >   
   >   
   >   
   > TNSPING:   
   > bash-2.05b$ tnsping test   
   >   
   > TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 18-AUG-2004   
   11:31:28   
   >   
   > Copyright (c) 1997, 2003, Oracle.  All rights reserved.   
   >   
   > Used parameter files:   
   > /home/oracle/product/10g/network/admin/sqlnet.ora   
   >   
   >   
   > Used TNSNAMES adapter to resolve the alias   
   >  )SERVICE_NAME = test.clt.fisonline.com).5.30)(PORT = 1521))   
   > OK (40 msec)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)