在64位机器上了64位的oracle客户端。 然后装上PL/SQL Developer,但是连接oracle老报这个错: Initialization error SQL*Net not properly installed
Oraclehomekey Software Oracle Oraclehomedir
OracleHomeKey: OracleHomeDir:
On win7 64 bit, PL/SQL Developer client login message: 'Initailization error, SQL.Net not properly installed, OracleHomeKey:;OracleHomeDir:'. The server is a remote server, I only have a sql client, because I can access database via java code, so thought that the tnslistener has been started on that server, am I right? Our formula at Oracle Homes is designed to ensure that we deliver a product that we can be proud of.
看网上的说法是到工具-首选项-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
根据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.
Oracle Home Key Oraclehomedir
还有另外一个帖子也提到: Hi when install in Windows Server 2003 R2 X64.
Oraclehomekey Oracle Home Dir
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.