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.

標籤：修改   ret   com   microsoft   服務   tools   not   分享   targe   

伺服器重啟後，資料庫登入資訊為空白

 

 

錯誤資訊：

---------------------------
(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_13. 啟動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.