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?

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?



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.

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

Provide the host IP address/range, name of the range/host and the subnet
Figure 1: Provide the host IP address/range, name of the range/host and the subnet

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

Select the check box to use SNMP protocol for discovery and specify Get Community as Public
Figure 2: Select the check box to use SNMP protocol for discovery and specify Get Community as Public

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

Provide the WMI details in case of a windows host and click Next
Figure 3: 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.

 Enable SSH discovery for linux hosts with the host credentials
Figure 4: 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

Specify Perform both discovery and inventory and click Next
Figure 5 :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_ 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

Provide the host IP address/range, name of the range/host and the subnet. Click on Add and Next
Figure 6 :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

Provide the WMI details in case of a windows host and unselect if it’s a linux host. Click Next
Figure 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.

Enable SSH discovery for linux hosts with the host credentials.
Figure 8 : 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

 Specify Perform both discovery and inventory and click Next
Figure 9 : 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

 Provide the host IP address of iDRAC, name of the range/host and the subnet. Click on Add and Next
Figure 10 : 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

Select the check box to use SNMP protocol for discovery and specify Get Community as Public
Figure 11 : Select the check box to use SNMP protocol for discovery and specify Get Community as Public

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 .

Enable WS-Man Credentials
Figure 12 : Enable WS-Man Credentials

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

Specify Perform both discovery and inventory and click Next
Figure 13 : 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.
Review the complete inputs and click Finish.
Figure 14 : Review the complete inputs and click Finish.




Article ID: SLN312276

Last Date Modified: 08/16/2018 07:53 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.