1、用plsql连不上oracle 11g(64位),先去下载一个oracle 11g(32位客户端)

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html (可用迅雷下载)

2、安装客户端后,需要在plsql设置首选项中设置url,

tool-

  -preferences

  -oracle-

    connection中

Oracle Home = “D:\oracle\product\instantclient_11_2”

OCI library = "D:\oracle\product\instantclient_11_2\oci.dl"

3、将oracle服务器端的文件夹"D:\oracle\product\11.2.0\dbhome_1\NETWORK",copy到"D:\oracle\product\instantclient_11_2\"下。

05-11 15:51