服务器重启后,数据库登录信息为空
错误信息:
---------------------------
(Not logged on) - PL/SQL Developer
---------------------------
Initialization error
Could not initialize "D:appAdministratorproduct11.2.0dbhome_1inoci.dll"
Make sure you have the 32 bits Oracle Client installed.
OCIDLL forced to D:appAdministratorproduct11.2.0dbhome_1inoci.dll
LoadLibrary(D:appAdministratorproduct11.2.0dbhome_1inoci.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:appAdministratorproduct11.2.0dbhome_1 (orcle 所在的安装目录)
OCI library: F:instantclient_12_1oci.dll (解压的目录)
OracleHome: D:appAdministratorproduct11.2.0dbhome_1 (orcle 所在的安装目录)
OCI library: F:instantclient_12_1oci.dll (解压的目录)
4.apply -》OK -》重启