listener 静态注册后无法远程连接，动态注册后可以

znn19850323

回复 10# aric


  下面是我linux 服务器上的listener.ora:

[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LSN2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
    )
  )

SID_LIST_LSN2 =
    (SID_LIST =
    (SID_DESC =
         (GLOBAL_DBNAME = orcl)
          (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
          (SID_NAME = orcl)
      )
)

ADR_BASE_LISTENER = /u01/app/oracle