下载PLSQL
下载instantclient_11_2
打开PL/SQL Developer
配置应用 tools->preferences->connection
配置TNS文件
新建环境变量:TNS_ADMIN
内容:D:\Develop\Java\Tools\instantclient_11_2\NETWORK\ADMIN
(tnsnames.ora文件的路径)
保存;
tnsnames.ora文件内容
localhost =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
)