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\"下。