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.

1 comment:

  1. First uninstall pl/sql software and remove all pl/sql(OLD) folder,now install pl/sql while installing pl/sql developer it ask path where you want to install create new folder in C:plsql and give that path, it's worked to me without getting any error while connect to database.Thanks

    ReplyDelete