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
#