Navalcat连接oracle数据库instant client package is required for basic and tns connection

时间:2024-03-16 14:18:54

第一次用Navicat尝试连接Oracle数据库,报下面的错:
Cannot load OCI DLL 87:
instant client package is required for basic and tns connection

Navalcat连接oracle数据库instant client package is required for basic and tns connection

原因:

oracle需要装client才能让第三方工具通过OCI(Oracle Call Interface)来连接。

解决方案:

  1. 去oracle官网下载Instant Client 11

  2. 或者点击这里Instant Client 11

  3. 直接解压到合适目录下

  4. Navicat --> 工具 --> 选项… --> 其他 --> OCI,

    OCI library(oci.dll)*: 选择 解压的完的Instant Client 11
    Navalcat连接oracle数据库instant client package is required for basic and tns connection

  5. 重新尝试连接Oracle数据库

摘抄文献:https://blog.****.net/zxboy2895/article/details/73321080