服务器重启后,数据库登录信息为空: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 -》重启
 

 

 

posted @ 2017-06-13 11:40  Piper_NicolasCage  阅读(7487)  评论(0编辑  收藏  举报