A Sample Plan

Customer XYZ

HP Oracle Installation Analysis

DRAFT 1/24/98

1.  Overview
This document seeks to capture the design rationale used when installing and configuring the Oracle Relational Data Base Management System on the HP 9000 series 800 server at customer XYZ.

2.  Overall System Conceptual Design
Several applications are being developed or converted to run in a client/server environment. The HP 800 computer will act as the database server in this environment. In addition, several off-the-shelf applications may be purchased and loaded on this computer. Some of these applications may use the client/server model and others may require the users to log in to the HP 800 as a terminal and execute the applications on the HP 800 itself.

3.  Oracle Installation Conceptual Design
Instances will be arranged based on development, test, and production needs.

4.  Initial Configuration Recommendation
Install only a development instance. Ensure that the methodology allows expansion to future instances.

5.  Significant Installation Notes

a.  Oracle8.1 requires HP-UX 10.0.

b.  Dependencies:

SQL*Plus	Oracle8 server
	Help tables
SQL*Net TCP	Oracle8 server

c.  Space Requirements

Product	Disk (MB)	DB (MB)	Memory (KB)
Oracle server	35.28	12.5	4,456
PL/SQL	0.08	0	807
SQL*Net TCP	0.73	0	0
SQL*Plus	4.47	3.0	1,617
Pro*C	3.49	0	2,437
Totals	84	12.5	N/A*

---

^*
Not applicable because many of the packages, such as SQL*Plus, may not be in use at all times.

---

d.  SQL*Plus 3.3 or later is needed for Oracle8.

e.  After loading, but before installing, in .login file, set LDOPTS=”-a archive”;export LDOPTS. Then log in and log out.

f.  Purchase includes Oracle RDBMS version 8.0 for HP 98xx/HP-UX 10.0, Model H50 for 32 concurrent users full-use license.

—SQL*Plus version 3.3

—SQL*Net version 3.0

—SQL*Net TCP/IP

g.  The CSI # is 123456 (good through 12/27/99)

Oracle support #	(650) 506-1500
PO #	99999

6.  Initial Oracle Instance Configuration Options
Disk drive configurations:

/usr/oracle	Oracle base application directory
/usr/oracle/product	Oracle home directory
/usr/oracle/product/801	Install point for this release
/d1/oracle/devel	Development instance directory
/d2/oracle/devel	Development instance directory
/d3/oracle/devel/redo	Storage for online redo logs
/d3/oracle/devel/archive	Storage for archive logs
/d4	Future use
/d5	Future use

7.  Preparation Tasks

a.  HP admin create dba group.

b.  HP admin create data base administrator logins within dba group.

c.  HP admin create oracle owner account in dba group.

d.  HP admin create oracle user logins. Note, some thought needs to go in to how the regular user groups will be arranged. There is no need to worry about users who will access only via client/server. This applies to developers and others who will log in to the server.

e.  HP admin create files.

f.  HP admin alter the UNIX kernel parameters as follows:

SHMMAX	0x4000000	{4 million}
SHMMNI	100
SHMSEG	12
SEMMNS	128
SEMMNI	10

g.  Root user create all mount point directories (/d1, /d2, and so on).

h.  Root user creates the directories listed in 6a with owner Oracle and mode 755.

i.  User oracle set ORACLE_BASE environmental variable.

j.  Create the following subdirectories in ORACLE_BASE:

—product

—admin

—data

—local

—TAR

k.  Create version 801 subdirectory under ORACLE_BASE/product.

l.  Set ORACLE_HOME environmental variable to ORACLE_BASE/product/801.

Summary

This chapter has provided some discussion related to the installation of the Oracle database server. I must emphasize that it is not intended as a replacement for the installation manual. You cannot survive without your installation manual, its sizing checklists, and other information. What I hoped to provide are some of the considerations that are either not in the installation manual or that are not emphasized enough. Oracle installations and upgrades are challenging affairs that require careful planning and sufficient time to accomplish. Having a test system on which you can work out the bugs without impacting users is one of the best things that you can do, both for your users and for yourself. I hope that this chapter has not been too gloomy for you. Let me end it by saying that I have not run across a system where I could not complete the installation of the Oracle server. It may take a little bit of time and a few calls to Oracle, but I’ve always found that it can be done