Sunday, September 22, 2013

Windows 7, PLSQL Developer, Connect Error "ORA-12154: TNS:could not resolve the connect identifier specified"

Operating System version: Windows 7 Professional, Service Pack 1
PLSQL Developer version: 7.0.0.1050

While trying to connect PLSQL developer to a remote database, we might encounter below error:



We have already verified that PLSQL developer is correctly pointing to correct oracle home which contains all the connection entries in tnsnames.ora file needed to connect to remote database.

Generally, whenever we install a new software in Windows 7 operating system, it installs it in "C:\Program Files (x86)", instead of "C:\Program Files".

Resolution is very weird for this issue. We have moved the installed PLSQL developer folder from  "C:\Program Files (x86)" to "C:\Program Files". Now, we started PLSQL executable and we were able to connect to remote database successfully.