Oracle 8i Enterprise Edition (Version 8.1.7)

Installation Notes for HP-UX version 11.0

                                               

Ben Steel’s Notes

interpreted by

Dr. Melody Stapleton

updated August 26, 2001

 

Note:  The installation seems to go more smoothly for the 32-bit version (versus the 64-bit version) for some reason.  Thus, if it is more critical that you get any installation going versus a 64-bit installation, I recommend the 32-bit.  Here, bits refers to the Oracle word size.

 

1.     You will need to pick a global database name and SID for the sample database that you create with the Oracle 8i installation procedure.

Recommendation for both global database name and SID: ORCL

Three default Oracle accounts will be created for this sample database, each with a set of DBA privileges.  The accounts are :

Ø     sys with a password of change_on_install – this is the account that owns the data dictionary, i.e. the sys schema

Ø     system with a password of manager – this is the owner of the system schema with certain DBA privileges

Ø     internal with a password of oracle – this is system with sysdba privileges.  This account will not be supported in future releases of Oracle.

To login in an Oracle tool use:

connect account/password or e.g. connect system/manager

2.     Unix preparation:

A)   Set up the following parameters –

kernel (2-2)

sam -> kernel -> configurable parameters

          shmmax       1,073,741,824 (1 GB)

          shmmin        [doesn’t exist on the K-Server at Chico]

          shmmni        unchanged at 200 (rec = 100)

          shmseg        unchanged at 120 (rec = 100)

Recommended values are for 1 instance.  May need to be raised later.

shmmni = shared memory identifiers

shmseg = max number of shared memory segments that one user process can attach

B)   Set up the following Unix groups –

sam -> accounts -> groups

add   dba group, operator group and oinstall

 

C)   Set up the following Unix account –

sam -> accounts -> users

add oracle, group = oinstall, shell = ksh

add lines to the .profile –

     umask 022

     ORACLE_BASE=/u01/app/oracle

     ORACLE_HOME=$ORACLE_BASE/product/8.1.7

     export ORACLE_BASE ORACLE_HOME

 

edit /etc/group to make ‘oracle’ a member of the ‘dba’ group

D)   File system settings –

Mount Points:

     mkdir /u01 /u02 /u03 /u04

     chown oracle /u01 /u02 /u03 /u04

 

Logical Volumes and File Systems – (example)

     lvcreate –L 2256 –n lvol9 /dev/vg00

     lvcreate –L 1024 –n lvol10 /dev/vg00

     lvcreate –L 1024 –n lvol11 /dev/vg00

     lvcreate –L 1024 –n lvol12 /dev/vg00

     newfs –F vxfs /dev/vg00/r1vol9

     newfs –F vxfs /dev/vg00/r1vol10

     newfs –F vxfs /dev/vg00/r1vol11

     newfs –F vxfs /dev/vg00/r1vol12

 

Mounting –

     add lines to /etc/fstab:

     /dev/vg00/lvol9 /u01 vxfs delaylog 0 2

     /dev/vg00/lvol10 /u02 vxfs delaylog 0 2

     /dev/vg00/lvol11 /u03 vxfs delaylog 0 2

     /dev/vg00/lvol12 /u04 vxfs delaylog 0 2

     mountall       [uses fstab to mount volumes]

     bdf              [confirms mounts and sizes]

 

     double check the ownership of /u01, /u02, etc.

     chgrp them to oinstall

 

E)    Copy the CD(s) to an area on the disk for read and write access.  Note, if you are doing an installation with 2 CDs, copy each to a temporary area on disk.  Very important!  Oracle uses the pfs (portable file system) for its installation CDs.  Be sure to follow the instructions below that deal with mounting a CD using pfs.... OR YOU WILL HAVE PROBLEMS!!

First, create the following directory –

lvcreate –L700 –n lvoltempcd /dev/vg00

newfs –F hfs /dev/vg00/rlvoltempcd

mkdir /tempcd                     [mountpoint]

mount –F hfs /dev/vg00/lvoltempcd /tempcd

bdf                            [confirm success]

 

Next, mount the CD –

add the line to  /etc/pfs_fstab:

/dev/dsk/c4+2d0 /tmp_mnt pfs-rrip xlat=unix 1 0

nohup /usr/sbin/pfs_mountd &

nohup /usr/sbin/pfsd &

 

[Now put the CD in the tray]

/usr/sbin/pfs_mount /tmp_mnt

 

Copy the CD to the disk:

cp –r /tmp_mnt/* /tempcd

 

3.     Using the Oracle Universal Installer (OUI)

Log in as oracle

cd /tempcd  [our copy of the CD]

./runInstaller &

          ORACLE_HOME  match shell environment var

The ‘oinstall’ UNIX group should have permission to update ORACLE software.  When it asks, su to root in a UNIX window and run its script.  Then click ‘retry’.

Choices:

Oracle 8i Enterprise Edition

Typical Installation (1.02 GB)

Global Database Name: ORCL(followed by network suffixes)

SID (System Identifier): ORCL

Database files location: switch to /u02

 

-         It runs for a while (approx. 45 minutes), then asks root to run

/u01/app/oracle/product/8.1.7/root.sh

                   - Then the Net8 configuration assistant and the Oracle database

                      configuration assistant automatically run