HP XP24000 HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp
HP XP24000 Manual
View all HP XP24000 manuals
Add to My Manuals
Save this manual to your list of manuals |
HP XP24000 manual content summary:
- HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 2
2009, 2011 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 3
settings 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 - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 4
HP product documentation survey 29 4 Contents - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 5
Oracle objects reside on which 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 Plug-In for Oracle Enterprise Manager software is referred to as the - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 6
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-UX command to provide access: # chown oracle:dba /dev/rdsk/cxtydz # chmod 660 /dev/rdsk/cxtydz Managed host - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 9
Manager. Adding 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 • Array Serial No • LUNs for Performance Monitoring • DB Instance for Performance Monitoring Deploying the plug - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 10
Manager Command Line Interface path field is mandatory to successfully deploy the plug-in. However, the Array Serial No, LUNs for Performance Monitoring, and DB Instance for Performance the plug-in: 1. Select HP StorageWorks P9000 Disk Array plug-in in management plug-in list and then click the - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 12
CU:LDEV) • 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 Serial No.) • Host 12 Reports - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 13
listed. However, if a LUN from the disk array is used by one of the Oracle Enterprise Manager managed hosts, the disk array is listed, but without any details. The Plug-in Configured column indicates if the command device is configured and accessible to a host. Disk array configuration report 13 - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 14
report This report provides LUN 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 - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 16
the Automatic Storage Management (ASM) disk group and storage devices. This report also provides the disk group storage utilization information. storage device mapping report This reports provides the mapping between the host OS file system mount points and storage devices (LUN) as well as storage - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 17
Host OS devices (Device files) as well as storage utilization information. 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 - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 19
(see "HP P9000 StorageWorks plug-in home page" (page 11)). Only valid databases are used for performance statistics graphs. User selected LUNs performance statistics report This report provides the performance statistics of the user input LUNs of the selected disk array. Enter the Array Serial No - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 20
provides the performance statistics of the array controller ports through which 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 - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 21
example, the value of 1448 is selected for LUN 50 027470079. 3. A window appears showing statistics and a chart of the LUN Total I/O Per Sec. From the View Data menu, you can select the chart duration (24 hours, 7 hours, 31 days, etc.). All metrics 21 - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 22
performance metrics related to RAID groups used by the LUNs that are configured to the Enterprise Manager managed nodes. Point-in-time data is collected 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 - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 23
3. Enter the alert settings 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. - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 26
the All Metric page of the plug-in. One or more Command Devices (CMD device) do not have Give the appropriate permissions to the command devices. the required permissions in the plug-in host. See the prerequisites section of the HP StorageWorks P9000 RAID Manager User Guide. 26 Troubleshooting - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 27
continued) Error Description and solution No command device (CMD device) 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 generation performance If the - HP XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - 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 XP24000 | HP StorageWorks P9000 Disk Array Plug-in Software for Oracle Enterp - Page 29
you with documentation that makes our storage hardware and software products easy to install, operate, and maintain. Your feedback is invaluable in letting us know how we can improve your experience with HP documentation. Please take 10 minutes to visit the following web site and complete our online
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