Blocked status of RAC listeners

Blocked status of the listening program ASM Service

By default, the monitor does not accept the connection from another node to the ASM instance.

The status of the Service created for ASM is "blocked", indicating that the instance cannot be connected.

Ora10gasm-> LSNRCTL status

LSNRCTL for Linux: Version 10.2.0.1.0-production on 08-jun-2008 07:39:03

Copyright (c) 1991,200 5, Oracle. All rights reserved.

Connecting to (description = (address = (Protocol = TCP) (host = ora10gasm) (Port = 1521 )))
Status of the listener
------------------------
Alias listener
Version tnslsnr for Linux: Version 10.2.0.1.0-Production
Start date 08-jun-2008 07:14:45
Uptime 0 days 0 HR. 24 min. 18 Sec
Trace Level off
Security on: Local OS Authentication
SNMP off
Listener parameter file/Oracle/product/10.2.0/db_1/Network/admin/listener. ora
Listener log file/Oracle/product/10.2.0/db_1/Network/log/listener. Log
Listening endpoints summary...
(Description = (address = (Protocol = TCP) (host = ora10gasm) (Port = 1521 )))
(Description = (address = (Protocol = TCP) (host = ora10gasm) (Port = 2100) (Presentation = FTP) (session = raw ))
Services summary...Service "+ ASM" has 1 instance (s ).
Instance "+ ASM", status blocked, has 1 handler (s) for this service...
Service "+ asm_xpt" has 1 instance (s ).
Instance "+ ASM", status blocked, has 1 handler (s) for this service...Service "plsextproc" has 1 instance (s ).
Instance "plsextproc", status unknown, has 1 handler (s) for this service...
Service "Benbo" has 1 instance (s ).
Instance "Benbo", status ready, has 1 handler (s) for this service...
Service "benboxdb" has 1 instance (s ).
Instance "Benbo", status ready, has 1 handler (s) for this service...
Service "benbo_xpt" has 1 instance (s ).
Instance "Benbo", status ready, has 1 handler (s) for this service...
The command completed successfully

Blocked: indicates that the instance cannot be connected.
Unknown: indicates that this instance is registered in the listener. ora file instead of through dynamic service registration, so it does not know its status
Ready: indicates that the instance can be connected.

You can modify the listener. ora file and register the ASM instance statically so that clients can log on to other hosts.
Ora10gasm-> VI/Oracle/product/10.2.0/db_1/Network/admin/listener. ora

(Program = EXTPROC)
# Listener. ora network configuration file:/Oracle/product/10.2.0/db_1/Network/admin/listener. ora
# Generated by Oracle configuration tools.

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME =/Oracle/product/10.2.0/db_1)
(Program = EXTPROC)
)(Sid_desc =
(Sid_name = + ASM)
(ORACLE_HOME =/Oracle/product/10.2.0/db_1)
))

Listener =
(Description_list =
(Description =
(Address = (Protocol = TCP) (host = ora10gasm) (Port = 1521 ))
(Address = (Protocol = IPC) (Key = extproc0 ))
)
)

"Product/10.2.0/db_1/Network/admin/listener. ora" 24l, 583c written

Reload the listener Information
Ora10gasm-> LSNRCTL RELOAD

LSNRCTL for Linux: Version 10.2.0.1.0-production on 08-jun-2008 07:40:40

Copyright (c) 1991,200 5, Oracle. All rights reserved.

Connecting to (description = (address = (Protocol = TCP) (host = ora10gasm) (Port = 1521 )))
The command completed successfully
Ora10gasm-> LSNRCTL status

LSNRCTL for Linux: Version 10.2.0.1.0-production on 08-jun-2008 07:40:51

Copyright (c) 1991,200 5, Oracle. All rights reserved.

Connecting to (description = (address = (Protocol = TCP) (host = ora10gasm) (Port = 1521 )))
Status of the listener
------------------------
Alias listener
Version tnslsnr for Linux: Version 10.2.0.1.0-Production
Start date 08-jun-2008 07:14:45
Uptime 0 days 0 HR. 26 min. 6 sec
Trace Level off
Security on: Local OS Authentication
SNMP off
Listener parameter file/Oracle/product/10.2.0/db_1/Network/admin/listener. ora
Listener log file/Oracle/product/10.2.0/db_1/Network/log/listener. Log
Listening endpoints summary...
(Description = (address = (Protocol = TCP) (host = ora10gasm) (Port = 1521 )))
(Description = (address = (Protocol = TCP) (host = ora10gasm) (Port = 2100) (Presentation = FTP) (session = raw ))
Services summary...
Service "+ ASM" has 2 instance (s ).
Instance "+ ASM", statusUnknown, Has 1 handler (s) for this service...
Instance "+ ASM", status blocked, has 1 handler (s) for this service...
Service "+ asm_xpt" has 1 instance (s ).
Instance "+ ASM", status blocked, has 1 handler (s) for this service...
Service "plsextproc" has 1 instance (s ).
Instance "plsextproc", status unknown, has 1 handler (s) for this service...
Service "Benbo" has 1 instance (s ).
Instance "Benbo", status ready, has 1 handler (s) for this service...
Service "benboxdb" has 1 instance (s ).
Instance "Benbo", status ready, has 1 handler (s) for this service...
Service "benbo_xpt" has 1 instance (s ).
Instance "Benbo", status ready, has 1 handler (s) for this service...
The command completed successfully

Configure the client tnsnames. ora and add the connection identifier to ASM.

ASM =
(Description =
(Address = (Protocol = TCP) (host = 192.168.1.111) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = + ASM)
)
)

C:> sqlplus sys/Oracle @ ASM as sysdba

SQL * Plus: Release 11.1.0.6.0-production on Sunday June 8 10:38:14 2008

Copyright (c) 1982,200 7, Oracle. All rights reserved.

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options

SQL>