ASM Instance Showing Down In 11g Grid Control With Error ORA-15000

(Doc ID 1276657.1)

Last updated on MAY 06, 2016

Applies to:

Enterprise Manager Base Platform - Version 11.1.0.1 to 11.1.0.1 [Release 11.1]
Information in this document applies to any platform.
Checked for relevance on 30-MAR-2013
Checked for relevance on 03-Sep-2014

Symptoms

ASM 11.2
Agent Version : 11.1.0.1.0
OMS Version : 11.1.0.1.0

ASM shows down in Grid Control . The collection error for the status metric is :
ORA-15000: command disallowed by current instance type (DBD ERROR: OCISessionBegin)

select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE FALSE

Testing the connection as follows it's working:

sqlplus sys/<password>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myasmhost)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))" as sysdba;

sqlplus sys/<password>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myasmhost)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))" as sysasm;

sqlplus ASMSNMP/<password>@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myasmhost)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A)))" as sysdba;

emagent_perl.trc shows:

dbGetAdrHome.pl: Thu Oct 14 18:52:33 2010: WARN: get_diag_info_from_db: Could not connect to sys/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOS
T=myasmhost)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+ASM1)(INSTANCE_NAME=+ASM1)(UR=A))): ORA-15000: command disallowed by current insta
nce type (DBD ERROR: OCISessionBegin)

Changes

Monitoring configuration is set to use the SYSASM role for the instance SYS user.

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