instantclient_10_2必须设置oracle环境变量,否则不好用。如下:
1) 变量名:ORACLE_HOME
变量值:D:\Program Files\instantclient_10_2
2) 变量名:TNS_ADMIN
变量值:D:\Program Files\instantclient_10_2
3) 变量名:NLS_LANG
变量值:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
4) 修改Path变量,在后面添加 D:\Program Files\instantclient_10_2
tnsnames.ora配置:
MyDB=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.86.1.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = xxxx)
(SERVICE_NAME = xxxx)
)
)