HP Storage Essentials V5.00.01 user guide (T4283-96012, January 2006)

Storage Essentials 5.00.01 User Guide 103
• ”Monitoring Microsoft SQL Server” on page 108
• ”Monitoring Sybase Adaptive Server Enterprise” on page 112
• ”Monitoring Microsoft Exchange” on page 115
Monitoring Oracle
To monitor and manage Oracle, you must do the following:
• ”Step A - Create the APPIQ_USER Account for Oracle” on page 103
• ”Step B - Provide the TNS Listener Port” on page 105
• ”Step C - Set up Discovery for Oracle 10g” on page 105
After you complete these steps, you must discover Oracle,and perform Discovery Data Collection or
Get Details. See ”Step 3 - Discovering Applications” on page 116.
IMPORTANT: Before you begin these steps, make sure you purchased the module that lets you
monitor Oracle. Contact your customer support if you are unsure if you purchased this module.
Step A - Create the APPIQ_USER Account for Oracle
The management server accesses Oracle through the APPIQ_USER account. This account is created
when you run the CreateOracleAct.bat script on Microsoft Windows or
CreateOracleAct.sh on UNIX on the computer running the Oracle database you want to
monitor. The account has create session and select dictionary privileges to be used with the
management server.
Keep in mind the following:
• The CreateOracleAct.bat script must run under SYS user.
• Create APPIQ_USER account on Oracle Database you want to monitor, not on the management
server.
• You should have already installed the database for the management server.
• Verify that the instance TNS (Transparent Name Substrate) listener is running so that the
management server can find the Oracle installation and its instances. For example on Microsoft
Windows 2000, you can determine if the instance TNS listener is running by looking in the
Services window for OracleOraHome92TNSListener. The name of the TNS listener might vary
according to your version of Oracle. Refer to the Oracle documentation for information about
verifying if the instance TNS listener is running. You can also verify the listener is running by
entering the following at the command prompt: lsnrctl status. If the listener is not running you can
start it by typing lsnrctl start on command line.
• Make sure you have all the necessary information before you begin the installation. Read
through the following steps before you begin.
To create the Oracle user for management server:
1. Do one of the following:
• To run the script on IBM AIX, SGI IRIX, HP-UX, Linux or Sun Solaris, log into an
account that has administrative privileges, mount the CIM Extensions CD-ROM (if not