双实例主机遇到的ORA-00119 ORA-00132错误

    在Fedora上安装了一个oracle 10g 10204 sid=demo，然后用dbca又创建了一个数据库sid=rman作为demo的catalog数据库。其中为demo注册的监听是 listener，1521；为rman注册的监听是listener_rman,1621 建好之后，修改例如如下监听设置

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = demo)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (SID_NAME = demo)

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

    )

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

  )

SID_LIST_LISTENER_RMAN =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = rman)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (SID_NAME = rman)

    )

  )

LISTENER_RMAN =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = WarCraft)(PORT = 1621))

    )

  )

，设置完成，分别用各自的tns登录都是正常，不料想 第二天启动数据库的时候报错：

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_RMAN'

查看了oracle reference官方文档，发现需要给local_listener参数进行设置，
解决办法如下：
$ cd $ORACLE_BASE/admin/rman/pfile
$ cp init.ora.423201117532 init.ora
$ vi init.ora 添加如下行
local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WarCraft)(PORT=1621)))'
$ sqlplus "/as sysdba"
SQL> create spfile from pfile='/u01/app/oracle/admin/rman/pfile/init.ora';
SQL> startup

正常启动，问题得到解决。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12216142/viewspace-702170/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12216142/viewspace-702170/