Metric collection Error in targets status page at OMS Console

Problem: Metric Collection Error in Oracle EM Grid Control Server (OMS) console

Possible problem in dbsnmp password on target host.

Solution: Oracle Enterprise Manager Agent uses dbsnmp account to gather database wide information. If the user locked or its password other than something non default, you should unlock the user and configure agent with the new password. Check out the following steps.

SQL> alter user dbnsmp account unlock;
SQL> alter user dbnsmp identified by ;

[oracle@raquality00 bin]$ ./emctl config agent listtargets
Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
[raquality00:3872, oracle_emd]
[raquality00, host]
[raqcrs, cluster]
[RADB_RADB1, oracle_database]
[RADB, rac_database]
[LISTENER_RAQUALITY00_raquality00, oracle_listener]

$PROMPT> ./emctl config agent credentials RADB_RADB1:oracle_database
Oracle Enterprise Manager 10g Release 10.1.0.2.0
Copyright (c) 2002, 2003 Oracle Corporation. All rights reserved.
Name = emrep10.us.oracle.com, Type = oracle_database

Want to change for "UserName" (y/n):n
Want to change for "password" (y/n):y
Enter the value for "password" :*******

EMD reload completed successfully