DanBrother的部落格

ASM instance was not registered on LISTENER

Issue:
ASM instance was not registered on LISTENER after apply grid infrastructure patch on one Oracle 11gR2 RAC server node.

Cause:
For some reason, local_listener was pointed to the wrong HOST (ip address).

[grid@RAC3 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 03-DEC-2013 17:47:26

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                03-DEC-2013 17:14:49

Uptime                  0 days 0 hr. 32 min. 37 sec
Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/grid/grid11203/network/admin/listener.ora

Listener Log File         /u01/grid/orabase/diag/tnslsnr/RAC3/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=168.95.2.11)(PORT=15210)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=168.95.2.21)(PORT=15210)))

Services Summary...

Service "RACDB" has 1 instance(s).

  Instance "RACDB3", status READY, has 3 handler(s) for this service...

The command completed successfully

[grid@RAC3 ~]$ ps -ef | grep asm_pmon | grep -v grep

grid     21822     1  0 Dec03 ?        00:00:01 asm_pmon_+ASM3

[grid@RAC3 ~]$ export ORACLE_SID=+ASM3

[grid@RAC3 ~]$ sqlplus / as sysasm

SQL> sho parameter local_listener

NAME                  TYPE    VALUE

------------------------------------ ----------- ------------------------------

local_listener            string   (DESCRIPTION=(ADDRESS_LIST=(ADRESS=         
(PROTOCOL=TCP)(HOST=168. 95.2.20) (PORT=1521))))

Solution:
Change the local_listener setting to point to the correct HOST (ip address) as follows:

SQL> alter system set - local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=168.95.2.21)(PORT=1521))))' scope=both sid='RACDB3';