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

Discovering Applications, Backup Servers and Hosts 104
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