1.先安装好plsqldev1105_x64.exe
2.解压instantclient_11_2文件
3.打开plsqldev1105_x64,出现登录界面,点击cancel
4.点击软件中的tools中的preferences中Connection
C:\Program Files\PLSQL Developer 13\instantclient_11_2
C:\Program Files\PLSQL Developer 13\instantclient_11_2/oci.dll
(注:如若自定义安装目录,填写正确安装目录)
随后点击ok选项
5.查看instantclient_11_2目录下是否存在\xxxx\instantclient_11_2\NETWORK\ADMIN\tnsnames.ora
如若不存在,请自行按照以上正确路径创建(可先创建成文本,随后改为.ora格式)
WFZB_243 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxxx)
)
)
注:
https://www.cnblogs.com/xyhero/p/6ad6292d7fbac9cd08e1be2ed674dc7a.html