虚拟机上安装Oracle11gR2 PLSQL无法远程连接问题修复

1、关闭默认防火墙

1. systemctl stop firewalld.service #停止firewall  
2. systemctl disable firewalld.service #禁止firewall开机启动  
3. firewall-cmd --state #查看默认防火墙状态（关闭后显示notrunning，开启后显示running）
4. 建议不要使用默认防火墙，配置iptables防火墙，参考：http://gqsunrise.iteye.com/blog/2370140

 

2、修改安装目录下的listener.ora（/oracle/product/**/network/admin/listener.ora）

修改前：
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

 

修改后：
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = /oracle/product/11.2.0/db_1/)
      (SID_NAME = orcl)
    )
    (SID_DESC =
       (GLOBAL_DBNAME = orcl)
       (ORACLE_HOME = /oracle/product/11.2.0/db_1/)
       (SID_NAME = orcl)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

 3、重启监听、重启Oracle服务