PL/SQL Developer Connection Oracle appears "Ora-12154:tns:could not resolve the connect identifier specified" problem resolution

Reprint Please specify source: http://blog.csdn.net/dongdong9223/article/details/50728536
This article is from "I'm a fish-hook blog."

Connect Oracle using the PL/SQL Developer tool and error when logging in:

ORA-12154:TNS:couldnot resolve the connect identifier specified

But landing with the command line is fine. There should be a PL/SQL developer tool where the configuration is incorrect. To try it, you need to click on the PL/SQL Developer interface:

ToolsPreferences

In the interface.

You need to configure both "Oracle Home" and "OCI Library".

Oracle Home Sets the Oracle installation location, for example:

D:\oracle\product\10.2.0\db_1

The OCI library is a oracleclient location where you need to install the client and then specify its location, for example:

D:\oracle\product\10.2.0\db_1\BIN\oci.dll

Sometimes "OCI library" can not fill, but "Oracle Home" must be filled.

After filling out the PL/SQL developer, you can connect to Oracle.

PL/SQL Developer Connection Oracle appears "Ora-12154:tns:could not resolve the connect identifier specified" problem resolution