配置系统环境变量,在已有的环境变量中追加如下内容:
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