HP Storage Essentials V5.1 Application Guide First Edition (T4283-96028, August 2006)

Storage Essentials 5.1 Application Guide 9
3Monitoring 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 17
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.