HP Storage Essentials NAS Manager Software - Manual (Page 155)

Storage Essentials 5.1 User Guide 123
Then, set up the configurations for your applications on the management server. Some applications
may require you to provide additional discovery information about the application. Finally, perform
discovery and then obtain Get Details/Discovery Data Collection. Get Details and Discovery Data
Collection takes some time. Perform this step when the network is not busy. More details about the
steps mentioned above are provided later.
See the following topics for more information:
• ” Monitoring Oracle ” on page 123
• ” Monitoring Microsoft SQL Server ” on page 128
• ” Monitoring Sybase Adaptive Server Enterprise ” on page 133
• ” Monitoring Microsoft Exchange ” on page 136
Monitoring Oracle
To monitor and manage Oracle, you must do the following:
• ” Step A - Create the APPIQ_USER Account for Oracle ” on page 123
• ” Step B - Provide the TNS Listener Port ” on page 125
• ” Step C - Set up Discovery for Oracle 10g ” on page 126
After you complete these steps, you must discover Oracle,and perform Discovery Data Collection or
Get Details. See ” Step 3 - Discovering Applications ” on page 137.
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