解决Navicat连接Oracle12c时提示oracle library is not loaded

Navicat Premium 15连接Oracle 12c时提示oracle library is not loaded,需要先下载instantclient-basic-windows.x64-12.2.0.1.0.zip


解决Navicat连接Oracle12c时提示oracle library is not loaded

直接连接时提示oracle library is not loaded


下载地址

https://www.oracle.com/database/technologies/instant-client/downloads.html

解决Navicat连接Oracle12c时提示oracle library is not loaded


解决Navicat连接Oracle12c时提示oracle library is not loaded

下载Basic Package包后解压


解决Navicat连接Oracle12c时提示oracle library is not loaded

放置到无英文的路径下,比如C:\Program Files\PremiumSoft\Navicat Premium 15


解决Navicat连接Oracle12c时提示oracle library is not loaded

打开Navicat,选择“工具 - 选项 - 环境 - OCI环境 - OCI library (oci.dll)”,浏览到刚才目录中的oci.dll,重启Navicat


解决Navicat连接Oracle12c时提示oracle library is not loaded

提示ORA-12541:TNS:no listener

检查监听文件

cat /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

发现没有问题,新建监听后解决

su - oracle
netca


解决Navicat连接Oracle12c时提示oracle library is not loaded

提示ORA-28009:connection as SYS should be as SYSDBA or SYSOPER


解决Navicat连接Oracle12c时提示oracle library is not loaded

需要使用system登陆


更新日期: 2020年09月08日
文章标签: Oracle
文章链接: https://www.vos.cn/other/450.html  
版权说明:如非注明,本站文章均为vOS原创,转载请注明出处和附带本文链接。