Plsql Link Oracle Error--ORA-12154:TNS: Unable to resolve the specified connection identifier

D:\install\PLSQL\instantclient_11_2

An error occurred while reinstalling Oracle 11g,plsql connection Oracle today:ORA-12154:TNS: Unable to resolve the specified connection identifier.

On the internet a rough look, the error is more common, mainly is the connection configuration has been a problem. I run Sqlplus can connect normally, and plsql connection problem, explain the problem is mostly because Plsql connection has a problem.

The main cause of the connection problem is because I forgot the following two points:

1. Add the Environment variables:

Nls_lang = Simplified Chinese_china. Zhs16gbk

Tns_admin = D:\install\PLSQL\instantclient_11_2(actual directory of Plsql)

2. There is a connection profile under D:\install\PLSQL\instantclient_11_2 that needs to be changed based on the actual connection .

Also, do not forget the PL/SQL Developer environment setting:

1. Location

Connections, preferences, tools

2. Settings

Oracle Home Directory name = D:\install\PLSQL\instantclient_11_2

OCI Library = D:\install\PLSQL\instantclient_11_2\oci.dll

Plsql Link Oracle Error--ORA-12154:TNS: Unable to resolve the specified connection identifier