Sql/Plus串連Oracle時候出現sql*net not properly installed 解決辦法

來源:互聯網
上載者:User

標籤:

在PLSQL Developer選擇Tools > Preferences > options > 下的:"Oracle Home" and "OCI Library"

Oracle10g裝在d:/oracle/ Oracle Home為d:/oracle/product/10.1.0

OCI Library為d:/oracle/product/10.1.0/Db_1/BIN/oci.dll

配置完以後重新啟動PLSQL Developer,登入成功


配置過後登陸時仍然報錯:
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.

呼,終於解決了,在客戶的web機上無法用PL/SQL連到linux上的Oracle資料庫

Sql/Plus串連Oracle時候出現sql*net not properly installed 解決辦法

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.