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

Table of Contents

Sample of Oracle Database Installation

Sample of Oracle Database Installation

Cisco strongly recommends that you have an Oracle database administrator (DBA) on site to assist with this install.

The following subsections detail the tasks required to install the Oracle Server. The current release that is supported by ViewRunner for HP OpenView is Oracle Server 7.3.4.

Before you start the installation, make sure that the shared memory and semaphore settings identified in "System Requirements" have been configured, and the system has been rebooted.

B.1 Installing Required Operating System Patches

Consult the Oracle Server Installation Guide for the list of required operating system patches. If you do not have the required operating system patches installed, install them following the instructions provided in the operating system documentation.


Note There are compatibility problems between certain operating system patches and Oracle software. Consult your Oracle documentation for more information.

B.2 Verifying Operating System Packages

Consult the Oracle Server Installation Guide for the list of required operating system packages.

B.3 Creating Groups in the /etc/group File

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.

Perform 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 filename of your CD-ROM drive.

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

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

    # cd /cdrom/oracle
     
    

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

The following is a sample groupadd command to create a dba group, with a group ID (GID) of 121:

    # groupadd -g 121 dba
     
    

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

Step 6 (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.

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
     
    

The 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:

The usernames included in the dba and oper groups will not appear in the /etc/group file until you add the user accounts as shown in "Creating Oracle Software Owner Account".

B.4 Creating Oracle Software Owner Account

As the root user, use the operating system administration utility (admintool) to create an Oracle software owner account with the following properties:


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 only the account. Do not enter data in the personal field. You will 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 the Oracle server will be installed. Ensure that the oracle user's .profile or .cshrc sets the ORACLE_HOME environment variable to that directory.

B.5 Installing the Oracle Server

The following are the instructions for installing the Oracle Server itself. 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 the installation of the Oracle software. Typically it will be /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 you will install the Oracle software. Your Oracle home should be something like this:

    /mount_point/app/oracle/product/oracle_version 
     
    

Example:

    mount_point = /u01
    oracle_version = 7.3.4
     
    

Your mount ORACLE_HOME will be: /u01/app/oracle/product/7.3.4

Step 2 Login into 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 things easier for the Oracle install and the operation of 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 inserting the oracle CD and making sure it is mounted, change to the following directory. This is assuming you have automounter running.

    cd /cdrom/cdrom0/orainst
     
    

Step 7 Start the Oracle installer with the following command:

    ./orainst /m
     
    

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

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

Step 10 Choose the Install New Product . Do not Create DB Objects from the Install Options dialog box and click OK.

Step 11 The next dialog box ask you to confirm the environment variables ORACLE_BASE and ORACLE_HOME. 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, select the following items to be installed and then click Install:

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 on the Client Shared Library to generate the shared library for Pro*C clients.

Step 17 Once the database has finished installing, an information dialog will be displayed informing the operator to run the root.sh script as the root user. Click OK to close the dialog.

Step 18 The installer will redisplay the Software Asset Manager screen. Ensure that all the appropriate products have been installed, then click Exit.

Step 19 Login as root, 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 post-installation 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.


hometocprevnextglossaryfeedbacksearchhelp
Posted: Fri Oct 8 12:41:04 PDT 1999
Copyright 1989-1999©Cisco Systems Inc.