如何修改listener.ora才能让两个DB同时可以分别连接

枪与玫瑰

是不是需要配置两个LISTENER
每个监听一个数据库??
帮我看看下面的配置啊
LISTENER1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = sun420_4)(PORT = 1522))
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sun420_4)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sun420_4)(PORT = 2481))
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /data/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = db
      (ORACLE_HOME = /data/oracle/product/8.1.7)
      (SID_NAME = db
    )
    (SID_DESC =
      (GLOBAL_DBNAME = db8
      (ORACLE_HOME = /data/ora817/product/8.1.7)
      (SID_NAME = db
    )
  )

SID_LIST_LISTENER1 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = Oracle
      (ORACLE_HOME = /data/oracle/product/8.1.7)
      (SID_NAME = ORCL)
    )
  )

yaming

一个listener可以监听多个database,当然，多个listener分别监听也行。