伺服器重啟後,資料庫登錄信息為空 錯誤信息: (Not logged on) - PL/SQL Developer Initialization errorCould not initialize "D:\app\Administrator\product\11.2.0\dbhome_1\bin\o ...
伺服器重啟後,資料庫登錄信息為空
錯誤信息:
---------------------------
(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 -》重啟