Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS: could not resolve the connect identifier specified (10.2.0.3, windows)
ORA-12154: TNS: could not resolve the connect identifier specified [message #571927] Tue, 04 December 2012 07:46 Go to next message
ishika_20
Messages: 334
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Since TNS is same for both


No, it is not.

Regards
Michel
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 Go to previous messageGo to next message
ishika_20
Messages: 334
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
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
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 Go to previous messageGo to next message
ishika_20
Messages: 334
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
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
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 Go to previous message
Littlefoot
Messages: 19303
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would TNS_ADMIN do any good?
Previous Topic: Heterogeneous database integrated
Next Topic: NL-00280: error creating log stream
Goto Forum:
  


Current Time: Wed Jul 23 22:07:58 CDT 2014

Total time taken to generate the page: 0.09384 seconds