Oracle instant client安装与设置 - Windows版,可用WIN7
1.下载
到http://www.oracle.com/technology/software/tech/oci/instantclient/index.html下载符合自己版本的安装程序.
2.解压到本地, 如我就解压在d:\instantclient_11_1 (windows版)
3.设置环境变量
TNS_ADMIN=d:\instantclient_11_1
path=%path%;d:\instantclient_11_1
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
4.设置oracle连接
在d:\instantclient_11_1下创建tnsnames.ora
为每一个需要连接的oracle设置如下
vm = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.180.129)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = topprod) ) )