Error trying to log in: ORA-12154

Question

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

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

I have already looked for a solution to the problem, but it is impossible to solve it. Any tips?

Answer 1

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

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

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

I hope this helps others.

Answer 2

This usually means that the specified database name is not in the tnsnames.ora file. If you open PL / SQL Developer, you will find the "info info" option in the About menu. This entry has this entry:

 TNS File D:\Oracle\Designer\net80\admin\tnsnames.ora 

Make sure your database is in this file.

Answer 3

Oracle documentation says:

Cause. A connection to a database or other service was required using the connection identifier, and the specified connection identifier could not be resolved to the connection descriptor using one of the configured naming methods. For example, if the type of connection identifier used was the name of the network service, then the net service name could not be found in the naming method repository, or the repository could not be found or reached.

Are you trying to connect to the database in the same way as Net Manager and PL / SQL Developer?