使用plsql远程连接数据库需要安装plsql工具+ oracle的远程客户端
![](https://images2017.cnblogs.com/blog/1007124/201709/1007124-20170929145204856-966448190.png)
![](https://images2017.cnblogs.com/blog/1007124/201709/1007124-20170929145307122-1018899628.png)
![](https://images2017.cnblogs.com/blog/1007124/201709/1007124-20170929145331950-891998208.png)
在不登录的状态打开plsql:
![](https://images2017.cnblogs.com/blog/1007124/201709/1007124-20170929145424747-28856252.png)
点击工具---首选项:指定oracle客户端的安装路径:
C:javaSoftPLSQLinstantclient_11_2
C:javaSoftPLSQLinstantclient_11_2oci.dll
![](https://images2017.cnblogs.com/blog/1007124/201709/1007124-20170929145525512-112853222.png)
编辑客户端中tnsnames.ora的文件:需要注意的是添加远程ip的时候需要同事添加监听;如下所示是一组监听的连接远程数据库的配置,要是连接不同的远程的机器的数据库需要配置多组:
转载原文作者链接:https://www.cnblogs.com/yangjian-java/p/6946973.html