一、问题描述
安装完Navicat Premium_11.2.7配置了oracleclient客户端进行连接数据库,结果报oracle数据库链接补了,报错内容是“Cannot load OCI DLL,87: Instant Client package is required for Basic and TNS connection. For more information:http://wiki.navicat.com/wiki/index.php/Instant_client_required ”,如下图所示
二、解决问题
1. 由于navicat的OCI项中配置oracleclient的oci.dll路径是32位的版本和操作系统不兼容
2. 下载instantclient-basic-win-x86-64-10.2.0.3.0.zip版本(点击下载,请下载对应版本的客户端),解压后配置如下(菜单“工具”-“选项”)
3. 复制tnsnames.ora文件到下载的oracleclient根目录下(同oci.dll目录路径),tnsnames.ora内容如下
xwood99 =@b@ (DESCRIPTION =@b@ (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.119)(PORT = 1521))@b@ (CONNECT_DATA =@b@ (SERVER = DEDICATED)@b@ (SERVICE_NAME = xwood)@b@ )@b@)@b@ @b@@b@EXTPROC_CONNECTION_DATA =@b@ (DESCRIPTION =@b@ (ADDRESS_LIST =@b@ (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))@b@ )@b@ (CONNECT_DATA =@b@ (SID = PLSExtProc)@b@ (PRESENTATION = RO)@b@ )@b@ )@b@@b@ORACLR_CONNECTION_DATA = @b@ (DESCRIPTION = @b@ (ADDRESS_LIST = @b@ (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) @b@ ) @b@ (CONNECT_DATA = @b@ (SID = CLRExtProc) @b@ (PRESENTATION = RO) @b@ ) @b@ )
4. 重启navicat premium,刷新连接,问题解决了,如下图所示