OraFAQ Forum: Server Administration » Oracle Client 11.2.0.3 not working

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

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: 8976
Registered: January 2010
Location: Global Village

Senior Member

You are setting your path incorrectly, do it like this,

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: Oracle Client 11.2.0.3 not working [message #601375 is a reply to message #601374]

Wed, 20 November 2013 04:26

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

Report message to a moderator

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.

Report message to a moderator

Re: Oracle Client 11.2.0.3 not working [message #601379 is a reply to message #601375]

Wed, 20 November 2013 04:43

John Watson
Messages: 8976
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.

Report message to a moderator

Re: Oracle Client 11.2.0.3 not working [message #601386 is a reply to message #601375]

Wed, 20 November 2013 07:41

EdStevens
Messages: 1376
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)

Report message to a moderator

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

Report message to a moderator

Previous Topic:	Changing CHARACTER SET
Next Topic:	logging to multiple DB on same server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 08:52:53 CDT 2025