oracle11gr2 监听服务不起作用

 

1. 监听端口打开：

192.168.44.97:1521      0.0.0.0:*               LISTEN

2. sqlplus 连不上，tnsping也失败

3.  alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.97)(PORT=1521))' scope=both;

   alter system register;解决，但lsnrctl status发现push service有2条push instance 记录，一个为ready动态注册)，另一个为unkown（静态注册）。

======================================================

oracle@uma1:~/product/11.2.0/dbhome_2/network/admin> cat  listener.ora
# listener.ora Network Configuration File: /home/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.44.97)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
SID_LIST_LISTENER = 
  (SID_LIST = 
  (SID_DESC = 
  (GLOBAL_DBNAME = push)
  (SID_NAME = push)
  )
)
ADR_BASE_LISTENER = /home/oracle

 

====================================================================