1、下载压缩包 instantclient-basic-win32-11.1.0.7.0.rar 并解压
2、在文件夹 instantclient-basic-win32-11.1.0.7.0.rar\instantclient_11_1 下面找到tnsnames.ora文件,
并添加要连接的数据库的信息
tnsnames.ora文件内容
-------------------------
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.146.143 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
<
下载地址: http://download.csdn.net/detail/u012613095/9647375
2、在文件夹 instantclient-basic-win32-11.1.0.7.0.rar\instantclient_11_1 下面找到tnsnames.ora文件,
并添加要连接的数据库的信息
tnsnames.ora文件内容
-------------------------
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.146.143 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
<