| Oracle Client 11.2.0.3 not working [message #601372] |
Wed, 20 November 2013 04:16  |
 |
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  |
John Watson
Messages: 8960
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 |
ThomasG
Messages: 3212
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 |
 |
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 |
 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
