oracle安装本地虚拟机上，用的docker安装
查看oracle是否运行
docker ps:
c1a14ea539b2 registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g "/bin/sh -c ‘/home/o…" 11 months ago Up 6 months 0.0.0.0:1521->1521/tcp oracle_11g
plsqldev：我的安装版本是：11.0.4.1788 64位
第一步：下载oracle client 64版本 11.2xxx ：instantclient-basic-windows.x64-11.2.0.4.0
下载页面：https://www.oracle.com/database/technologies/instant-client/downloads.html
下载地址：https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html#license-lightbox
第二步：将instantclient-basic-windows.x64-11.2.0.4.0解压后，放到C盘：
C:\instantclient_11_2
第三步：配置环境变量：
新建：TNS_ADMIN=C:\instantclient_11_2
新建：NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
修改paht，增加：C:\instantclient_11_2
第四步：配置plsql
工具-》首选项-》链接
第五步：
配置：tnsnames.ora、listener.ora
我的oracle是安装在本地虚拟机，虚拟机ip:192.168.203.225
tnsnames.ora
lygj =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.203.225)(PORT = 1521))
(CONNECT_DATA =
(SID = helowin)
)
)
shanhang =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.203.225)(PORT = 1521))
(CONNECT_DATA =
(SID = helowin)
)
)
listener.ora
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\instantclient_11_2) (PROGRAM = extproc) )