HP Storage Essentials V5.00.01 application guide (T4283-96014, January 2006)

Storage Essentials 5.00.01 Application Guide 9
3 Monitoring Oracle
IMPORTANT: Depending on your license, monitoring Oracle instances may not be available. See
the "List of Features" to determine if you have access to monitoring Oracle instances. The "List of
Features" is accessible from the Documentation Center (Help > Documentation Center in Storage
Essentials).
This chapter describes the following:
• ”Monitoring Oracle Overview” on page 9
• ”Changing the Oracle TNS Listener Port” on page 10
• ”Viewing Events for an Oracle Instance” on page 10
• ”Viewing Properties” on page 11
• ”Viewing Topology for Oracle” on page 18
Monitoring Oracle Overview
Before you can monitor the Oracle Database, you must:
• Have the license for monitoring Oracle. To determine if your license supports the monitoring of
Oracle, see the "List of Features" The List of Features is accessible from the Documentation
Center (Help > Documentation Center in Storage Essentials).
• Create the APPIQ_USER Account for Oracle.*
• Change the TNS listener port (if necessary)*
• Discover the application.*
*Refer to the Installation Guide for more information.
The management software for Oracle is a CIM-based application storage management solution that
lets you realize the benefits of networked storage by more effectively managing your end-to-end
Oracle infrastructure from a single, easy-to-use console. By integrating real time information from
storage devices, network components, servers and operating systems with the application database,
the management software for Oracle can improve your Oracle database performance, availability
and reliability, and maximize your return on Oracle storage assets.
To help simplify the management of your Oracle storage, the management software for Oracle
provides comprehensive topology visualization from the Oracle tablespace to the mount point to
SAN switches to storage systems. This enables your storage and application administrators to
immediately visualize the interdependency of the infrastructure to the application. You will no longer
need to cross reference multiple spreadsheets and call multiple people to get an end-to-end picture.
During periods of infrastructure downtime or other times of equipment failures, infrastructure
interdependencies are at your fingertips so you can make the correct split second decisions when
you are having issues with the infrastructure.