ORACLE INSTANT CLIENT和PLSQL的配置

来源:互联网 发布:淘宝怎么选发货地 编辑:程序博客网 时间:2024/05/17 08:39

配置系统环境变量,在已有的环境变量中追加如下内容:

PATH=d:\Oracle\instantclient_11_1

TNS_ADMIN=d:\Oracle\instantclient_11_1 
LD_LIBRARY_PATH=d:\Oracle\instantclient_11_1 
SQLPATH=d:\Oracle\instantclient_11_1 
nls_lang=simplified chinese_china.ZHS16GBK

环境变量配置完成后,需要拷贝tnsnames.ora文件到D:\Oracle\instantclient_11_2目录下。

tnsnames.ora文件可以从服务器端进行拷贝,也可手动进行编辑,例如

TEST =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.114.88)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = test)    ))PLSQL的配置启动PL/SQL, 进入tool->preference, 设置Oracle home OCI library, Oracle home=c:\instantclient, OCI library=c:\instantclient\oci.dll
0 0