天天看点

怎样在一台机器的listener.ora中配置多个listener

http://blog.csdn.net/yuan330/article/details/1702947

这是我的listener.ora

有两个listener,一个叫LISTENER,另一个叫LISTENER_1

LISTENER在1521端口监听,为两个实例(a和om)服务

LISTENER_1在1522端口监听,为一个实例om服务

一个listener可以为多个实例服务,多个listener可以为同一个实例服务

# LISTENER.ORA Network Configuration File: /home/oracle/product/9.2.0/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1521))

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = om)

      (ORACLE_HOME = /home/oracle/product/9.2.0)

      (SID_NAME = om)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = a)

      (ORACLE_HOME = /home/oracle/product/9.2.0)

      (SID_NAME = a)

    )

  )

LISTENER_1=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1522))

  )

SID_LIST_LISTENER_1 =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = om)

      (ORACLE_HOME = /home/oracle/product/9.2.0)

      (SID_NAME = om)

    )

  )