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