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)
    )
  )