Skip Headers
Oracle® Enterprise Manager Cloud Control Administrator's Guide
12c Release 1 (12.1.0.2)

Part Number E24473-16
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

16 Discovering and Managing Exadata Targets and Systems

Oracle Database Machine is an integrated data warehousing solution that eases data warehousing by integrating the whole hardware and software stack into one solution. DB Machine management simplifies monitoring and managing the DB Machine by integrating all hardware and software components into one entity. You do not need to monitor each target individually but instead you can view the whole DB Machine as a single target. You can view all critical issues in the system, monitor performance, and drill down to individual targets from the DB Machine target homepage.

Enterprise Manager automatically or manually discovers the components of the DB Machine and adds these components as managed targets. You can modify the member targets of the DB Machine by adding and removing targets.

The DB Machine homepage includes the following components:

You can also monitor all components of the DB Machine. DB Machine monitors all subcomponent targets, whether hardware or software. This includes the database, ASM, CRS, hosts, Exadata and the Infiniband network. The two targets available to facilitate DB Machine monitoring are:

Note:

The following are the minimum requirements for a DB Machine to be monitored and managed by Enterprise Manager Release 12c:

For more information about discovering and managing Exadata targets, see the following topics:

16.1 Automatically Discovering an Oracle Database Machine

To automatically discover a DB Machine target, follow these steps:

  1. From the Setup menu, select Add Target, then select Add Targets Manually.

    Enterprise Manager displays the Add Targets Manually page.

  2. Choose Add Non-Host Targets Using Guided Process (Also Adds Related Targets).

  3. From the Target Types drop-down, choose Oracle Exadata Database Machine, then click Add Using Guided Discovery.

    Enterprise Manager displays the Oracle Database Machine Discovery page. From here you can add the hardware components such as Exadata Storage Servers and Infiniband Switches in the Oracle Database Machine as managed targets. You can choose to discover a new DB Machine and its hardware components as targets or instead discover newly added hardware components in an existing DB Machine as targets.

  4. Choose Discover a new Database Machine and its hardware components as targets, then click Discover Targets.

    Enterprise Manger displays the Database Machine Discovery wizard that steps you through the process of discovering the Database Machine. The first page of the wizard, the Discovery Inputs page, appears.

  5. In the Discovery Agent section of the Discovery Inputs page, choose or enter the Agent URL that exists on one of the compute nodes to perform the discovery and then enter the Database Oracle Home of the database installation (release 11.2 or later) on the agent host. In the Infiniband Discovery section, specify the host name of one of the Infiniband switches in the Database Machine and specify the password of the on the Infiniband switch. Click Next.

  6. On the Components page, the new components discovered in the Oracle Database Machine display.

    In the Compute Node section, select the hosts that are compute nodes in the Oracle Database Machine. The hosts must be added as managed targets before the Oracle Database Machine target promotion can proceed.

    In the Infiniband Switch section, select the Infiniband Switches that are part of the Oracle Database Machine. These also will be added as managed targets.

    In the Ethernet Switch section, select the Ethernet switches that are part of the Oracle Database Machine. The Ethernet switches will be added as managed targets.

    In the Compute Node ILOM section, select the Integrated Lights Out Managers (ILOM) of the compute nodes that are part of this Oracle Database Machine. Theses Integrated Lights Out Managers will be added as managed targets.

    In the KVM section, select the KVM switches that are part of the Oracle Database Machine. The KVM switches will be added as managed targets.

    Click Next to continue.

    Enterprise Manager displays the Monitoring Agents page.

  7. On the Monitoring Agents page, choose whether you want the monitoring agents to be selected automatically or manually. If you choose Manually select the agents, you must add the Monitoring Agent and optionally a Backup Monitoring Agent for each of the Exadata Cells and Infiniband Switches.

    Click Next to continue.

    Enterprise Manager displays the Agent Credential page.

  8. On the Agent Credential page, specify whether the Management Agent host users and passwords are the same for all agents. The agent users and passwords are required to set up password-less SSH between the agents and the cells monitored by the agents.

    If the users and passwords are the same, choose Same for all agents and enter the user and password combination. If they are not the same for each agent, choose Different for all agents and enter each combination for each agent.

    Click Next.

  9. On the Component Credential page, enter the credentials for the components. In all cases you can choose to enter the same user/password combinations for all components or you can enter the credentials separately for each occurrence.

    Click Next to continue.

    Enterprise Manager displays the Component Properties page.

  10. On the Component Properties page, specify the target properties of the different components.

    For each component, enter the required information.

    Click Next to continue.

    Enterprise Manager displays the Review page.

  11. Use the Review page to view the selections you have made in the previous pages of the wizard. When you have verified your selections, click Submit.

    Enterprise Manager displays the Target Promotion Summary page that displays the targets that are now managed targets.

16.2 Viewing the Topology of an Existing DB Machine Target

You can view the DB Machine topology of the DB Machine target.

DB Machine management simplifies monitoring and managing the DB Machine by integrating all hardware and software components into one entity. You do not need to monitor each target individually but instead you can view the whole DB Machine as a single target. You can view all critical issues in the system, monitor performance, and drill down to individual targets from the DB Machine target homepage.

Use the Topology page of DB Machine to view the topology of the system by Cluster or by Database. Clusters are a complete software system starting with a RAC database, the underlying ASM, and CRS. Clusters define one logical entity that is interconnected. The DB Machine could include several clusters, one cluster, or could just be a number of individual databases. While cabinets define the hardware topology of the DB Machine, clusters define the logical or system topology of the DB Machine.

You can view the Topology by Cluster or Database. Click an element in the Topology and view alert data associated with the element.

You can monitor all components of the DB Machine. DB Machine monitors all subcomponent targets, whether hardware or software. This includes the database, ASM, CRS, hosts, Exadata and the Infiniband network.

To view the topology of an existing DB Machine target, follow these steps:

  1. From the Targets menu, select Exadata.

    Enterprise Manager displays the Oracle Exadata Database Machines page showing all the available DB Machine targets. From this page you can add hardware components (such as Oracle Exadata Storage Servers, Infiniband switches, Ethernet Switches, KVM switches, PDU, and compute node ILOM) in the Oracle Database Machine as managed targets.

  2. From the Oracle Exadata Database Machines page, select the Oracle Database Machine target whose topology you want to view.

  3. From the Oracle Database Machine Home page, click Target, then select Members Topology from the drop-down menu.

    Cloud Control displays the Configuration Topology page.

16.3 Drilling Down to Individual Targets

You can drill down immediately to a subcomponent target of the DB Machine (such as RAC, a database instance, or an Exadata cell).

To drill down to individual targets, follow these tasks:

  1. From the Targets menu, select Exadata.

    Enterprise Manager displays the Oracle Exadata Database Machines page showing all the available DB Machine targets. From this page you can add hardware components (such as Oracle Exadata Storage Servers, Infiniband switches, Ethernet Switches, KVM switches, PDU, and compute node ILOM) in the Oracle Database Machine as managed targets.

  2. From the Oracle Exadata Database Machines page, select the Oracle Database Machine target whose components you want to view.

    Enterprise Manager displays the Oracle Database Machine Home page showing an Overview, Schematic, and Incident section for the selected DB Machine.

  3. From the Oracle Database Machine Home page, use the left navigation panel to expand the list of available targets that comprise the Database Machine.

  4. Click the target to which you want to drill down.

16.4 Viewing Critical Hardware Information for the DB Machine

You can view critical metrics for all the hardware subcomponents of the DB Machine such as DB hosts, Exadata cells, Infiniband switches and so on. These metrics vary for different component targets. For example, database server nodes and Exadata servers include the CPU, I/O, and Storage metrics .

To view critical hardware-centric information for the entire DB machine, follow these steps:

To drill down to individual targets, follow these tasks:

  1. From the Targets menu, select Exadata.

    Enterprise Manager displays the Oracle Exadata Database Machines page showing all the available DB Machine targets. From this page you can add hardware components (such as Oracle Exadata Storage Servers, Infiniband switches, Ethernet Switches, KVM switches, PDU, and compute node ILOM) in the Oracle Database Machine as managed targets.

  2. From the Oracle Exadata Database Machines page, select the Oracle Database Machine target whose hardware information you want to view.

  3. From the Oracle Database Machine Home page, view the hardware schematic of the Database Machine.

16.5 Viewing DB Machine Alerts

You can view alerts on the DB Machine and drill down to details about each alert. These alerts may be performance/configuration metrics or hardware faults.

To view DB Machine alerts, follow these steps:

  1. From the Targets menu, select Exadata.

    Enterprise Manager displays the Oracle Exadata Database Machines page showing all the available DB Machine targets. From this page you can add hardware components (such as Oracle Exadata Storage Servers, Infiniband switches, Ethernet Switches, KVM switches, PDU, and compute node ILOM) in the Oracle Database Machine as managed targets.

  2. From the Oracle Exadata Database Machines page, select the Oracle Database Machine target whose machine configuration information you want to view.

    Enterprise Manager displays the Oracle Database Machine home page on which you can see all alerts associated with the current DB Machine.

16.6 Adding Exadata Components Manually

You can add Exadata components manually using the following steps:

  1. From the Setup menu, select Add Target, then select Add Targets Manually.

    Enterprise Manager displays the Add Targets Manually page where you can choose the type of target you want to add.

  2. From the Add Targets Manually section, choose Add Non-Host Targets by Specifying Target Monitoring Properties.

  3. In the Target Type combo box, choose the appropriate target type, for example, KVM for kvm, PDU for pdu, Cisco switch for Cisco, and Oracle ILOM Server for ilom plug-in).

  4. Choose the monitoring agent using the search option.

  5. Click Add Manually and provide the required properties

16.7 About Oracle Exadata Storage Server

An Exadata cell is a network-accessible storage array with Exadata software installed on it. Use the Exadata Home page to manage and monitor the HP Oracle Exadata Storage Server (also known as Exadata cell) by managing the Exadata cells as Enterprise Manager Cloud Control targets. You can discover and consolidate management, monitoring and administration of a single or a group of Oracle Exadata Storage Servers in a datacenter using Enterprise Manager.Exadata cells can be discovered automatically or manually. Once discovered, you can add the Exadata cells as Enterprise Manager targets. The individual Exadata cell is monitored and managed as an Enterprise Manager target and provides the exception, configuration and performance information.Grouping of Exadata cells is used for easy management and monitoring of the set of Exadata cells. You can group Exadata cells both manually and automatically. The grouping function provides an aggregation of exceptions, configuration and performance information of the group of cells.You can view performance analysis by linking Exadata performance both at a cell level and group level to ASM and database performance. You can drill down to Exadata configuration and performance issues from both the database and ASM targets.Storage Grid (for example, multiple database/ASM instances sharing the same Exadata cell) is supported to the same extent as dedicated storage.

For more information about managing Exadata servers, see the following topics:

16.7.1 Using Exadata As a Cloud Control Target

Use Oracle Exadata to manage and monitor the HP Oracle Exadata Storage Server (also known as Exadata cell) by managing the Exadata cells as Enterprise Manager Cloud Control targets. You can discover and consolidate management, monitoring and administration of a single or a group of Oracle Exadata Storage Servers in a datacenter using Enterprise Manager.

Exadata cells can be discovered automatically or manually. Once discovered, you can add the Exadata cells as Enterprise Manager targets.

The individual Exadata cell is monitored and managed as an Enterprise Manager target and provides the exception, configuration and performance information.

Grouping of Exadata cells is used for easy management and monitoring of the set of Exadata cells. You can group Exadata cells both manually and automatically. The grouping function provides an aggregation of exceptions, configuration and performance information of the group of cells.

You can view performance analysis by linking Exadata performance both at a cell level and group level to ASM and database performance. You can drill down to Exadata configuration and performance issues from both the database and ASM targets.

16.7.2 Performing Administration Tasks on Exadata Cells

To perform an administration operation on an Exadata cell, such as executing a cell command, follow these steps:

  1. Navigate to the Exadata Cell home page by choosing the Exadata target for which you want to perform an administrative task from the All Targets page.

    Enterprise Manager displays the Exadata Cell Home page for the target you selected.

  2. Click Target, then select Administration.

    From this menu you can choose either Execute Cell Command, Support Workbench, or Manage I/O Resources.

  3. Click Execute Cell Command.

    The Command page of the Exadata Cell Administration wizard appears. Enter a CELLCLI command as the administrative command to be executed on the cell. You must read the Command Instructions before you enter a command. Only a single CELLCLI command is allowed to execute. You must enter the command without the 'cellcli -e' prefix, which is automatically appended when you submit the command. Finally, you cannot use the following characters: ; / ' < > / |.

  4. Click Next to continue.

    Enterprise Manager displays the Admin Credentials page. Select or enter the Administration credentials to execute the command. The credentials you enter are used when submitting the operation. You can choose between Preferred Credentials, Named Credentials, and New Credentials. You can also click More Details to view information about Credential Type, Last modified, Credential Name, Credential Owner, Last Modified Date, Last Modified By, and Preferred Credentials Set At.

  5. Click Next.

    Enterprise Manager displays the Schedule page. Use the Schedule page to schedule the administration task. Enter the Job Name and the Job Description, then provide the job information in the Schedule the Administration Job section. You can choose to begin the job immediately or enter the time you want the job to begin.

  6. Click Next to continue.

    The Summary page displays. Use the Summary page to ensure you have entered the correct values and then submit the command. The Summary page lists the Job Name, Description, Command to Execute, when the job is Scheduled, and the Selected Cell.

  7. Click Submit Command to submit the job.

    The Job Status page displays. Use the Job Status page to link to the Job Detail page of the administration task.

16.7.3 Performing Administration Tasks on Infiniband Networks

To perform an administration operation on an Infiniband Network, follow these steps:

  1. Navigate to the DB Machine home page of the Infiniband Network by choosing the DB Machine for which you want to perform an administrative task from the All Targets page.

    Enterprise Manager displays the DB Machine Home page for the target you selected.

  2. Select the IB Network for which you want to perform an administrative task.

  3. From the Target menu item, choose Administration.

    The Target & Command page of the Infiniband Network Administration wizard appears.

  4. Choose the Target Type and then select the target on which you want to perform the administrative task from the Target drop-down list. Enter the administrative command you want to execute. The available operations from which you can select are dependent on the target type and target you selected. Once you choose the operation, you may need to select a value that will appear after choosing the operation.

  5. Click Next to continue.

    Enterprise Manager displays the Credentials & Schedule page. Select or enter the credentials to execute the command. The credentials you enter are used when submitting the operation. You can choose between Preferred Credentials, Named Credentials, and New Credentials. Schedule the administration task. Provide the job information in the Administration Job Schedule section. You can choose to begin the job immediately or enter the time you want the job to begin

  6. Click Next to continue.

    The Review page appears. Use the Review page to ensure you have entered the correct values and then submit the command. The Review page lists the Job Name, Description, Command to Execute, when the job is Scheduled, the Target Type, and the Selected Target.

  7. Click Submit Command to submit the job.

    When you click Submit Command, a popup is shown if the job is successful. You can go to the Job Detail Page or back to the page from where this wizard was launched.

16.7.4 Launching the IORM Performance Page

To launch the IORM Performance page, follow these steps:

  1. Navigate to the Exadata Cell home page by choosing the Exadata target for which you want to view the IORM Performance page from the All Targets page.

    Enterprise Manager displays the Exadata Cell Home page for the target you selected.

  2. From the Administration menu item, choose Administration. and then Perform IORM Management.

    The IORM Performance page appears where you can view the status of the current IORM configuration.

16.7.5 Viewing an Exadata Cell Configuration

You can view the configuration of an Oracle Exadata target by following the steps below:

  1. Navigate to the Exadata Cell home page by choosing the Exadata target for which you want to view the IORM Performance page from the All Targets page.

    Enterprise Manager displays the Exadata Cell Home page for the target you selected.

  2. From the Target menu, choose Configuration and then Topology.

    Enterprise Manager displays the Configuration Topology page for the selected Exadata Cell. The topology page provides a visual layout of a the target's relationships with other targets. From this page you can:

    • Do a target search filtered by target status/events/target type)

    • Select from a set of relationships to represent in the graph

    • Select annotations to display in the graph, such as alerts and link labels

    • Select from a set of options: view navigator, expand or collapse all, toggle graph layout, reload topology

    • Print

    • Zoom via the slide control

    • Pan via the navigator control

    • Toggle the presentation from graph to table

    When you hover over a node or group member, a popup displays detailed information about the entity. A link can appear in the popup to more detailed information such as customer documentation.

16.7.6 Managing a Single I/O Resource Management Allocation

You can manage the I/O resource allocation for each cell in your Exadata environment. The Manage I/O Resource page displays the current mode (active or inactive) and allows you to change the mode by using the Update IORM Mode function. You cans also change the IORM Objective using the Update IORM Objective function. The page also shows statistics and metrics for the current Exadata cell.

To manage the I/O Resource Management for a single cell, follow these steps:

  1. From the Target menu of the Exadata cell for which you want to manage I/O resources, choose Administration.

  2. From the Administration menu, select Manage I/O Resource.

    The I/O Resource Management page displays where you can change the IORM Mode between Active and Inactive or you can change the IORM Objective.

  3. Use the IORM Objective chart to display the historical value of objectives.

  4. Use the IORM Wait chart to display the IORM Wait times for all databases or a selected database. You can select the database (or all databases) to display in the IORM Wait chart by choosing the database from the Select Database drop-down list.

For more information about changing the IORM mode or updating the IORM objective, see Changing the IORM Mode and Updating the IORM Objective.

16.7.7 Accessing Oracle Support Workbench for Exadata Cell

You can access the Oracle Support Workbench for the current Exadata cell to access diagnostic data for problems and incidents related to the cell.

To access the Support Workbench for a single Exadata cell, follow these steps:

  1. From the Target menu of the Exadata cell for which you want to access the Oracle Support Workbench, choose Administration.

  2. From the Administration menu, select Support Workbench.

    The Login to Support Workbench page displays where you can enter the credentials required to access the Workbench.

  3. Choose the type of cell administration credential you want to use from the Credential section.

    You can choose Preferred Credential, Named Credential, or New Credentials.

  4. Depending on what you chose in Step 3, enter the Credential Details (Username and Password) in the appropriate fields. You can turn on the More Details Option to see more details about the credentials.

  5. Click Continue to display the Oracle Support Workbench.

16.7.8 Changing the IORM Mode and Updating the IORM Objective

Follow these steps to change the IORM Mode or update the IORM Objective.

Changing the IORM Mode

To change the IORM mode from the I/O Resource Management page, follow these steps:

  1. From the Target menu of the Exadata cell for which you want to manage I/O resources, choose Administration.

  2. From the Administration menu, selectManage I/O Resource.

    The I/O Resource Management page displays where you can change the IORM Mode between Active and Inactive. The current IORM Mode is displayed on the page.

  3. In the IORM Mode and Objective section, click the mode (Active or Inactive) to which you want to change and then click the Change IORM Mode button.

Updating the IORM Objective

To update the IORM Objective from the I/O Resource Management page, follow these steps:

  1. From the Target menu of the Exadata cell for which you want to manage I/O resources, select Administration.

  2. From the Administration menu, choose Manage I/O Resource.

    The I/O Resource Management page displays where you can update the IORM Objective. The current IORM Objective is displayed on the page.

  3. From the Change IORM Objective box within the IORM Mode and Objective section, use the Select drop-down list to update the IORM Objective and then click Update IORM Objective.

    You can choose one of the IORM Objectives from the list: Low Latency, Balanced, High Throughput, or Auto.