navicat连接Oracle数据库 一、根据自己版本去Oracle官网下载instantclient 二、 navicat设置OCI环境 三、Oracle数据库连接配置
记录一下navicat连接Oracle数据库过程：
地址：https://www.oracle.com/technetwork/topics/winx64soft-089540.html
二、 navicat设置OCI环境
进入navicat --> 工具 --> 选项 --> 环境添加instantclient oci.dll 重启后生效
三、Oracle数据库连接配置
知道Oracle数据库的TNS，如下：
fhzc_produce_boss= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.0.13)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.0.14)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac) ) ) test_db1= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.20.1.45)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = testdb1) ) )