The Oracle Instant Client facilitates the use of the PLSQL Developer method, plsqldeveloper

The Oracle Instant Client facilitates the use of the PLSQL Developer method, plsqldeveloper
Background: Oracle-32bit clients are not installed in 64-bit operating systems for ease of use of PLSQL Developer (64bit Oracle clients not supported) 1. Download the Oracle simple Client Instant Client: http://www.oracle.com/technetwork/topics/winsoft-085727.html. Download instantclient-basic-win32-11.2.0.1.0.zip、instantclient-odbc-win32-11.2.0.1.0.zip 2 and install the two types of zip files decompressed and downloaded by the Instant Client. At the same time, select two ZIP files, right-click and choose unzip to the current directory. For example, after decompression, my directory is D: \ oracle \ product \ instantclient_11_23. Set the environment variable 3.1 to set the environment variable TNS_ADMINTNS_ADMIN, for example, = D: \ oracle \ product \ instantclient_11_2 \ NETWORK \ ADMIN. (No subdirectory by default, NETWORK \ ADMIN. You can create it manually)
Note: To manually create a subdirectory NETWORK \ ADMIN \, you must create the tnsnames. ora file.

# tnsnames.ora Network Configuration File: D:\oracle\product\instantclient_11_2\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (CONNECT_DATA =      (SID = CLRExtProc)      (PRESENTATION = RO)    )  )ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 16101218-2)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )133_NSDEV =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.133)(PORT = 1521))    )    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = NSDEV)    )  )

3.2 set the environment variable NLS_LANG (the setting method is as follows: 3.1) For example, the value of NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" depends on the situation. (Select userenv ('language') from dual;) 4. In the last step, set PLSQL into to open plsqldev.exe and choose tool> Preferences> Connection (tool> preference> Connection ),.