Posted on 2010-08-30 01:26
Terry的Blog 閱讀(753)
評論(0) 編輯 收藏 所屬分類:
oracle
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