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.

2023-05-13,,

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

错误信息:

---------------------------
(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 -》重启
 

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.的相关教程结束。

《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..doc》

下载本文的Word格式文档,以方便收藏与打印。