orcle :Could not initialize "D:\app\Administrator\product\11.2.0\dbhome_1\bin\oci.dll" Make sure you have the 32 bits Oracle Client installed.

服务器重启后,数据库登录信息为空

 

技术分享

 

错误信息:

—————————
(Not logged on) – PL/SQL Developer
—————————
Initialization error
Could not initialize “D:\app\Administrator\product\11.2.0\dbhome_1\bin\oci.dll”
Make sure you have the 32 bits Oracle Client installed.

OCIDLL forced to D:\app\Administrator\product\11.2.0\dbhome_1\bin\oci.dll
LoadLibrary(D:\app\Administrator\product\11.2.0\dbhome_1\bin\oci.dll) returned 0
—————————
OK   
—————————
技术分享

环境:win7  64位

   PL/SQL Developer: Version 11.0.3.1770

 

解决方案

1. 从 http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html 下载Oracle Client Package。 我下载的是Instant Client for Microsoft Windows (32-bit) 【instantclient-basiclite-nt-11.2.0.2.0.zip -》(instantclient_12_1.zip)】 
2. 将 instantclient-basiclite-nt-11.2.0.2.0.zip 解压至 F:\instantclient_12_1 所在目录为:F:\instantclient_12_1
3. 启动PL/SQL Developer ,点击“取消”不要登录,菜单 –> Tools –> Perferences –> Connection 修改 Oracle_Home 和 OCI Library 的配置:

    OracleHome: D:\app\Administrator\product\11.2.0\dbhome_1  (
orcle 所在的安装目录

    OCI library: F:\instantclient_12_1\oci.dll  (
解压的目录
4.apply -》OK -》重启
 
技术分享