Oracle即時用戶端Instant Client，方便使用PLSQL Developer方法，plsqldeveloper

Oracle即時用戶端Instant Client，方便使用PLSQL Developer方法，plsqldeveloper
背景：64位作業系統中、不安裝Oracle-32bit用戶端，方便使用PLSQL Developer（不支援64bit位Oracle用戶端）1，下載Oracle簡易用戶端Instant Client：http://www.oracle.com/technetwork/topics/winsoft-085727.html 。 下載instantclient-basic-win32-11.2.0.1.0.zip、instantclient-odbc-win32-11.2.0.1.0.zip2，安裝Instant Client解壓縮下載的兩種zip檔案。同時選擇兩個ZIP檔案，，然後右鍵選擇解壓到目前的目錄。比如解壓後我的目錄是D:\oracle\product\instantclient_11_23，設定環境變數3.1設定環境變數TNS_ADMINTNS_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（工具->喜好設定->串連），設定。