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

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

　　地址：https://www.oracle.com/technetwork/topics/winx64soft-089540.html

　　二、 navicat设置OCI环境

　　进入navicat --> 工具 --> 选项 --> 环境添加instantclient oci.dll 重启后生效

　　　　 navicat连接Oracle数据库-LMLPHP

　　三、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)

    )

  )

　　 navicat连接Oracle数据库-LMLPHP