Oracle客户端 百度云下载地址: https://pan.baidu.com/s/1ECGwEGVJ0ZxRFEuQmOJPUA
Oracle客户端 官网的下载地址:http://www.oracle.com/technetwork/topics/winsoft-085727.html
PLSQL百度云下载地址 https://pan.baidu.com/s/1vbwL6pEYI4cbIiFmIk6xpw
正常解压Oracle客户端的驱动程序后文件夹里面是没有 \NETWORK\ADMIN的如果要是没有需要创建该目录
在D:\program\oracleInstantclient_11_2\NETWORK\ADMIN 目录下创建tnsnames.ora文件
然后粘一下oracle的数据库连接的信息
219.224.97.171 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 219.224.97.171)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
10.17.5.67 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.17.5.67)(PORT = 1521))
(CONNECT_DATA =
(SID = zmcf)
)
)
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK 或者 AMERICAN_AMERICA.AL32UTF8
ORACLE_HOME=D:\program\instantclient\instantclient_11_2 #根据自己机器的安装目录
TNS_ADMIN=%ORACLE_HOME%\NETWORK\ADMIN