HP Storage Essentials V5.1 User Guide Second Edition (Linux Release) (T4283-96056, November 2006)

Discovering Applications, Backup Servers and Hosts124
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
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.