PLSQLDeveloper安装与配置

1.下载安装包

链接: https://pan.baidu.com/s/1keU2d5rV86v147cJoNs29w 提取码: srnr

2.解压安装

安装路径
D:\Program Files\PLSQL Developer

配置环境变量支持中文
NLS_CHARACTERSET=AL32UTF8
NLS_LANG=AMERICAN_AMERICA.AL32UTF8

3.设置

配置路径

D:\Program Files\PLSQL Developer\

D:\Program Files\PLSQL Developer\instantclient_19_3\oci.dll

4.配置监听

新建文件D:\Program Files\PLSQL Developer\instantclient_19_3\network\ADMIN\tnsnames.ora

APPORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 110.110.0.110)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

5.登录