Saturday, December 29, 2007

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
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
Copyright (c) 2002, 2003 Oracle Corporation. All rights reserved.
Name =, 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

Oracle EM Grid Control – Notification Rules

Notification Rules are the way of Enterprise Manager warns you. You may want to be warned about “tablespace space usage percentage”, “data block corruption alert log entries” or anything else that you think it is critical for you. You can create a rule from scratch or you can also use Public Rules. Public Rules are also customizable for your needs. Here, I will create a rule from scratch for an example. Extenting and customizing a Public Rule has no differences in logical manner.


- In “Preferences” Page, click to “My Rules” under “Notification” Tab. “My Notification Rules” page will appear.
- Click “Create” button to create a rule (figure_1)


- There are six tabs on the screen. First one is “General”, here you should enter the “Name” of the rule, and the “Target Type” you want to apply the rule (in this example the Target Type is Database Instance).

- You can also identify which targets you want to apply the rule you created. To do this you should select one of the two choices. You can apply the rule to all of the database instances or you can apply the rule to only one instance (figure_2)


- If you select to apply the rule to a specific database instance click the second radio button. A new list appears. This is the list of the database instances that your rule will apply.

- Click “Add” Button to add database instances (figure_3)


- Target selector appears when you click to the “Add” button. Here you can select which target(s) you want to apply your rule. Select “Target Type” and Targets you want to apply the rule and click “Select” button to make your choice permanent.

- After you complete with this tab click to the next tab “Availability” (figure_4)


- You can set the availability of the agent states and you can be notified by the state changes. You can set “agent unreachable” , “metric error” and “blackout” states and their cleared problems to notify you (figure_5)


- “Metrics” tab is probably the most handy tab here. By this tab you can add more than a hundred metric to watch an instance. We will add “Generic Alert Log Error” metric in this example. By using this metric, one would never need to write a script to search alert.log for errors and send email instead this metric does the same thing four you.
- Click “Add” button to add a metric (figure_6)


- You can find the metrics by clicking “next” link for every 10 records until you find the “Generic Alert Log Error”
- After selecting the specified metric go to the bottom of the page (figure_7)


- You will find “Severity States” section here. Select any state you want to be within this metric. In this example I will select both “Critical” and “Warning” levels.
- You may want to be informed when the problem is cleared. Look “Corrective Action States” section to select which corrective actions should inform you.
- After your selections are complete Click “Continue” Button (figure_8)


- You will see the added Metric in the “Metrics” Tab.
- Click “OK” button to complete the rule creation.


- If the rule is created successfully you should see a rule in the “My Rules” Tab.
- If you want to be informed with this rule select the “Subscribe (Send Email)” column and click “Apply” button.

Oracle EM Grid Control – Changing User Password

How to change your own user password and preferences in Oracle Enterprise Manager Grid Control (OMS) Console.


- To change your password, one should use “Preferences” Link above the tabs as shown in the figure_1.


- To change your password, you should first enter your “current password” to the related field. And then you can enter your “New Password” twice to the related fields. After you finished filling the boxes simply click to “Apply” button (figure_2)

- You can also change your contact information by using “E-Mail Addresses” section in the page. You can add new email address by clicking “Add Another Row” button. New row will appear instantly under your existing email address. You should write your new email address and click apply button as shown in the figure (figure_2)

- To remove an email address, select the address you want to delete and simply click “Remove” button. Selected email address will disappear immediately. You must click “Apply” button to make the changes permanent (figure_2)

- You can also test your contact email address by selecting your email address and click on the “Test” button. A test email will be sent to your email address (figure_2)


- “Information Page” after your password successfully changes (figure_3)


- “Information Page” after you test your email address (figure_4)