Solution to ORA-12154: TNS: couldnotresolvetheconnectidentifierspecified when PL/SQLdeveloper connects to oracle

Solution to ORA-12154: TNS: couldnotresolvetheconnectidentifierspecified when PL/SQLdeveloper connects to oracle

Use the PL/SQL developer tool to connect to oracle. An error is reported during logon:

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

However, you can use the command line to log on. It should be because the PL/SQL developer tool is incorrectly configured. After trying it out, you need to click:

Tools -> Preferences

<喎?http: www.bkjia.com kf ware vc " target="_blank" class="keylink"> VcD4NCjxwPjxjb2RlIGNsYXNzPQ = "hljs ruby"> In the interface,

You need to configure "Oracle Home" and "OCI library.

Here, "Oracle Home" sets the oracle installation location, for example:

D:\oracle\product\10.2.0\db_1

"OCI library" is the oracle client location. You need to install the client and specify its location, for example:

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

Sometimes the "OCI library" can be left blank, but the "Oracle Home" must be filled.

After filling in, PL/SQL developer can connect to oracle.