auto-mounted), and go to the

/DBIQ/Oracle/unix directory by typing the following:

# cd /cdrom/cdrom0/DBIQ/Oracle/unix

where /cdrom/cdrom0 is the name of the CD-ROM drive

•To run the script on Microsoft Windows, go to the DBIQ\Oracle\win directory on the CIM Extensions CD-ROM.

IMPORTANT: You must complete the following steps.

2.Verify you have the password to the SYS user account.

You are prompted for the password for this user account when you run the script.

3.Run the CreateOracleAct.bat script on Microsoft Windows or CreateOracleAct.sh script on a UNIX operating system on the computer with the Oracle database.

The script creates a user with create session and select dictionary privilege on a managed Oracle instance.

NOTE: You can use a remote Oracle client to run this script.

4.Specify the Oracle instance name, which must be visible to the client, as the first input when running the script. The script prompts you for the name of the Oracle instance on which to create user for Oracle management packages and the password of the SYS account.

You are asked to specify the default and temporary tablespaces for APPIQ_USER during the installation. You can enter users as default and temp as temporary if these tablespaces exist in the Oracle Instance.

5.Repeat the previous step for each Oracle instance you want to manage. This script does the following in order:

•Creates the APPIQ_USER account.

•Grant create session and select on dictionary tables privileges to APPIQ_USER enabling management server to view statistics for the Oracle instances.

Removing the APPIQ_USER Account for Oracle

If you no longer want the management server to monitor an Oracle instance, you can remove the APPIQ_USER account for that Oracle instance by running the UninstallOracleAct.bat script on Windows or UninstallOracleAct.sh script on the Solaris platform.

Keep in mind the following:

•Before you remove the APPIQ_USER account for an Oracle instance, make sure no processes are running APPIQ_USER for that Oracle instance. The management server uses APPIQ_USER to obtain information about the Oracle database. For example, a process would be using APPIQ_USER if someone was using Performance Manager to view monitoring statistics about that Oracle instance. (Discovery from HP SE only)One of the ways to make sure APPIQ_USER is not being used is to temporarily remove the host running Oracle (Discovery > Topology).After

104 Discovering Applications, Backup Servers and Hosts