转载网址:http://my.oschina.net/willclick/blog/31628
下载地址:
http://www.oracle.com/technetwork/topics/winsoft-085727.html
环境变量配置:
ORACLE_HOME=C:\instantclient_11_2
TNS_ADMIN=C:\instantclient_11_2
NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8
客户端配置:
instantclient_11_2下新建如下目录:NETWORK \ ADMIN 。在admin目录下新建文件tnsnames.ora
tnsnames.ora内容如下:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
(SERVER = DEDICATED)
)
)