解决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

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

下载地址

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

下载Basic Package包后解压

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

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

提示ORA-12541:TNS:no listener

检查监听文件

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

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

su - oracle
netca

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

需要使用system登陆