listener 靜態(tài)注冊(cè)后無法遠(yuǎn)程連接，動(dòng)態(tài)注冊(cè)后可以

znn19850323

回復(fù) 10# aric


  下面是我linux 服務(wù)器上的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