配置如下内容即可

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
1) 变量名：ORACLE_HOME  变量值：D:\Program Files\PLSQL Developer 14\instantclient_12_2
2) 变量名：TNS_ADMIN  变量值：D:\Program Files\PLSQL Developer 14\instantclient_12_2\network\admin
3) 变量名：NLS_LANG   变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK
4) 修改Path变量，在后面添加 D:\Program Files\PLSQL Developer 14\instantclient_12_2

编辑文件tnsnames.ora
tnsname=
 (DESCRIPTION=
   (ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=PORT))
   (CONNECT_DATA=
     (SERVER=DEDICATED)
     (SERVICE_NAME=serv_name)
   )
 )