1. 下载PLSQLDeveloper并解压;
2.在PLSQL\instantclient_11_2文件夹下修改tnsnames.ora文件
连接名称=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =远程端口号)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 数据库名称)
)
)
3.新建环境变量
TNS_ADMIN D:\develop_tool\PLSQL\instantclient_11_2
NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK
4.运行 D:\develop_tool\PLSQL\PLSQL developer\plsqldev.exe且不登录
在工具-->首选项-->连接
Oracle主目录名
D:\develop_tool\PLSQL\instantclient_11_2
OCI库
D:\develop_tool\PLSQL\instantclient_11_2\oci.dll
然后再重新启动并登录