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

$ @CRACCT.COM

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

HP Storage Essentials SRM 6.0 User Guide 91