OraFAQ Forum: Networking and Gateways » ORA-12154: TNS: could not resolve the connect identifier specified

Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS: could not resolve the connect identifier specified (10.2.0.3, windows)

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

ORA-12154: TNS: could not resolve the connect identifier specified [message #571927]

Tue, 04 December 2012 07:46

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Dear All,

While connecting to Database through sqlplus as sysdba, error pop-up.

SQL> conn sysdba@disdevt
Enter password: *******
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Warning: You are no longer connected to ORACLE.
SQL>

but i am able to log-in to database through pl/sql developer. Since TNS is same for both. What could be the reason for this?

Regards,
Ishika

Report message to a moderator

Re: ORA-12154: TNS: could not resolve the connect identifier specified [message #571930 is a reply to message #571927]

Tue, 04 December 2012 08:16

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Since TNS is same for both

No, it is not.

Regards
Michel

Report message to a moderator

Re: ORA-12154: TNS: could not resolve the connect identifier specified [message #571971 is a reply to message #571930]

Wed, 05 December 2012 00:39

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Dear Michel,

TNS name is same for sqlplus & pl/sql developer. When i am updating tns entries, its appearing to pl/sql developer also. Then how it is giving problem to sqlplus only?

Regards,
Ishika

Report message to a moderator

Re: ORA-12154: TNS: could not resolve the connect identifier specified [message #571977 is a reply to message #571971]

Wed, 05 December 2012 01:19

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You don't use the same Oracle home and/or tnsnames.ora

Regards
Michel

Report message to a moderator

Re: ORA-12154: TNS: could not resolve the connect identifier specified [message #571989 is a reply to message #571977]

Wed, 05 December 2012 03:03

ishika_20
Messages: 339
Registered: December 2006
Location: delhi

Senior Member

Oracle_home & TNS name are created for the oracle and by default, sqlplus pick that path. Now, if i want to access sqlplus, need to create new oracle_home & tnsname.ora ?

Your answer is making me confuse. Can you please elaborate it to me?

Thanks,
Ishika

Report message to a moderator

Re: ORA-12154: TNS: could not resolve the connect identifier specified [message #571991 is a reply to message #571989]

Wed, 05 December 2012 03:36

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

PL/SQL Developer and SQL*Plus are not installed at the same, nor in the same home (by default), so they use different homes and tnsnames.ora.
Please search on the board, this issue has been handled many times.

Regards
Michel

Report message to a moderator

Re: ORA-12154: TNS: could not resolve the connect identifier specified [message #571998 is a reply to message #571991]

Wed, 05 December 2012 05:07

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would TNS_ADMIN do any good?

Report message to a moderator

Previous Topic:	Heterogeneous database integrated
Next Topic:	NL-00280: error creating log stream

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 16:39:30 CDT 2024