Hey Guys,
I have a question about oracle client and the tnsnames.ora file. Basically, i have the client set up and it seems to be working on using sqldeveloper as it can see the tnsnames.ora file in the dropdown but i do not seem to be able to connect using sql plus, which makes me think it cannot find the ora file. I have the env's set up like :
DON@donkeyhome:/usr/lib/oracle$ echo $PATH
.:/usr/lib/oracle/oracle_client/bin:.:/usr/lib/jvm/jdk/bin:/usr/lib/jvm/jdk/jre/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
DON@donkeyhome:/usr/lib/oracle$ echo $ORACLE_HOME
/usr/lib/oracle/oracle_client
DON@donkeyhome:/usr/lib/oracle$ echo $TNS_ADMIN
/usr/lib/oracle/network/admin
DON@donkeyhome:/usr/lib/oracle$
So sql developer seems to work with the tns ok but not sqlplus :
DON@donkeyhome:/usr/lib/oracle$ sqlplus SYSADM@STUDA1
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 6 16:26:50 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Any help with this would be greatly appreciated as i have had this problem and commented on many forums for about 1 month now :(
Cheers Dave
Edited by: wheelie on Jan 5, 2009 10:28 PM
Edited by: wheelie on Jan 7, 2009 10:32 PM