Posted on 2010-08-30 01:26
Terry的Blog 阅读(745)
评论(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