cc/td/doc/product/dsl_prod/vrmgtsw/vr4ov/rel30
hometocprevnextglossaryfeedbacksearchhelp
PDF

Table of Contents

Installing the Oracle Database

Installing the Oracle Database

Oracle Database Software Overview

The Oracle Enterprise Database Server Version 7.3.x is required to run with ViewRunner for HP OpenView. Install the Oracle database software according to the instructions found in the Oracle manuals. This appendix provides sample steps to install the Oracle Database.


Note Cisco recommends that you have an Oracle database administrator on site during the installation and configuration of Oracle and the Oracle database to be used by ViewRunner.

Guidelines for Installing the Oracle Database

Oracle Packages Required for a Local Installation

The following packages are required for ViewRunner when Oracle, ViewRunner server, and ViewRunner client are all installed on one machine:

Oracle Packages Required for a Distributed Installation

The following sections describe the packages that are required for ViewRunner when Oracle, ViewRunner server, and ViewRunner client are installed on separate machines.

Package Required for a ViewRunner Database Machine

The following package is required on the ViewRunner database machine.

Package Required for a ViewRunner Server Machine

The following package is required on the ViewRunner server machine.

Package Required for a ViewRunner Client Machine

The following package is required on the ViewRunner client machine.

Verifying and Installing Software Packages

The following sections detail the tasks that are required to install the Oracle Server. These tasks must be accomplished in this exact order:

Verifying Oracle Packages

The following steps are required to verify the Oracle packages:


Step 1 To verify which Oracle packages are installed, start up the Oracle Installer (orainst) and look at which products are installed.


Note There are compatibility problems between certain operating system patches and Oracle software. Consult the Oracle Server Installation Guide for the list of required operating system packages.

Step 2 Install the operating system patches.


Creating the Group

Use the operating system administration utility to create dba and oper groups in the /etc/group file. This limits database administration functions to members of these groups. Make sure the oracle software owner is a member of the dba group.

Complete the following steps to create these groups:


Step 1 Log in as root to the workstation onto which you want to install the Oracle Server.

Step 2 Insert the Oracle Server CD-ROM into the CD-ROM drive.

Step 3 Determine the device file name of your CD-ROM drive.

Step 4 Make sure that you choose a block drive device and not a raw drive device.

Step 5 For Solaris 2.x running volume management, the CD-ROM is mounted automatically. If it is the only CD-ROM mounted on the file system, it is typically mounted as /cdrom/oracle.

Step 6 Change to the directory where you mounted the CD-ROM file system. For example:

# cd /cdrom/oracle
 

Step 7 Create a user group in the /etc/group file for database administrators. During installation, this group is assigned Oracle DBA rights.

Step 8 Following is a sample groupadd command to create a dba group, with a group ID (GID) of 121:

# groupadd -g 121 dba
 

Step 9 If you name the DBA group something other than dba, the Installer relinks the Oracle Server during installation.

Step 10 (This step is optional.) Create an oper user group in the /etc/group file to have an additional group of users that have restricted OPERATOR database privileges.

Step 11 The groupadd command adds an entry to /etc/group. Do not manually edit this file to add entries. Entries in the /etc/group file are separated by colons and appear in the following order:

group_name:password:group_ID_number:group_members
 

Following is a sample /etc/group file:

root:x:0:root
other:x:1:daemon,sync,tty,who,uucp,nuucp
bin:x:2:bin,daemon,lp
sys:x:3:bin,sys,adm
adm:x:4:adm,daemon
dba:x:121:oracle,root
oper:x:102:


Note The user names included in the dba and oper groups do not appear in the /etc/group file until you add the user accounts as shown in Creating the User.

Creating the User

As the root user, use the operating system administration utility (admintool) to create an Oracle software owner account with the properties shown in Table B-1.


Table B-1: Oracle Software Owner Account Properties
Property ID Property Entry

Login name

Enter oracle as the login name.

UID number

Specify a free user number between 3 and 32767 (the default is the existing highest number + 1).

Default GID number

Specify a number between 2 and 32767, corresponding to the dba group.

GCOS field

Specify oracle software owner for the user name. Describe the account only. Do not enter data in the personal field. You get an error if the field separators are not in place.

Home directory

Choose a home directory for the oracle user.

Login shell

Specify one of the following: /bin/sh, /bin/csh, or /bin/ksh depending on which shell you are running.

ORACLE_HOME

Select a home directory where you want the Oracle server installed. Ensure that the oracle user's .profile or .cshrc sets the ORACLE_HOME environment variable to that directory.

Starting Oracle Install

Complete the following steps to install the Oracle Server. Please consult your Oracle manual for detailed instructions on installing Oracle. These steps are for Oracle Enterprise Edition 7.3.4.


Step 1 Determine your mount point for installation of the Oracle software. Typically, it is /opt, /u01, or /export. It must, however, be a directory and not /. Your ORACLE_HOME can then be determined from the mount point. The ORACLE_HOME is the location where you want to install the Oracle software. Your Oracle home should be something like this:

/mount_point/app/oracle/product/oracle_version 
 

Following is an example of setting the mount point:

mount_point = /u01
oracle_version = 7.3.4
 

Your mount ORACLE_HOME follows:

/u01/app/oracle/product/7.3.4
 

Step 2 Log in to the Oracle Software user account.

su - oracle
 

Step 3 Make the ORACLE_HOME directory.

mkdir -p /u01/app/oracle/product/7.3.4
 

Step 4 To make it easier to install Oracle and operate the Oracle database, you need to update your .profile for the Oracle user ID with some environment variables. Please add these environment variables to your .profile. This is assuming that your shell for the Oracle software account is ksh.

export ORACLE_TERM=xterm
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/7.3.4
export ORACLE_SID=vrunner
export PATH=$ORACLE_HOME/bin:$PATH:.
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/lib
 

Step 5 Source your .profile after updating.

. ./.profile
 

Step 6 After you insert the Oracle CD and make sure it is mounted, change to the following directory. This step assumes that you have automounter running.

cd /cdrom/cdrom0/orainst
 

Step 7 Start the Oracle installer with the following command:

./orainst /m
 

Note For installations on workstations without graphics capabilities, Oracle provides a terminal-based installation program as well. To run this version instead, execute ./orainst without the /m command line switch.

Step 8 Choose the Default Install option from the Install Type dialog box, and then click OK.

Step 9 Choose the Install, Upgrade, or De-Install Software option from the Installation Activity Choice dialog box, and then click OK.

Step 10 Choose the Install New Product---Do Not Create DB Objects option from the Install Options dialog box, and then click OK.

The next dialog box asks you to confirm the environment variables ORACLE_BASE and ORACLE_HOME.

Step 11 Click OK if everything is correct.

Step 12 Choose to relink the executables by clicking YES in the Relink All Executables? dialog box.

Step 13 From the Software Asset Manager dialog box, select the following items to be installed and then click Install:


Note Do not install all of the available software for the Oracle Server. Install only those portions identified here. Installing more of the Oracle software than indicated can cause the ViewRunner for HP OpenView installation to fail.

Step 14 Choose the dba group in the DBA Group dialog box.

Step 15 Choose /usr/openwin/lib as the directory where the X-Windows libraries can be found.

Step 16 Choose Yes in the Client Shared Library dialog box to generate the shared library for Pro*C clients.

Once the database has finished installing, an information dialog box displays informing the operator to run the root.sh script as the root user.

Step 17 Click OK to close the dialog box.

The installer redisplays the Software Asset Manager dialog box.

Step 18 Ensure that all the appropriate products have been installed, then click Exit.

Step 19 Log in as root and create the local bin directory.

Typical locations for this directory are /opt/bin or /usr/local/bin.

$ su - root
# mkdir /opt/bin
# chmod 777 /opt/bin
 

Step 20 Run the postinstallation script.

# cd $ORACLE_HOME/orainst
# ./root.sh
 

Step 21 Verify that the local bin directory is included in every user's path.

The installation of Oracle Server is now complete and you are ready to start ViewRunner install.



hometocprevnextglossaryfeedbacksearchhelp
Posted: Tue Feb 8 14:31:32 PST 2000
Copyright 1989 - 2000©Cisco Systems Inc.