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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With