EMC Storage Plug-in For Oracle Enterprise Manager 12c 12.1.0.6.0 .

1y ago
10 Views
2 Downloads
2.94 MB
88 Pages
Last View : 1m ago
Last Download : 3m ago
Upload by : Eli Jorgenson
Transcription

EMC Storage Plug-in for Oracle Enterprise Manager 12c Version 12.1.0.6.0 Product Guide 302-001-550 REV 06

Copyright 2014-2017 Dell Inc. or its subsidiaries. All rights reserved. Published July 2017 Dell believes the information in this publication is accurate as of its publication date. The information is subject to change without notice. THE INFORMATION IN THIS PUBLICATION IS PROVIDED “AS-IS.“ DELL MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. USE, COPYING, AND DISTRIBUTION OF ANY DELL SOFTWARE DESCRIBED IN THIS PUBLICATION REQUIRES AN APPLICABLE SOFTWARE LICENSE. Dell, EMC, and other trademarks are trademarks of Dell Inc. or its subsidiaries. Other trademarks may be the property of their respective owners. Published in the USA. EMC Corporation Hopkinton, Massachusetts 01748-9103 1-508-435-1000 In North America 1-866-464-7381 www.EMC.com 2 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

CONTENTS 7 Preface Purpose. 7 Audience.7 Scope. 7 Related documentation. 8 Your comments. 8 Chapter 1 EMC Storage Plug-in for OEM 12c Overview 9 EMC Storage Plug-in architecture. 10 EMC VMAX metric collection architecture.13 EMC VNX Block metric collection architecture. 14 EMC VNX File metric collection architecture. 15 EMC XtremIO metric collection architecture. 16 EMC DSSD appliance metric collection architecture.16 Chapter 2 Deployment Prerequisites 19 Oracle environment prerequisites. 20 Oracle Enterprise Manager. 20 Oracle Management Server (OMS). 20 Oracle Management Agent (OMA). 20 Oracle Database. 21 EMC VMAX prerequisites.21 Enabling performance monitoring in U4V. 21 Configuring SYMCLI. 22 Storage groups created by the plug-in.23 EMC VNX Block prerequisites. 23 Enabling performance monitoring on VNX storage. 23 EMC VNX File prerequisites. 24 EMC XtremIO prerequisites.24 EMC DSSD D5 prerequisites. 24 Configuring physical disk mapping.24 Adobe Flash requirements. 25 System virtualization. 25 Mapping VMDKs to underlying storage.26 Chapter 3 Installing and Configuring the EMC Storage Plug-in 29 Installation overview.30 Upgrading the plug-in.30 Deploying the plug-in. 31 Downloading the plug-in.31 Importing the plug-in OPAR. 31 Deploying the plug-in on the Oracle Management Server (OMS). 32 Deploying the plug-in on the OMA. 32 Verifying plug-in deployment. 33 Creating EMC Storage targets. 34 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide 3

CONTENTS Creating the EMC Home target. 34 Creating the EMC VMAX Storage target.35 Creating the EMC VNX Block Storage target. 36 Creating the EMC VNX File Storage target. 37 Creating the EMC XtremIO Storage target.38 Creating the EMC DSSD D5 Storage target. 38 Creating EMC Virtual Map Utility targets. 39 EMC Physical Map Utility targets. 40 Configure database storage monitoring.40 Adding databases to storage monitoring.40 Removing databases from storage monitoring.42 Update storage configuration. 42 Chapter 4 Uninstalling the EMC Storage Plug-in 45 Overview. 46 Removing EMC storage targets.46 Removing EMC database storage or Physical Map Utility targets. 46 Removing EMC Virtual Map Utility or Home targets. 46 Undeploying and deleting the plug-in.46 Undeploying from OMA. 46 Undeploying from OMS. 47 Verifying the undeployment. 47 Deleting the plug-in from OEM. 47 Chapter 5 Using the Plug-in 49 EMC Home page. 50 EMC Database Storage page. 51 EMC VMAX Storage page. 52 EMC VNX Block Storage page. 52 EMC VNX File Storage page.53 EMC XtremIO Storage page. 54 EMC DSSD D5 Storage page. 55 Viewing RAC member databases. 56 Chapter 6 Troubleshooting 57 Troubleshooting the U4V monitoring configuration. 58 Testing SYMCLI commands for VMAX storage targets. 58 Testing INQ commands. 58 Verifying the Physical Mapping Utility. 60 Plug-in Log locations. 60 Physical Mapping log.60 Storage Home DataProvider log. 61 Troubleshooting other configuration issues.61 Requires Virtual Map Utility status. 61 Server certificate trust errors with the VNX Block target in the Test Connection dialogue or plug-in logs.61 Additional Physical Mapping target configuration if asmcmd and OMA are owned by different users. 62 getTargetMetricMetadata error on a database storage target. 62 Troubleshooting the XtremIO Cluster Name property. 62 Troubleshooting the Physical Map target. 63 Test connection error when adding storage array target. 63 4 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

CONTENTS Appendix A Common VMAX Deployment Scenarios 65 Deploy On U4V server. 66 Separate plug-in host. 66 Remote SYMCLI host. 68 Remote EMC Storage Plug-in host. 69 Appendix B Storage Plug-in Collected Metrics 71 VMAX collected metrics. 72 XtremIO collected metrics. 77 VNX Block collected metrics. 79 VNX File collected metrics.84 DSSD D5 collected metrics.87 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide 5

CONTENTS 6 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

Preface EMC periodically releases revisions of its software and hardware to improve its product lines. Therefore, some functions described in this document might not be supported by all versions of the software or hardware currently in use. The product release notes provide the most up-to-date information on product features. Contact your EMC technical support professional if a product does not function properly or does not function as described in this document. Note This document was accurate at publication time. Go to EMC Online Support to ensure that you are using the latest version of this document. Purpose This document describes the architecture, installation, and operation of the EMC Storage Plug-in for Oracle Enterprise Manager (OEM) 12c. The plug-in provides database administrators with comprehensive configuration and performance information about the EMC storage systems that support their databases and applications. Note The EMC Storage Plug-in for OEM 12c is a replacement plug-in for previous versions that targeted individual EMC storage systems. Older EMC plug-ins that targeted VMAX and VNX should be uninstalled before installing the EMC Storage Plug-in for OEM 12c. Audience This document is for database administrators, EMC personnel, partners, and customers. Scope Database administrators can use this document to relate database performance information with the corresponding storage systems to identify performance issues and isolate the root cause of those issues. Because the plug-in monitors which storage volumes are associated with each database, configured storage performance alerts and incidents are automatically displayed in the associated database alert list inside the Oracle Enterprise Manager database plug-in. EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide 7

Preface Related documentation The EMC Storage Plug-in for Oracle Enterprise Manager 12c Release Notes, located on EMC Online Support, provides additional relevant information. If you do not have access to the document, contact your EMC representative. Your comments Your suggestions will help us continue to improve the accuracy, organization, and overall quality of the user publications. Send your opinions of this document to: techpubcomments@emc.com 8 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

CHAPTER 1 EMC Storage Plug-in for OEM 12c Overview The EMCTM Storage Plug-in for OEM 12c gathers availability, performance, and configuration information for EMC storage systems and combines that information with Oracle database host information for display in the Enterprise Manager web interface. This provides the database administrator with a comprehensive look into the performance of the specific storage used by each database–significantly simplifying the task of tracking database performance and isolating issues. l l l l l l EMC Storage Plug-in architecture.10 EMC VMAX metric collection architecture. 13 EMC VNX Block metric collection architecture.14 EMC VNX File metric collection architecture.15 EMC XtremIO metric collection architecture. 16 EMC DSSD appliance metric collection architecture. 16 EMC Storage Plug-in for OEM 12c Overview 9

EMC Storage Plug-in for OEM 12c Overview EMC Storage Plug-in architecture The EMC Storage Plug-in for OEM 12c consists of several components that work together to collect configuration and performance data from both database servers and EMC storage systems. The plug-in collects metrics from EMC storage systems in different ways based on the optimum connection method: l l l l l For EMC VMAXTM, the plug-in relies on EMC UnisphereTM for VMAX, which a storage administrator uses to configure and manage a VMAX array. The plug-in uses the Unisphere for VMAX (U4V) Representational State Transfer (REST) API to collect configuration and performance metrics from U4V. The plug-in also uses EMC Solutions Enabler SYMCLI calls to perform additional operations related to metric collection. For EMC VNXTM Block, the plug-in uses the Navisphere Command Line Interface (NaviCLI) to collect metrics. For EMC VNX File, the plug-in uses an SSH connection to the Control Station to collect metrics. For EMC XtremIOTM, the plug-in uses the XtremIO REST API running on the XtremIO Management Station (XMS) to collect performance information. For the EMC DSSD appliance, the plug-in uses the EMC D5 Management API that runs on the D5 appliance to collect EMC D5-specific metrics. To provide storage-to-database mapping, a small OEM component of the plug-in is installed on each database server to be monitored. The component provides information about EMC storage systems associated with the Oracle database. All configuration and performance information is collected and stored in the Oracle Management Repository (OMR) and displayed in the plug-in UI for easy monitoring of database and storage performance. The following diagrams provide visual descriptions of the EMC Storage Plug-in architecture. The following diagram shows the standard Oracle Enterprise Manager architecture and plug-in distribution. The Oracle Management Server (OMS) and Repository (OMR) are the main parts of Oracle Enterprise Manager. Oracle Management Agents (OMAs) are deployed to hosts in the environment. OEM plug-ins, either developed by Oracle, or third-party plug-ins, run inside the OMA and monitor and manage applications, hosts, databases, and other components. 10 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

EMC Storage Plug-in for OEM 12c Overview Figure 1 Oracle Enterprise Manager architecture and plug-in distribution The plug-in has components that run on different servers in the environment, as shown in the following figure. The UI runs on the OMS while the data collection components run on a database or other hosts in the environment. Plug-in components, while running on separate logical hosts, can also run on the same physical hosts, depending on how administrators want to deploy these components. Figure 2 EMC Storage Plug-in logical architecture The following figure shows a more detailed view of the plug-in components on the storage plug-in host. EMC Storage Plug-in architecture 11

EMC Storage Plug-in for OEM 12c Overview Figure 3 EMC Storage Plug-in components The Home target is the parent target that manages the other targets as they are configured. The number of required storage targets depends on the number of different types of storage arrays that you want to monitor. Configuring a storage target provides information to the Home target to enable connection to the array for metric collection. After you configure the storage targets, the Home target can collect and display array-level metrics from the storage array. Database storage targets are configured to collect and display database-level metrics, including the performance of the specific storage volumes used by specific databases. These targets coordinate with small targets (Physical Map Utility targets) on the actual database hosts to provide storage metrics that are specific to that particular database ((or Automatic Storage Management (ASM) instance)). Note The Virtual Map Utility target provides information about the Virtual Machine Disk (VMDK) storage used by VMware virtual machines The following figure shows a full architecture diagram with all of the plug-in target types and installation locations. This is the typical setup of the plug-in; however, you can modify the architecture for a more distributed setup. 12 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

EMC Storage Plug-in for OEM 12c Overview Figure 4 EMC Storage Plug-in target types and installation locations EMC VMAX metric collection architecture The plug-in collects VMAX storage metrics from Unisphere for VMAX (U4V) and Solutions Enabler. A Unisphere for VMAX REST API obtains performance and configuration metrics about the VMAX storage systems that are configured in U4V. Solutions Enabler issues a limited set of SYMCLI commands associated with metric collection from a VMAX array. EMC VMAX metric collection architecture 13

EMC Storage Plug-in for OEM 12c Overview Figure 5 VMAX metric collection architecture EMC VNX Block metric collection architecture For VNX Block arrays, the plug-in creates a direct connection to the VNX Block storage processor. Each VNX Block array uses one VNX Block storage target. The array's storage processor connects through Navisphere Secure Command Line Interface (NaviSecCLI) to collect array level metrics. 14 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

EMC Storage Plug-in for OEM 12c Overview Figure 6 VNX Block metric collection architecture EMC VNX File metric collection architecture The VNX File storage target collects data from the VNX File storage control station Each VNX File array uses one VNX File storage target. The plug-in uses the Secure Shell (SSH) protocol to connect and collect array level metrics from the control station that administers the monitored VNX File array. Figure 7 VNX File metric collection architecture EMC VNX File metric collection architecture 15

EMC Storage Plug-in for OEM 12c Overview EMC XtremIO metric collection architecture The plug-in collects data from XtremIO storage through the local XtremIO Management Server (XMS). Using the powerful XMS REST API, the XtremIO Storage target collects storage monitoring metrics and relays the data back to the OMA, where it is processed through OEM. Figure 8 XtremIO metric collection architecture EMC DSSD appliance metric collection architecture Metrics are collected from the EMC DSSD D5 all-flash array through the EMC DSSD appliance Management API that is hosted on the D5 array. Metrics collected through the DSSD D5 Management API are relayed back to the D5 Storage target much like the process of collecting metrics with the XtremIO XMS REST API. These metrics are then processed by the OMA and sent on to the OMS. 16 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

EMC Storage Plug-in for OEM 12c Overview Figure 9 DSSD D5 metric collection architecture EMC DSSD appliance metric collection architecture 17

EMC Storage Plug-in for OEM 12c Overview 18 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

CHAPTER 2 Deployment Prerequisites This chapter presents the following topics: l l l l l l l l l Oracle environment prerequisites. 20 EMC VMAX prerequisites. 21 EMC VNX Block prerequisites. 23 EMC VNX File prerequisites. 24 EMC XtremIO prerequisites. 24 EMC DSSD D5 prerequisites. 24 Configuring physical disk mapping. 24 Adobe Flash requirements.25 System virtualization.25 Deployment Prerequisites 19

Deployment Prerequisites Oracle environment prerequisites The following versions of Oracle software and operating systems are supported by the plug-in. Note For specific details about setting up and preparing an Oracle Enterprise Manager system for the plug-in installation, refer to the Oracle Enterprise Manager Cloud Control Administrator's Guide in the Oracle Help Center. Oracle Enterprise Manager The plug-in supports the following Oracle Enterprise Manager versions: l Oracle Enterprise Manager Cloud Control 12c R5 (12.1.0.5.0) l Oracle Enterprise Manager Cloud Control 13c R1 (13.1.0.1.0) l Oracle Enterprise Manager Cloud Control 13c R2 (13.2.0.1.0) Oracle Management Server (OMS) The plug-in is supported for all Oracle Management Server platforms. Oracle Management Agent (OMA) The plug-in is supported for and can be deployed on Oracle Management Agents when the agent is installed on the following operating systems: l Oracle Linux 4 and 5 (32-bit) l Oracle Linux 4, 5, and 6 (64-bit) l Red Hat Enterprise Linux 4 and 5 (32-bit) l Red Hat Enterprise Linux 4, 5, and 6 (64-bit) l Microsoft Windows 2008 (32-bit) l Microsoft Windows 2008, 2008 R2, and 2012 (64-bit) l Oracle Solaris 11 (x86-64) Note The DSSD Storage Appliance Installation & Service Guide on EMC Online Support lists the operating systems that are supported for DSSD D5. Note OEM 12c installations require Java 7 or 8 on each agent where the plug-in will be deployed. 20 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

Deployment Prerequisites Oracle Database The following versions of the Oracle database, in stand-alone and Oracle Real Application Cluster (RAC) configurations, are supported for monitoring with the plugin: l l Oracle 11g database Oracle 12c database Note For monitored databases running on Oracle ASM, the Oracle ASM target must be configured and must be monitoring the Oracle ASM environment in the same OMS system as the EMC Storage Plug-in. EMC VMAX prerequisites The plug-in uses the VMAX Storage target as the main data-collecting target for VMAX monitoring operations. The target connects to Solutions Enabler and the REST API from Unisphere for VMAX. This target is typically deployed to a single host that has a network connection to Unisphere for VMAX and has Solutions Enabler installed for SYMCLI communication to the VMAX storage systems being monitored. SYMCLI commands require a Fibre Channel (FC) connection to the VMAX array or communication with a remote SYMCLI server must be configured. The following version of Unisphere for VMAX is supported: l Unisphere for VMAX 8.0.1 or greater (for VMAX3 ) The following versions of Solutions Enabler are supported for the plug-in: l l Solutions Enabler 7.x Solutions Enabler 8.x Enabling performance monitoring in U4V Collecting VMAX storage information with the Unisphere for VMAX REST API requires U4V credentials for connection to the U4V server. A Unisphere for VMAX administrator can supply this account information and create an account specifically for the VMAX Storage target. This account requires the Performance Monitor role for proper operation. The account information is provided to the target during the configuration. Note The Unisphere for VMAX Performance Option is required to collect performance metrics. The U4V Performance Option is not supported when Unisphere for VMAX is installed on the VMAX Service Processor. For the VMAX Storage target to collect information on a VMAX array, you must enable performance monitoring on the U4V server: Procedure 1. Open a browser window and go to the U4V web interface, typically found at https://host:port/univmax/ Oracle Database 21

Deployment Prerequisites 2. Click the left VMAX icon on the main control bar and select the VMAX array you want to monitor, as shown in the following figure. Figure 10 Selecting a VMAX array 3. Select Performance Settings . 4. Click System Registrations. 5. Select the row with the array you want to monitor, and click View Details. 6. Select Real Time and Root Cause Analysis and click Apply, as shown in the following figure. Figure 11 System registration properties Configuring SYMCLI For the VMAX Storage target to successfully run SYMCLI commands, Solutions Enabler must be installed on the host on which the VMAX Storage target is configured. To run SYMCLI commands through Solutions Enabler, you must configure 22 EMC Storage Plug-in for Oracle Enterprise Manager 12c 12.1.0.6.0 Product Guide

Deployment Prerequisites either a FC connection to the VMAX Storage array or a network connection to a SYMCLI server. Use the Oracle software owner to run the SYMCLI commands and run the EMC Solutions Enabler SYMCLI symdev and symaccess commands. You must configure SYMCLI to allow the Oracle software user to run these commands. You can configure SYMCLby adding the user to the SYMAPI daemon users file. Note On Red Hat and Oracle Linux, the daemon users file is at the following location: /var/symapi/config/daemon users Storage groups created by the plug-in To collect storage metrics for specific volumes used by a database, the VMAX Storage target creates a custom storage group on the VMAX array that contains those volumes. This storage group is separate from any storage group that provides masking and provisioning storage to the host. It is only used to group storage devices for metric collection with Unisphere for VMAX. This storage group is automatically deleted when the VMAX Storage target is deleted. The VMAX storage target uses the following naming convention for the storage group where target-name represents the name that users define when configuring database storage monitoring in the plug-in: OEMPI SG target-name EMC VNX Block prerequisites The plug-in uses the VNX Block Storage target as the main data-collecting target for VNX Block monitoring operations. The target connects to the VNX using the Navisphere Secure Command Line Interface (NaviSecCLI), which makes a network connection to the VNX storage processors. The target must be deployed to a host that has the NaviCLI software installed and configured on it. You must also have credentials (a username and password) with the rights to execute NaviSecCLI commands. Your storage administrator will provide credentials to be used during deployment of the VNX Block Storage target. Enabling performance monitoring on VNX storage For the EMC VNX Block Storage target to collect VNX metrics, enable statistics logging on the VNX. Use the following NaviSecCLI commands to check and set the state of statistics logging. To check the current status of VNX Block statistics logging, type the following NaviSecCLI command from the host that the VNX Block plug-in is installed on: naviseccli -h array-ip -scope 0 -user storage system username password storage system password getcontrol -sl Storage groups created by the plug-in 23

Deployment Prerequisites To enable VNX Block statistics logging, type the following NaviSecCLI command: naviseccli -h array-ip -scope 0 -user storage system username password storage system password setstats -on EMC VNX File prerequisites The plug-in uses the VNX File Storage target as the main data-collecting target for VNX File monitoring operations. The target connects to the VNX File Control Station using the SSH protocol. You must have credentials (a username and password) with the rights to run Control Station commands. Your storage administrator will provide credentials to use during the deployment of the VNX File Storage target. EMC XtremIO prerequisites The plug-in uses the XtremIO Storage target as the main data collection target for XtremIO monitoring

l EMC XtremIO metric collection architecture.16 l EMC DSSD appliance metric collection architecture. 16 EMC Storage Plug-in for OEM 12c Overview 9. EMC Storage Plug-in architecture The EMC Storage Plug-in for OEM 12c consists of several components that work together to collect configuration and performance data from both database .

Related Documents:

Bruksanvisning för bilstereo . Bruksanvisning for bilstereo . Instrukcja obsługi samochodowego odtwarzacza stereo . Operating Instructions for Car Stereo . 610-104 . SV . Bruksanvisning i original

EMC: EMC Unity、EMC CLARiiON EMC VNX EMC Celerra EMC Isilon EMC Symmetrix VMAX 、VMAXe 、DMX EMC XtremIO VMAX3(闪存系列) Dell: Dell PowerVault MD3xxxi Dell EqualLogic Dell Compellent IBM: IBM N 系列 IBM DS3xxx、4xxx、5xx

EMC2, EMC, Data Domain, RSA, EMC Centera, EMC ControlCenter, EMC LifeLine, EMC OnCourse, EMC Proven, EMC Snap, EMC . Symmetrix Open Replicator is a tool that can be used to migrate data from older Symmetrix arrays, CLARiiON or VNX arrays, and certain third-party storage arrays to a DMX or

Dell EMC Unity: Investment Protection Grow with Dell EMC Unity All-Flash Dell EMC Unity 350F Dell EMC Unity 450F Dell EMC Unity 550F Dell EMC Unity 650F ONLINE DATA-IN PLACE UPGRADE PROCESSOR 6c / 1.7GHz 96 GB Memory 10c / 2.2GHz 128 GB Memory 14c / 2.0GHz 256 GB Memory 14c / 2.4GHz 512 GB Memory CAPACITY 150 Drives 2.4 PB 250 Drives 4 PB 500 .

EMC-HD Overview. Key data for EMC-HD: Electromechanical Cylinder EMC-HD available with ball or planetary roller screw drive Sizes: EMC-085-HD, EMC-125-HD, EMC-180-HD Dyn. Load rating (Cdyn): up to 470kN Maximum thrust force: up to 290kN (push/pull)

EMC Avamar Compatibility and Interoperability Matrix EMC Avamar Release Notes EMC Avamar Administration Guide EMC Avamar for Windows Server User Guide EMC Avamar and EMC Data Domain System Integration Guide Table 1 Revision history Revision Date Description 01 July 10, 2013 Initial release of Avamar 7.0.

10 tips och tricks för att lyckas med ert sap-projekt 20 SAPSANYTT 2/2015 De flesta projektledare känner säkert till Cobb’s paradox. Martin Cobb verkade som CIO för sekretariatet för Treasury Board of Canada 1995 då han ställde frågan

C is much more flexible than other high-level programming languages: C is a structured language. C is a relatively small language. C has very loose data typing. C easily supports low-level bit-wise data manipulation. C is sometimes referred to as a “high-level assembly language”. When compared to assembly language .