Oracle instant client安装与设置
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)
)
)
页:
[1]