Solving Oracle11g Grid Control: Metric Collection Error :
SQL> select account_status from dba_users where username = 'DBSMMP';
SQL> alter user dbsnmp identified by 'test';
./emctl config agent listtargets
./emctl config agent credentials
[oracle@RAC1 bin]$ ./emctl config agent credentials TESTDB_TESTDB1:oracle_database
Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Name = TESTDB_TESTDB1, Type = oracle_database
Want to change for "UserName" (y/n):n
Want to change for "password" (y/n):y
Enter the new value for "password" :****************
Re-enter the new value for "password" :****************
EMD reload completed successfully