HP XP20000/XP24000 HP StorageWorks P9000 Disk Array Plug-in Software for Oracl
HP XP20000/XP24000 Manual
View all HP XP20000/XP24000 manuals
Add to My Manuals
Save this manual to your list of manuals |
HP XP20000/XP24000 manual content summary:
- HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 1
HP StorageWorks P9000 Disk Array Plug-In for Oracle Enterprise Manager Integration Guide Abstract This guide explains how to use HP StorageWorks P9000 Disk Array Plug-In for Oracle Enterprise Manager software on HP StorageWorks P9500, XP24000, XP20000, XP12000, and XP10000 disk arrays to generate - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 2
2011 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 3
22 7 Troubleshooting 25 Using the OS File System Mount Point to Storage Device Mapping report 25 Viewing metric collection errors 25 Missing mapping information in the mapping reports 27 Report generation performance 27 8 Support and other resources 28 Contacting HP...28 New and changed - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 4
HP product documentation survey 29 4 Contents - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 5
array groups • correlate array group capacity with poor database performance • identify I/O cycles available on a specific disk array or across several disk arrays The HP StorageWorks P9000 Disk Array Manager 11.1.0.1 or later HP Disk Arrays HP-UX P9500, XP24000, XP20000, XP12000, XP10000 11i v2 - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 6
the EMCLI client kit from the Grid host:port/em/console/emcli/download The the following to set up the EMCLI: disk array. • Command device ownership to the Oracle agent user account must be provided for read and write access. For example for the command device: /dev/rdsk/cxtydz Use the following HP - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 7
plug-in, the PHCO_36309 patch must be installed. The plug-in support is listed in "Plug-in description" (page 5) (HP-UX nodes not listed are ignored). • Monitored LUN OS device permission The plug-in will not be able to monitor storage devices on operating systems if the any device special files are - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 8
to: http://h71028.www7.hp.com/enterprise/us/en/solutions/ storage-oracle-plug-ins-xp-oracle-enterprise-manager.html. 2. Under P9000 and XP Disk Array Plug-In for Oracle Enterprise Manager Integration guide, click Download the Plug-in. 3. Follow the on-screen instructions to download the installer - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 9
a plug-in target instance After the plug-in has been deployed to a host, you can add new target instances. To add target instances: 1. Select HP StorageWorks P9000 Disk Array as the target type from the Add list in the Monitored Targets section of the management agent home page where the plug-in has - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 10
monitored targets list. Removing the plug-in To remove the plug-in, you must undeploy it. To undeploy the plug-in: 1. Select HP StorageWorks P9000 Disk Array plug-in in management plug-in list and then click the Undeploy icon. 2. Follow the steps provided by Enterprise Manager. 10 Installation and - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 11
4 Monitoring P9000 and XP disk arrays When the plug-in is deployed, the disk array appears in the agent's monitored target list and clicking the link takes you to the plug-in home page. The status of the plug-in is shown in the top left area of the screen. HP P9000 StorageWorks plug-in home page 11 - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 12
reports provided by HP disk array plug-in. Array Serial No. • Host "Database file to storage device mapping report" (page 15)1 • Database • Storage Type • Array Serial Number (Array Serial No.) • Host "ASM disk group to storage mapping report" (page 16)1 • Disk Group • Array Serial Number (Array - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 13
You can select a single host or all hosts by selecting All Hosts. Filters for a database storage type (File System, ASM & RAW). Disk array configuration report This report provides the disk array configuration information presented to the host where the plug-in is deployed. If no command device is - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 14
configuration information on LUNs configured (presented) to one or more hosts managed by the Oracle Enterprise Manager. The LUNs can be from one or more arrays configured to plug-in host. NOTE: To reduce report page load time, filter selections are not updated in the reports until you click Go. 14 - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 15
page load time, filter selections are not updated in the reports until you click Go. Database file to storage device mapping report This report provides mapping from database components to storage devices. To reduce report page load time, filter selections are not updated in the reports until you - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 16
mapping report This report provides the mapping between the Automatic Storage Management (ASM) disk group and storage devices. This report also provides the disk group storage utilization information. To reduce report page load time, filter selections are not updated in the reports until you click - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 17
. To reduce report page load time, filter selections are not updated in the reports until you click Go. Database usage summary report This report displays storage allocation of the top five databases of the selected disk array. Storage device to OS device mapping report 17 - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 18
statistics This report provides the array front-end (Host Port) performance statistics. All disk arrays configured with the plug-in are monitored. Back-end performance statistics This report provides the array back-end (ACP) performance statistics. All disk arrays configured for the plug-in - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 19
report provides the performance statistics of the user input LUNs of the selected disk array. Enter the Array Serial No. and LUN IDs using the Monitoring Configuration option in the plug-in home page (see "HP P9000 StorageWorks plug-in home page" (page 11)). Only valid input LUNs belonging to user - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 20
LUNs are configured to the hosts managed by the Oracle Enterprise Manager. The user can input the Array Serial No. using the Monitoring Configuration option in the plug-in home page (see "HP P9000 StorageWorks plug-in home page" (page 11)). All metrics This report provides the performance metrics in - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 21
1. From the All Metrics page, click LUN Perf. The LUN Perf page appears. 2. To select Total I/O per second, from below the LUN Total I/O Per Sec column, click the value for a LUN. In this example, the value of 1448 is selected for LUN 50 027470079. 3. A window appears showing statistics and a chart - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 22
from the array only when the user requests it (by clicking this metric link). No historical data is stored for this metric. NOTE: HP recommends setting collection times to more than fifteen minutes to avoid heavy loads on Oracle Enterprise Manager agents. For troubleshooting, temporary frequent - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 23
for Metrics in the fields below the Warning Threshold and Critical Threshold columns. Changing the collection schedule 1. From the Metric and Policy Settings page, click a value for the metric in the Collection Schedule column. 2. The collection schedule wizard appears. Follow the on-screen steps to - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 24
Monitoring alerts Alerts will appear on the Plug-in home page. 1. Click the Plug-in home page. 2. Below Alerts, click an alert (LUN Read I/O Per Sec for 10055/50 02747004F/00:4f in the figure). 3. The alert details window appears. 24 Alert threshold and collection schedule settings - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 25
Storage Device Mapping report does not show any records, query the Enterprise Manager Repository view. If no records exist in this view, contact Oracle support. Viewing metric collection errors To determine if there are errors on any reports: 1. In the plug-in home page (see "HP P9000 StorageWorks - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 26
more host targets targets. Please set credentials at Oracle Management credentials are not set at Oracle Management Server Server console. console. This can be solved by plug-in host. See the prerequisites section of the HP StorageWorks P9000 RAID Manager User Guide. 26 Troubleshooting - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 27
) found to monitor the This error appears when the plug-in cannot find any array. command devices presented to the plug-in host. Internal Error For any internal errors, contact your HP service representative and provide the error codes. Missing mapping information in the mapping reports "Error - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 28
made to support P9000 disk array branding. Related information The HP StorageWorks P9000 RAID Manager User Guide provides related information. HP websites For additional information, see the following HP websites: • http://www.hp.com • http://www.hp.com/go/storage • http://www.hp.com/service_locator - HP XP20000/XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracl - Page 29
to visit the following web site and complete our online survey. This will provide us with valuable information that we will use to improve your experience in the future. http://www.hp.com/support/storagedocsurvey Thank you for your time and your investment in HP storage products. Typographic
HP StorageWorks
P9000 Disk Array Plug-In for Oracle
Enterprise Manager Integration Guide
Abstract
This guide explains how to use HP StorageWorks P9000 Disk Array Plug-In for Oracle Enterprise Manager software on HP
StorageWorks P9500, XP24000, XP20000, XP12000, and XP10000 disk arrays to generate Oracle Enterprise Manager
reports. Topics include installation and using the plug-in to generate reports. The intended audience is a database administrator
with knowledge of HP StorageWorks P9000 and XP disk arrays and Oracle Enterprise Manager.
HP Part Number: 5697-0837
Published: February 2011
Edition: Fourth