1.安装oracle客户端
oracle官网下载地址:
https://www.oracle.com/database/technologies/instant-client/downloads.html
下载之后解压;
进入如下目录:
放入 tnsnames.ora文件;我的内容如下,仅供参考
# tnsnames.ora Network Configuration File:
TEST_DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx.xxxx.xxxx.xxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl)
)
)
2.安装好PLSQL之后,登录界面点击取消,直接进入后配置首选项:
如上配置完成之后,重启plsql即可