HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

HP Storage Essentials SRM 6.0 User Guide 91
• 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.