PL/SQL Developer 64bit installation and configuration

After installation,
1. Unzip the instant client to the Plsql Developer installation directory
Note that this version only supports instantclient_11_x and does not support instantclient_12_x if you use 12_x to report DLL errors
2. Create the Network/admin directory under the Instant Client directory
3. Create the Tnsnames.ora file, write the content format as follows

# Generated byOracle configuration Tools. Db_dev=(DESCRIPTION=(Address_list=(ADDRESS=(PROTOCOL=TCP) (HOST= 33.5.126.211) (PORT= 1521)) ) (Connect_data=(service_name=ORC)) ) Extproc_connection_data=(DESCRIPTION=(Address_list=(ADDRESS=(PROTOCOL=IPC) (KEY =EXTPROC0)) ) (Connect_data=(SID=Plsextproc) (PRESENTATION=RO)) )

4. Set the properties of the desktop shortcut, add the following parameters, you can no longer need to set the environment variable

" C:\Program files\plsql Developer\plsqldev.exe " instantclient="C:\Program files\plsql developer\instantclient_11_2" Nls_lang =american_america. Al32utf8

5. The Nls_lang parameter can be obtained by querying the database, and SQL is

Select userenv ('language' from dual;

PL/SQL Developer 64bit installation and configuration