Home » RDBMS Server » Server Administration » Oracle Client 11.2.0.3 not working (Oracle, 11.2.0.3, Linux x86_64 x86_64 x86_64 GNU/Linux)
Oracle Client 11.2.0.3 not working [message #601372] Wed, 20 November 2013 04:16 Go to next message
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 messageGo to next message
John Watson
Messages: 4709
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 #601375 is a reply to message #601374] Wed, 20 November 2013 04:26 Go to previous messageGo to next message
sureshram24
Messages: 13
Registered: August 2013
Location: Bangalore
Junior Member
Hi John,

I tried same but still no luck ..

[ramacs4@arlplmqvt01 ~]$ export ORACLE_HOME=/oracle_client/11gR2_client/11.2.0
[ramacs4@arlplmqvt01 ~]$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
[ramacs4@arlplmqvt01 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[ramacs4@arlplmqvt01 ~]$ export SQLPLUS=$ORACLE_HOME/bin/sqlplus
[ramacs4@arlplmqvt01 ~]$ export tnsnames=/home/ramacs4/backup/tnsnames.ora
[ramacs4@arlplmqvt01 ~]$
[ramacs4@arlplmqvt01 ~]$ sqlplus npiwf@z8uo.cis.cat.com

SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 20 04:24:51 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
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 messageGo to next message
ThomasG
Messages: 3104
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 #601379 is a reply to message #601375] Wed, 20 November 2013 04:43 Go to previous messageGo to next message
John Watson
Messages: 4709
Registered: January 2010
Location: Global Village
Senior Member
In that case, your ORACLE_HOME is set incorrectly. Can't you see that you are running the 11.2.0.1 client, not the 11.2.0.3 client?

And please read and follow the instructions here How to use [code] tags and make your code easier to read before you post again.
Re: Oracle Client 11.2.0.3 not working [message #601386 is a reply to message #601375] Wed, 20 November 2013 07:41 Go to previous messageGo to next message
EdStevens
Messages: 313
Registered: September 2013
Senior Member
sureshram24 wrote on Wed, 20 November 2013 04:26
Hi John,

I tried same but still no luck ..

[ramacs4@arlplmqvt01 ~]$ export ORACLE_HOME=/oracle_client/11gR2_client/11.2.0
[ramacs4@arlplmqvt01 ~]$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
[ramacs4@arlplmqvt01 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[ramacs4@arlplmqvt01 ~]$ export SQLPLUS=$ORACLE_HOME/bin/sqlplus
[ramacs4@arlplmqvt01 ~]$ export tnsnames=/home/ramacs4/backup/tnsnames.ora
[ramacs4@arlplmqvt01 ~]$
[ramacs4@arlplmqvt01 ~]$ sqlplus npiwf@z8uo.cis.cat.com

SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 20 04:24:51 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified




see: http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/ (ora-12154 TNS:could not resolve the connect identifier specified)
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 messageGo to next message
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
BlackSwan
Messages: 22927
Registered: January 2009
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
Previous Topic: Changing CHARACTER SET
Next Topic: logging to multiple DB on same server
Goto Forum:
  


Current Time: Fri Oct 31 07:51:00 CDT 2014

Total time taken to generate the page: 0.10004 seconds