Error when trying to log in: ORA-12154

oracle plsqldeveloper ora-12154
Nore picture Nore · Feb 17, 2012 · Viewed 10.6k times · Source

I am using Oracle 10g and PL/SQL Developer for the development. I have already tested from Net Manager that the database can be connected to, but when I tried to connect with PL/SQL Developer there was problem that I do not understand:

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

I have already searched for solution for the problem but still it can't be resolved. Any advice?

http://i.stack.imgur.com/OpjSI.png

Answer

Dirk Schumacher picture Dirk Schumacher · Jul 9, 2012

This was a hard one. tnsping works. tnsnames.ora is correct. This post solved it for me: http://sambitimes.blogspot.de/2010/10/ora-12154-error-in-windows-7.html

If installation path of PL/SQL-Developer contains brackets, it screws up... This will not work with win7: "C:\Program Files (x86)\PLSQL Developer"

this does for me: "C:\Program Files\PLSQL Developer"

I hope it helps for others.

Related questions

How to test an Oracle Stored Procedure with RefCursor return type?

I'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid XE2. Thank you.

Read More
How to connect to remote Oracle DB with PL/SQL Developer?

I have a database "TEST", to which I connect at address 123.45.67.89:1521. How do I connect to it using PL/SQL Developer?

Read More
how to convert a string date to date format in oracle10g

My date value is stored as varchar2 and the value is 15/August/2009,4:30 PM, how to convert this to a proper date format like DD-MM-YYYY.

Read More