Author:

Krishna Kamal Kapa

Problem:

How to discover Dell servers in Dell Open Manage Essentials for auto association of Oracle Databases in Oracle Enterprise Manager using Dell OpenManage plug-in?

Solution:

Dell OpenManage Plug-in for Oracle Enterprise Manager provide a proactive approach to data center management that delivers features for monitoring Dell server, storage, and networking infrastructures in an environment managed by Oracle Enterprise Manager (OEM)

This wiki article is specific for Oracle customers who would like to have the auto association of Oracle Databases to Dell infrastructure in Enterprise Manager using Dell OpenManage plug-in. It describes about the best practices to discover the Dell Servers in Open Manage Essentials to achieve the auto association.

The discovery of Dell servers into OME can be achieved using the following ways.

  • OpenManage Server Administrator  (OMSA) with Dell Agent
  • Agent free Integrated remote access controllers (iDRAC)

1.1 OpenManage Server Administrator (OMSA) with Dell Agent:

To perform the discovery of Dell servers using OMSA, install the OMSA software in the respective Dell server which needs to be monitored. The installation process of OMSA can be found here. Also view the complete OMSA compatibility matrix at the below link.

http://support.dell.com/support/edocs/SOFTWARE/smcomp/3.0/PDF/CompatibilityMatrix.pdf

After the installation of OMSA, discover the server in Open Manage Essentials using OMSA with the below steps.

1) Access the OME console

2) Navigate to Manage -> Discovery and Inventory -> Discovery Ranges

3) Right Click on All Ranges and Click on Add Discovery Range

4) Provide the host IP address/range, name of the range/host and the subnet. Click on Add and Click Next

5) Retain the default values of ICMP parameters and click Next

6) Select the check box to use SNMP protocol for discovery and specify Get Community as “Public” with default timeouts. Click Next


Note: To configure the snmp protocol and setting the community to public for the host where OMSA is installed, refer section “Configuring Dell PowerEdge Linux Servers with Dell OpenManage Server Administrator (OMSA)” here

7) Provide the WMI details in case of a windows host and click Next

8) Ignore Storage Configuration and click Next: This screen is only used to set the options to discover PowerVault Modular Disks or Dell | EMC Devices.

9) Ignore WS-Man Credentials and click Next: This screen is used to set the options to configure WS-Man parameters for discovering ESXi-installed devices or iDRAC .

10) Enable SSH discovery for linux hosts with the host credentials.

11) Ignore IPMI Configuration and click next

12) Specify Perform both discovery and inventory and click Next

13) Review the complete inputs and click Finish.

The discovered server will be shown under Manage -> Devices -> Servers section with the hostname

1.2 Agent free Integrated remote access controllers (iDRAC)

To perform the auto association of Oracle Databases in Enterprise Manager when discovery using iDRAC, users has to discover the server twice as below

1) Discover the server using OS IP with SSH enabled

2) Then discover the server using the iDRAC IP

Note: When discover a server using iDRAC IP, the OME identifies as RAC_<servicetag> for which the auto association of databases will not happen in Oracle Enterprise manager.  The auto association of Oracle Databases happens based on the hostname displayed in OME and OEM.

1.2.1 Discover the server using OS IP with SSH enabled:

1) Access the OME console

2) Navigate to Manage -> Discovery and Inventory -> Discovery Ranges

3) Right Click on All Ranges and Click on Add Discovery Range

4) Provide the host IP address/range, name of the range/host and the subnet. Click on Add and Next

5) Leave the default values of ICMP parameters and click Next

6) Disable SNMP protocol by unselecting the check box.

7) Provide the WMI details in case of a windows host and unselect if it’s a linux host. Click Next

8) Ignore Storage Configuration and click Next: This screen is only used to set the options to discover PowerVault Modular Disks or Dell | EMC Devices.

9) Ignore WS-Man Credentials and click Next: This screen is used to set the options to configure WS-Man parameters for discovering ESXi-installed devices or iDRAC .

10) Enable SSH discovery for linux hosts with the host credentials.

11) Ignore IPMI Configuration and click next

12) Specify Perform both discovery and inventory and click Next

13) Review the complete inputs and click Finish.

The discovered server will be shown under Manage -> Devices -> Servers section with the hostname. The health status of the target will be in ? state.

1.2.2 Discover the server using iDRAC IP

1) Access the OME console

2) Navigate to Manage -> Discovery and Inventory -> Discovery Ranges

3) Right Click on All Ranges and Click on Add Discovery Range

4) Provide the host IP address of iDRAC, name of the range/host and the subnet. Click on Add and Next

5) Leave the default values of ICMP parameters and click Next

6) Select the check box to use SNMP protocol for discovery and specify Get Community as “Public” with default timeouts. Click Next

7) Ignore WMI details

8) Ignore Storage Configuration and click Next: This screen is only used to set the options to discover PowerVault Modular Disks or Dell | EMC Devices.

9) Enable WS-Man Credentials (root/password) to configure WS-Man parameters for discovering using iDRAC .

10) Disable SSH Configuration by unselecting the check box.

11) Ignore IPMI Configuration and click next

12) Specify Perform both discovery and inventory and click Next

13) Review the complete inputs and click Finish.

The discovered iDRAC server will be shown under Manage -> Devices -> RAC section with the hostname. The health status of the target will be in UP state.

As the discovery is performed with SSH and iDRAC, the same server will be listed under Servers and RAC categories.

Note: This is the design of the OME where the duplicate entries are listed for the same server under Servers and RAC categories when discovered with SSH and iDRAC.

Auto mapping of Oracle Databases running on Dell Servers

After successful discovery of a Dell server in OME and the promotion of the targets into OEM 12c, the Oracle Database association to Dell servers happens automatically using the hostname as displayed in below figure. This mapping helps Oracle DBA’s to identify/navigate to the Oracle databases running on each specific Dell server. The availability of the databases is also shown from the console.