Re: TNSPING works SQLPLUS fails whsn connecting to remote server

91YJ_Renegade <spamcop_at_waxhaw.net> wrote in message news:<pan.2004.08.18.17.04.43.597277_at_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_at_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)

Thank you. It is working :) Received on Thu Aug 19 2004 - 23:22:22 CEST