PL/SQL Developer Initialization errorSQL.Net not properly installed OracleHomeKey: OracleHomeDi. Creating Oracle Homes. To create an Oracle home, follow the steps below. In the File Locations page, enter the Oracle home settings for the installation session under Destination. OracleHomeKey: SOFTWARE ORACLE OracleHomeDir: 原因大概是Oracle10g的安装目录结构变了,需要在PLSQL Developer中重新配置ORACLEHOME and 'OCI Library'的目录。. In other words is this an SQL.Net not properly installed OracleHomeKey OracleHomeDir Dont have any idea where the problem comes from! If a character is stunned but still has not understand.Well so not clear that? Check that memorymaxtarget. SQL Server: Why does COUNT.
PL/SQL Developer
---------------------------
Initialization error
SQL*Net not properly installed
OracleHomeKey:
OracleHomeDir:
(方法一)下载 ok!
http://download.csdn.net/detail/reginadeng/5857081#comment
(方法二)官方下载
下载32位客户端,配置进navicat中
Oraclehomekey Oraclehomedir
下载地址:http://www.oracle.com/technetwork/topics/winsoft-085727.html
第1步:在上述地址中下载文件:instantclient-basic-nt-11.2.0.3.0.zip

第2步:解压此安装包,并将解压出的文件合并到:D:appDavidproductinstantclient_11_2
第3步:打开Navicat,选择工具→选项→其他→OCI,
设置OCI library为:D:appDavidproductinstantclient_11_2oci.dll
设置SQL *plus为:D:appDavidproduct11.2.0dbhome_1BINsqlplus.exe
点击确定。
第4步:测试成功。
pl/sql> Tools>Preferences>Oracle>Connection> like this. then is ok!!

OracleHomeKey: D:appOracleAdministratorproduct11.2.0
OracleHomeDir:D:appOracleinstantclient-basic-nt-11.2.0.3.0instantclient_11_2oci.dll
D:appAdministratorproduct11.2.0dbhome_1BINoci.dll
D:oracleappAdministratorproduct11.2.0client_1instantclientoci.dll
也可以在pl/sql的安装目录下D:Program Files (x86)PLSQL DeveloperPreferencesAdministratordefault.ini
[Preferences]
CheckConnection=True
SelectedHome=D:appOracleAdministratorproduct11.2.0
OCIFile=D:appOracleAdministratorproduct11.2.0dbhome_1binoci.dll
改成自己在路径。
oracle 配置监听程序

Net Configuration Assistant
system,127.0.0.1:1521/orcl
在64位机器上使用plSQL连接Oracle的问题 SQL Net not properly installed
在64位机器上了64位的oracle客户端。
然后装上PL/SQL Developer,但是连接oracle老报这个错:
Initialization error
SQL*Net not properly installed
OracleHomeKey:
OracleHomeDir:
看网上的说法是到工具-首选项-oracle连接去配置oracle主目录名和oci库的位置。
(Tools-Preferences-Oracle-Connection去配置Oracle Home和OCI library)
配置过后登陆时仍然报错:
Could not load '……/bin/oci.dll'
OCIDLL forced to……
LoadLibrary(……oci.dll) returned 0
解决办法是:在64位的机器上安装32位的Oracle客户端。这样的话便连接成功。
依据:
从安装角度考虑,32bit的平台(操作系统和硬件系统)只支持32bitORACLE的安装;
64bit平台既支持32bitORACLE的安装也支持64位ORACLE的安装;
根据PL/SQL Developer的官方论坛里面的帖子:
quote:
--------------------------------------------------------------------------------
I am not too fond of installing both 32 and 64 bit oracle clients on same machine - does it work at all?
--------------------------------------------------------------------------------
Yes, this works fine. --这是管理员的回复
PL/SQL Developer is written in Delphi.
The first thing that needs to become available is a 64 bit version of the Delphi IDE.
还有另外一个帖子也提到:
Hi when install in Windows Server 2003 R2 X64.
When I try to connect an account , I have the following message :
Initialization error
Could not load'E:/oracle/product/10.2.0/bin/oci.dll'
--以下是管理员的回复
Is this a 64 bit Oracle Client DLL?
If so, please note that you need to install a 32 bit Oracle Client to use a 32 bit application like PL/SQL Developer.
再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!还带黄段子!希望你也加入到我们人工智能的队伍中来!https://blog.csdn.net/jiangjunshow