Installation Manual

HP Storage Essentials SRM 6.0 Installation Guide 305
Create the APPIQ_USER account on the 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. See 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.
When creating the APPIQ_USER account on an Oracle Real Application Cluster (RAC)
Database, this script should be run only once, on any one of the instances of the Oracle RAC
Database. Since all the instances of an Oracle RAC access the same Database, it is sufficient to
create the APPIQ_USER account on any one of the instances.
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 the 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/DBIQ/oracle/unix
where /cdrom is the name of the directory where you mounted the CD-ROM.
To run the script on Microsoft Windows, go to the DBIQ\oracle\win directory on the CIM
extensions CD-ROM.
To run the script on OpenVMS:
Log into an account that has administrative privileges.
Mount the CIM Extensions CD-ROM (if not auto-mounted) using the following command.
$ MOUNT /MEDIA=CDROM
/UNDEFINED_FAT=STREAM:32767/OVERRIDE=IDENTIFICATION
DQB0
where DQB0 is the CD-ROM drive.
Go to the directory containing the Oracle agent creation script using the following
command.
$ SET DEF DQB0:[OVMS.DBIQ.ORACLE]
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 UNIX platforms) or CRACCT.COM (on OpenVMS) on the computer with the Oracle
database. On OpenVMS, run CRACCT.COM on the host using the following command.