navicat连接Oracle数据库

　　记录一下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)
    )
  )