oracle 配置两个监听

今天在一台contos 5.4 + oracle 10g r2 环境下 创建了第二个实例
根据需要再创建一个监听 端口号用1522

因为之前已经有一个实例  而且也创建了监听listener 端口号是1521 

我用netca创建的监听 命名为listener02 用的是1522端口

可是启动监听listener02 确不能加载服务 新建的实例也不能在listener中加载

于是我看了一下配置文件 listener。ora

发现有些不对

经改正内容如下

[oracle@bybon admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10g//network/
admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = xxxio)
      (ORACLE_HOME = /u01/app/oracle/product/10g/)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = +ASM)
      (ORACLE_HOME = /u01/app/oracle/product/10g/)
    )

    (SID_DESC =
      (SID_NAME = xxxxdb)
      (ORACLE_HOME = /u01/app/oracle/product/10g/)
    )
  )

SID_LIST_LISTENER02 =
  (SID_LIST =

    (SID_DESC =
      (SID_NAME = xxxdb)
      (ORACLE_HOME = /u01/app/oracle/product/10g/)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )

  )

LISTENER02 =
  (DESCRIPTION_LIST =

    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
    )
  )

这里做些建单的说明
1.

LISTENER02 =       ----这里是监听的名字 ,因为我创建了两个监听，并起名listener02
  (DESCRIPTION_LIST = -- 以下是对监听的描述

    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
    )
  )

2.

SID_LIST_LISTENER02 = --这里配置的监听加载的服务 ，命名要和上面的监听名相对应。SID_LIST_监听名。通过这的配置来说明此监听为那些sid服务
  (SID_LIST =

    (SID_DESC =
      (SID_NAME = xxxdb)
      (ORACLE_HOME = /u01/app/oracle/product/10g/)
    )
  )