<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[Heck's  Blog]]></title> 
<link>https://www.heckjj.com/index.php</link> 
<description><![CDATA[一瞬间的决定，往往可以改变很多，事实上，让自己成功的往往不是知识，是精神！ 如果你总是为自己找借口，那只好让成功推迟。执行力，今天！]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[Heck's  Blog]]></copyright>
<item>
<link>https://www.heckjj.com/post//</link>
<title><![CDATA[navicat连接Oracle数据库报错ORA-28547: connection to server failed, probable Oracle Net admin error]]></title> 
<author>Heck &lt;@hecks.tk&gt;</author>
<category><![CDATA[数据库]]></category>
<pubDate>Fri, 18 Nov 2022 02:46:11 +0000</pubDate> 
<guid>https://www.heckjj.com/post//</guid> 
<description>
<![CDATA[ 
	<a href="https://www.heckjj.com/attachment.php?fid=247" target="_blank"><img src="https://www.heckjj.com/attachment.php?fid=247" class="insertimage" alt="点击在新窗口中浏览此图片" title="点击在新窗口中浏览此图片" border="0"/></a><br/>问题产生的原因：<br/>由于我远程的Oracle是 11g的，但是Navicat本身的Oracle oci.dll文件是10g的，数据库与链接库的版本不一致，所以会报错。<br/><br/>打开navicat的安装目录，查看有没有以下文件：<br/><a href="https://www.heckjj.com/attachment.php?fid=246" target="_blank"><img src="https://www.heckjj.com/attachment.php?fid=246" class="insertimage" alt="点击在新窗口中浏览此图片" title="点击在新窗口中浏览此图片" border="0"/></a><br/>解决方案：<br/>1、我们去Oracle官网下载对应的Instant Client Package -Version 11.2.0.4.0 - Basic的文件即可<br/><br/>下载地址：<a href="https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html#license-lightbox" target="_blank">Instant Client for Microsoft Windows (x64) 64-bit</a><br/>或者自行网上搜索下载<br/> 下载好之后，解压到navicat安装目录下<br/><br/>2、启动navicat客户端 找到【工具】-&gt;【选项】-&gt;【环境】<br/> 将OCI环境更改为11_2下的oci.dll即可，重启之后即可生效！<br/><a href="https://www.heckjj.com/attachment.php?fid=245" target="_blank"><img src="https://www.heckjj.com/attachment.php?fid=245" class="insertimage" alt="点击在新窗口中浏览此图片" title="点击在新窗口中浏览此图片" border="0"/></a>
]]>
</description>
</item><item>
<link>https://www.heckjj.com/post//#blogcomment</link>
<title><![CDATA[[评论] navicat连接Oracle数据库报错ORA-28547: connection to server failed, probable Oracle Net admin error]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>https://www.heckjj.com/post//#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>