oracle学习之路(5)Navicat连接Oracle数据库:Oracle library is not loaded 解决方案 拼搏现实的明天。 2024-03-26 20:47 21阅读 0赞 Navicat连接Oracle数据库报错:Oracle library is not loaded![725b20b7de4f2d950e5f476f873dfc25.png][] 原因:这是因为OCI环境配置有问题,需要修改 oci.dll 文件路径。版本不一致 是oci.dll版本不对。因为Navicat是通过Oracle客户端连接Oracle服务器的,Oracle的客户端分为两种,一种是标准版,一种是简洁版,即Oracle Install Client。而我们用Navicat时通常会在自己的安装路径下包含多个版本的OCI,如果使用Navicat连接Oracle服务器出现错误时,多数是因为Navicat本地的OCI版本与Oracle服务器不符造成的。所以我们要做的就是下载对应版本的OCI使之与我们所安装的Oracle服务器相符合。 1、首先下载免安装的Client包 OCI下载地址:[https://www.oracle.com/technetwork/topics/winx64soft-089540.html][https_www.oracle.com_technetwork_topics_winx64soft-089540.html] ![247d6063d93a77990829b4221252063d.png][] 若连接失效,则[https://www.oracle.com/database/technologies/instant-client/downloads.html][https_www.oracle.com_database_technologies_instant-client_downloads.html]![2d45c5b8b80b0343e19424062c3e058c.png][] 解压文件,将 oci.dll ,文件路径拷贝到OCI环境,重启Navicat 即可。![3586e120c2e11e21cbb113ca07dea685.png][] 2、特殊情况,Navicat12使用免安装的Clien包依然报错:Oracle library is not loaded 解决方案,直接安装oralce客户端, cliet包下载地址:[https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html][https_www.oracle.com_database_technologies_oracle19c-windows-downloads.html] WINDOWS.X64\_193000\_client.zip![9aff3933b720f3e24be5cab4e7179352.png][] 安装完成后,选择客户端生成oci.dll目录选择oci.dll ,重启Navicat 即可。![68cf0e7e30f38dce0786548bc7a48bc2.png][] [725b20b7de4f2d950e5f476f873dfc25.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/2bb2bfea1eb24da8bf0eee5522ed3384.png [https_www.oracle.com_technetwork_topics_winx64soft-089540.html]: https://www.oracle.com/technetwork/topics/winx64soft-089540.html [247d6063d93a77990829b4221252063d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/b9554acca95c491fbc2d82b768fb40b0.png [https_www.oracle.com_database_technologies_instant-client_downloads.html]: https://www.oracle.com/database/technologies/instant-client/downloads.html [2d45c5b8b80b0343e19424062c3e058c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/8ee85cece8bb40b0b4dca5a1b172c0f8.png [3586e120c2e11e21cbb113ca07dea685.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/381851f2a744406eaf7cc2a5be8a98cd.png [https_www.oracle.com_database_technologies_oracle19c-windows-downloads.html]: https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html [9aff3933b720f3e24be5cab4e7179352.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/85ad47eec28a487f820e3c4261941d7d.png [68cf0e7e30f38dce0786548bc7a48bc2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/cd729b0b8b57471983b1f9abc97d5cc7.png
还没有评论,来说两句吧...