一、故障现象

    开启数据库时，报出ORA-00119 关于LOCAL_LISTENER参数的错误：

SYS@MTH> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'lsnr2'

二、问题原因

SYS@MTH> !oerr ORA 00119
00119, 00000, "invalid specification for system parameter %s"
// *Cause: The syntax for the specified parameter is incorrect.
// *Action: Refer to the Oracle Reference Manual for the correct syntax.

    实例“MTH”动态注册到“lsnr2” 这个listener，local_listener参数的设定如下，要使实例能够动态注册到“lsnr2”上，必须给local_listener参数指定监听的三要素，即协议、主机名、端口。报错原因是因为只为该参数指定了别名，但是没有具体三要素的信息。

SYS@MTH> set lines 200;
SYS@MTH> show parameter local_listener

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
local_listener                       string                           lsnr2

三、解决方法

1、在tnsnames.ora中添加lsnr2别名的信息

LSNR2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.30.18.70)(PORT = 1521))
    )
  )

SYS@MTH> show parameter local_listener

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
local_listener                       string                           lsnr2

2、设置local_listener参数

SYS@MTH> alter system set local_listener='(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = C01TEST03)(PORT = 1526))))';

System altered.

SYS@MTH> show parameter local_listener;

NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- ------------------------------
local_listener                       string                           (DESCRIPTION =(ADDRESS_LIST =(
                                                                      ADDRESS = (PROTOCOL = TCP)(HOS
                                                                      T = C01TEST03)(PORT = 1526))))

四、总结

    这个问题主要关于：

    1、实例动态注册的原理

    2、别名的应用