官网可以下载
D:\Program Files\instantclient_11_2\network\admin\tnsnames.ora、
注意填写清楚下面两项的内容
ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.17)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) BWG_ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 74.120.175.165)(PORT = 1521)) ) (CONNECT_DATA = (SID = orcl) ) ) WIN_ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) ORCL-19c = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.51)(PORT = 1521)) ) (CONNECT_DATA = (ORACLE_SID = itpuxdb) ) )
oci.dll文件的配置
windows 客户端的Navicat & PL/SQL 连接Oracle 数据库
原文:https://www.cnblogs.com/wenyule/p/13200129.html