Installing oracle


Copyright 2002, 2003 Andy Barclay
OpenContent License (OPL)

Add the following to /etc/system
=========================
* AWB - added for oracle at re-install time 1999/01/21
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmseg=50
set semsys:seminfo_semmsl=150
set semsys:seminfo_semmns=1750
set semsys:seminfo_semmni=200
============================

Create the dba group
# groupadd -g 1000 dba

Create the oracle user
# useradd -u 1000 -g dba -d /orahome -s /bin/ksh -c "Oracle User" -m oracle

Apply a password to the oracle account
# passwd oracle

Edit the /etc/group file and explicitly add oracle to the dba group
(there is a bug in oracle 8.04. The orainst program checks for explicit 
membership regardless of the primary group setting)
 
Create the oracle user's .profile
===========================
ORACLE_BASE=/orahome/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/8.0.4
ORACLE_SID=TESTING
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:/usr/sbin:/usr/ccs/bin:$ORACLE_HOME/bin
ENV=$HOME/.kshrc
EDITOR=vi
export PATH MANPATH EDITOR ORACLE_BASE ORACLE_HOME ORACLE_SID ENV
===========================

Create the oracle user's .kshrc
===========================
HISTSIZE=1024
set -o vi
delim="$"
[ `id | tr "()" "  " |awk '{print $2}'` = "root" ] && delim="#"
export delim
PS1=`uname -n`:'$PWD''$delim ';export PS1
#stupid stty settings
stty kill "^U" erase "^H" intr "^C" susp "^Z"
[ -n "$DEBUG" ] && echo end of .kshrc
===========================

reboot the machine so that the required /etc/system settings take effect.

Login as root
# ORACLE_OWNER=oracle; export ORACLE_OWNER
# cd /cdrom/oracle804/orainst
# ./oratab.sh

Make the directory for the oracle data files
# mkdir /opt/oradata
# chown oracle:dba /opt/oradata

Login as the oracle user and run orainst
# cd /cdrom/oracle804/orainst
# ./orainst
	-choose custom install
	-choose install, upgrade, or de-install softwae
	-choose "install new product, create db objects"
	-defaults for oracle_home, oracle_base, logs
	-choose "American English"
	-choose the following products:
		-NET8
		-NET8 Protocol Adapters (only TCP/IP)
		-Oracle Unix Installer
		-Oracle8 Enterprise (RDBMS)
		-Oracle8 JDBC Drivers
		-PL/SQL
		-Solaris Specific Documentation
		-SQL*Plus
	-choose "Install"
	-accept default for oracle doc directory
	-choose "both" for documentation format
	-choose defaults for dba group and OSOPER group
	-choose NOT to distribute control files over 3 mount points
	-choose /opt as mount point
	-choose US7ASCII as character set
	-choose US7ASCII as national character set
	-choose "manager" as the password for the "oracle" and "sys" oracle accounts
	-choose not to set the passwords for the internal oracle users
	-choose "oradba" as password for TNS listener
	-choose to configure the Multi-threaded server and start the SQL*Net listener
	-accept default control files
	-accept default names and sizes for remainder of files
	-do NOT install legato storage manager
	-choose to install only the JDK 1.1 OCI and Thin JDBC drivers
	-choose to install the sql*plus help facility and the sql*plus demo tables

As root, run the root.sh executable which was created by the oracle install
#