Knowledge Base

How to perform manual association for Oracle databases running on Dell infrastructure using Dell open manage plugin for Oracle enterprise manager 12c?


Author:
Krishna Kamal Kapa

Problem:
How to perform manual association for Oracle Databases running on Dell infrastructure using Dell Open Manage Plugin for Oracle Enterprise Manager 12c?

Solution:
Manual mapping/association provides grouping of Dell devices like server, storage and switches to the Oracle Databases to provide a topology view of the entire infrastructure. This greatly enhances the monitoring capabilities of the OpenManage plug-in for OEM and also the ability to analyze issues or trends in data and understand other areas in the infrastructure that may be impacted. The association for Dell storage and switch needs to be done manually in the Oracle Enterprise Manager

This wiki article helps to set up the manual association in the Oracle Enterprise Manager using the below steps.

1) Login to Oracle Enterprise Manager using SYSMAN or administrative privileges.
2) Navigate to Setup à Add Target à Generic System

Manual Association
Figure 1: SYSMAN

3) In the Create Generic System Page: Provide the system name, time zone

Click on Add in Members section.

Select the Dell OME Server, Dell OME Storage, Dell OME Switch and Cluster Database target types.
Manual Association 2
Figure 2: Dell OME Server

4) Select the respective Dell devices and the Oracle cluster database where it is running.
Manual Association 3
Figure 3: Dell devices and the Oracle cluster database

5) Dell Server, Storage, switch and Oracle database are listed in the members section. Click on Next

Also select "Include targets that selected members directly depend on"
Manual Association 4
Figure 4: Dell Server, Storage, switch and Oracle database

6) Define the associations between the Oracle database and the Dell infrastructure by clicking on Add

Select the Oracle Database and Dell OME Server association: Select the Cluster Database in Member Target and then select the Dell OME server on the Associated Target. Select the association as "Installed At". Click on Ok.

Manual Association 5
Figure 5: Dell OME Server association

Select the Oracle Database and Dell OME Storage association: Select the Cluster Database in Member Target and select the Dell OME Storage on the Associated Target. Select the association as "Stores on Database". Click on Ok.

Manual Association 6
Figure 6: Cluster Database in Member Target

Select the Oracle Database and Dell OME Switch association: Select the Cluster Database in Member Target and select the Dell OME Switch on the Associated Target. Select the association as "Connects Through". Click on Ok.
Manual Association 7
Figure 7: Select the Cluster Database

7) The associations are shown between Oracle database and Dell devices.
Manual Association 8
Figure 8: Associations

8) Provide the order of the topology view by moving targets from the members to key members in the order of consideration.
Manual Association 9
Figure 9: Topology view

9) Create Generic System: Charts page will be displayed with the metrics listed. Click on Next
Manual Association 10
Figure 10: Generic System

10) Review the summary page and click Finish
Summary Page
Figure 11: Summary Page

11) Once the Generic system is created, navigate to the respective cluster database home page.

And select Cluster Database à Configuration à Topolog
Manual Association 12
Figure 12: Cluster Database
12) The below figure shows the topology view of the entire infrastructure and its connectivity to each target. The topology has the Dell Server, storage and switches along with Oracle ASM instances, Oracle Cluster database and the Oracle Homes.
Manual Association 13
Figure 13: Topology view of the entire infrastructure
The cross mark on some targets only refers to some alerts trigger for that target (it’s not the status of any target)




Article ID: SLN310936

Last Date Modified: 08/14/2018 02:12 AM


Rate this article

Accurate
Useful
Easy to understand
Was this article helpful?
Yes No
Send us feedback
Comments cannot contain these special characters: <>()\
Sorry, our feedback system is currently down. Please try again later.

Thank you for your feedback.