plsqldev配置oracle数据监听

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)
    )