Oracle 复杂监听配置

1.一个监听配置多个IP地址


1）默认单个监听的监听LISTENER配置
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = tst104)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )


2）增加一个IP地址，监听多个IP，监听配置改为：


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 168.60.40.104)(PORT = 1521)))
      (ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
      (ADDRESS_LIST=
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
    )
  )




2.配置一个监听，监听不同端口


LISTENER =