PLSQL Developer 没有64位的版本,用下面的方法连接64位oracle (http://www.sql-plus.com)
使用PL/SQL Developer连接OracleX64版本:
1.下载32位Oracle InstantClient,(http://www.oracle.com/technetwork/cn/topics/winsoft-095945-zhs.html)
2.解压到某目录,例如:D:\instantclient_11_2
3.将oracle的tnsnames.ora拷贝到该目录下;
4.在PLSQL Developer中设置Oracle_Home和OCI Library:
ToolsPreferencesOracleConnection:
Oracle_Home:D:\instantclient_11_2
OCI Library:D:\instantclient_11_2\oci.dll
5.在PLSQL Developer目录下新建如下bat文件搜索,替换其快捷方式,启动PLSQL Developer:
@echo off
set path=D:\instantclient_11_2
set ORACLE_HOME=D:\instantclient_11_2
set TNS_ADMIN=D:\instantclient_11_2
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe