Oracle即時客戶端InstantClient，方便使用PLSQLDeveloper方法

Oracle即時客戶端InstantClient，方便使用PLSQLDeveloper方法

背景：64位操作系統中、不安裝Oracle-32bit客戶端，方便使用PLSQL Developer（不支持64bit位Oracle客戶端）

1，下載Oracle簡易客戶端Instant Client

2，安裝Instant Client

解壓縮下載的兩種zip文件。 同時選擇兩個ZIP文件，，然後右鍵選擇解壓到當前目錄。 比如解壓後我的目錄是D:\oracle\product\instantclient_11_2

3，設置環境變量

3.1設置環境變量TNS_ADMIN

TNS_ADMIN比如，=D:\oracle\product\instantclient_11_2\NETWORK\ADMIN。（默認無子目錄，NETWORK\ADMIN，手動創建即可)
注：手動創建的子目錄NETWORK\ADMIN\下，需要創建文件tnsnames.ora

# 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設置環境變量NLS_LANG（設置方法如同3.1）

比如NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"的值，要視情況而定。（select userenv('language') from dual;）

4，最後一步，設置PLSQL Developer

打開plsqldev.exe，進入菜單tool->Preferences->Connection（工具->首選項->連接），設置如圖。