Grid Control Gets Metric Collection Error On ASM Database - Status Unknown / Unavailable (Doc ID 291763.1)

Last updated on AUGUST 25, 2017

Applies to:

Enterprise Manager Base Platform - Version 10.1.0.2 to 11.1.0.1 [Release 10.1 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 15-Feb-2013

Symptoms

The status of the ASM instance in the Grid Control console shows up as "Unavailable".
The ASM home page shows a Metric Collection Error.

The DBSNMP is using the default password and can connect using SQLPLUS to the +ASM instance.

The Central Agent monitoring the ASM instance records the error message below in the log file $ORACLE_HOME/sysman/log emagent.trc:

2004-11-18 17:52:31 Thread-14 WARN vpxoci: OCI Error -- ErrorCode(1017): ORA-01017: invalid
username/password; logon denied

SQL = " OCISessionBegin"...
LOGIN =
sys/<PW>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Host1)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=+A
M)(INSTANCE_NAME=+ASM)(UR=A)))

2004-11-18 17:52:31 Thread-14 ERROR vpxoci: ORA-01017: invalid username/password; logon denied
2004-11-18 17:52:31 Thread-14 WARN vpxoci: Login 0x59c3c0 failed, error=ORA-01017: invalid
username/password; logon denied
2004-11-18 17:52:31 Thread-14 WARN TargetManager: Exception in computing dynamic properties of
{+ASM_SID1, osm_instance },Config::ORA-01017: invalid username/password; logon denied
2004-11-18 17:52:31 Thread-14 WARN vpxoci: OCI Error -- ErrorCode(1017): ORA-01017: invalid
username/password; logon denied

The Central Agent log file $ORACLE_HOME/sysman/emagent_perl.trc shows:

oracledb.pl: Thu Nov 18 17:52:18 2004: ERROR: initParameterFileUtl::convertSPFileToPFile: Failed
to convert spfile /prg/oracle/ora10g/dbs/spfile+ASM.ora to pfile using sqlplus: Illegal seek 0.
The output of sqlplus is "
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 18 17:52:18 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> SP2-0640: Not connected
SQL> "
oracledb.pl: Thu Nov 18 17:52:18 2004: ERROR: initParameterFileUtl::convertSPFileToPFile: Failed
to convert spfile /prg/oracle/ora10g/dbs/spfile+ASM.ora to pfile using sqlplus: Illegal seek 0.
The output of sqlplus is "
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 18 17:52:18 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> ERROR:
ORA-01031: insufficient privileges


SQL> SP2-0640: Not connected
SQL> "
oracledb.pl: Thu Nov 18 17:52:19 2004: ERROR: initParameterFileUtl::convertSPFileToPFile: Failed
to convert spfile +DG_DES_DATA/orades01/spfileorades01.ora to pfile using sqlplus: Illegal seek
0. The output of sqlplus is "
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 18 17:52:19 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> ERROR:
ORA-01031: insufficient privileges

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