Terry的Blog

Oracle instant客戶端下載地址
http://www.oracle.com/technetwork/topics/winsoft-085727.html
instantclient-basic-win32-11.2.0.1.0.zip

解壓后在客戶端根目錄創建tnsnames.ora文件
XE1 =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 16.157.1.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE1)
)

XE2 =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 16.157.1.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID= XE2)
)

配置PL/SQL Developer
配置PL/SQL的oracle的目錄位置
tool-->preferences-->connection-->oracle home 和 OCI Library 的路徑

在PL/SQL Developer安裝目錄下建立一個start.bat腳本文件
設置環境變量
set path=C:\instantclient_11_2
set ORACLE_HOME=C:\instantclient_11_2
set TNS_ADMIN=C:\instantclient_11_2
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
start PLSQLDev.exe

具體說明NLS_LANG的取值
格式:NLS_LANG=language_territory.charset

取值來源:select * from v$nls_parameters
查詢nls的參數，獲得數據庫服務器端的字符編碼 ,需要保證要設置客戶端字符集與服務器端字符集一致
NLS_LANGUAGE
NLS_CHARACTERSET