PL/SQL Developer running on Oracle 64-bit database initialization error

After Oracle (64-bit) and PL/SQL Developer are installed, the following error occurs when PL/SQL is run:

My PL/SQL Developer is incompatible with ORACLE, that is, PL/SQL does not support 64-bit ORACLE, therefore, a 32-bit ORCALE client is required and the corresponding parameters are configured:

Note:

1. Download the ORACLE 32-bit Client

: Http://www.onlinedown.net/soft/102902.htm (Oracle 10g client lite green)

2. decompress the package to the product directory under the ORACLE installation directory and rename it (it is not necessary to name it). In this step, name instantclient_11_2.

Iii. PL/SQL Developer configuration, set OCI Library and Oracle_Home in perference-> Connection

ORACLE Home (empty is autodetect): This option configures the Home Directory of the ORACLE client

OCI library (empty is autodetect): configure the complete directory of oci. dll in the ORACLE client directory for options

Iv. Set Environment Variables

For the NLS_LANG environment variables, it is best to set them to be consistent with the database. First, query the character set information from the database:
SQL> select userenv ('language') nls_lang from dual;
NLS_LANG
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables ":
1>. Click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK ";
2>. Create an environment variable named "TNS_ADMIN" and set the value to "main directory of the Oracle client"

Here, my configuration is: "D: \ app \ Administrator \ product \ instantclient_11_2"
3>. Click "OK" to exit.

Restart PL/SQL Developer. No problem!