•”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

Storage Essentials 5.00.01 User Guide 103