记录一下navicat连接Oracle数据库过程：

　　一、根据自己版本去Oracle官网下载instantclient

　　地址：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)    )  )