Oracle Client 11.2.0.3 not working [message #601372] |
Wed, 20 November 2013 04:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a1ef481bc9f131925db258b93fb0a745?s=64&d=mm&r=g) |
sureshram24
Messages: 13 Registered: August 2013 Location: Bangalore
|
Junior Member |
|
|
Dear All,
New Oracle client version (11.2.0.3) had been installed in my linux machine and when i tried connecting after export, its not working.
export ORACLE_HOME=/oracle_client/11gR2_client/11.2.0
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
export SQLPLUS=$ORACLE_HOME/bin/sqlplus
export tnsnames=/home/ramacs4/backup/tnsnames.ora
[ramacs4@arlplmqvt01 ~]$ pwd
/home/ramacs4
[ramacs4@arlplmqvt01 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 20 04:03:16 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn npiwf@z8po.cis.cat.com
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
I have mentioned service name in tnsnames file and i could able to connect to this service using sql developer.
Could anyone please help me to resolve the issue?
Thank you.
|
|
|
Re: Oracle Client 11.2.0.3 not working [message #601374 is a reply to message #601372] |
Wed, 20 November 2013 04:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8937 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You are setting your path incorrectly, do it like this,export PATH=$ORACLE_HOME/bin:$PATH
Furthermore, are you under the impression that setting the variables SQLPLUS and tnsnames has any effect? It doesn't.
|
|
|
|
Re: Oracle Client 11.2.0.3 not working [message #601376 is a reply to message #601375] |
Wed, 20 November 2013 04:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3211 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Do you WANT to use /home/ramacs4/backup/tnsnames.ora as your configuration file, and is the connection configured in that file, not in the system-wide tnsnames.ora?
Then adding an export TNS_ADMIN=/home/ramacs4/backup/ should work.
|
|
|
|
|
Re: Oracle Client 11.2.0.3 not working [message #601410 is a reply to message #601372] |
Wed, 20 November 2013 11:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/14a95944eacc7f850311ba5a78a06266?s=64&d=mm&r=g) |
oracleattitude
Messages: 1 Registered: November 2013
|
Junior Member |
|
|
Hello,
You are not using the correct client, you are using 11.2.0.1 instead of 11.2.3.0. So you should try and correct your environment settings.
Try
$ which sqlplus
Also, post the output of the following command:
$ env | grep ORA
I would suggest editing the tnsnames located in the path of the client you want to use.
Regards,
[Updated on: Wed, 20 November 2013 11:59] Report message to a moderator
|
|
|
Re: Oracle Client 11.2.0.3 not working [message #601412 is a reply to message #601410] |
Wed, 20 November 2013 12:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>I have mentioned service name in tnsnames file and i could able to connect to this service using sql developer.
SQL Developer does not use tnsnames.ora file; so the fact it connects OK does not say anything about the correctness of tnsnames.ora file correctness.
post content of tnsnames.ora file(s) on the client system
|
|
|