EM 12c: ASM Login is Blocked from Enterprise Manager 12c Cloud Control with Error: ORA-12528, TNS:listener: all appropriate instances are blocking new connections (Doc ID 1683514.1)

Last updated on MAY 06, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.5.0 and later
Information in this document applies to any platform.

Symptoms

Environment:

Enterprise Manager (EM) 12.1.0.3 Cloud Control, using the 12.1.0.5 database plug-in

Target database (10.2.0.4) with ASM

 

Attempts to access an ASM instance from the EM 12c console result in the following error:

ORA-12528, TNS:listener: all appropriate instances are blocking new connections

Checking the listener status, the ASM instance is shown as BLOCKED.
Remote connections and administration cannot be performed in this case for the ASM instance.

$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 02-JUN-2014 13:37:28

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                02-JUN-2014 12:06:50
Uptime                    0 days 1 hr. 30 min. 37 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/10.2.0/network/admin/listener.ora
Listener Log File         /oracle/product/10.2.0/network/log/listener.log
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521)))
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...


Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms