Oracle Database Installation

copy the installation CD or tar to /staging

Create the following groups:

groupadd oinstall
groupadd dba
groupadd oper

Create the following users: install zsh oracle (default group: oinstall, and a member of dba and oper)

/usr/sbin/useradd -g oinstall -G dba,oper -d /home/oracle -s /bin/zsh -p oraclePassword oracle

add the followings to /etc/sysctl.conf.

kernel.shmmax = 2147483648
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

You can load these config changes by running:

sysctl -p

Create necessary directories:

mkdir /var/opt/oracle
chown oracle:dba /var/opt/oracle
chmod 755 /var/opt/oracle
mkdir -p /u01/app/oracle         (this will be $ORACLE_BASE)
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle

create a seperate partition /u02 for data, log, and control files (create more than one pa rtition if possible) assuming the database name is going to be prod10

cd /u02
mkdir -p prod10/oradata/prod
chown -R oracle:oinstall prod10/oradata/prod
chmod -R 775 /prod10/oradata/prod

if installing 10g or newer create a flash recovery area

mkdir -p /prod20/oradata/prod/flash_recovery_area
chown -R oracle:oinstall /prod20/oradata/prod/flash_recovery_area
chmod -R 775 /prod20/oradata/prod/flash_recovery_area

Put the followings to the /home/oracle/.oracle_profile

umask 022
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
ORACLE_BASE=/opt/oracle
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_BASE ORACLE_HOME
export PATH LD_LIBRARY_PATH

/home/oracle/.zshrc should have the following

HISTFILE=~/.histfile
HISTSIZE=1000
SAVEHIST=1000
bindkey -e
zstyle :compinstall filename '/home/oracle/.zshrc'
autoload -Uz compinit
compinit
. ~/.oracle_profile
function precmd { export PROMPT=%n@%M:$ORACLE_SID:%~$\ }
echo "Current ORACLE* values:"
echo ""
env | grep ORACLE | grep -v PS | sort
echo ""

Make sure you have the required packages installed before starting the installer.

rpm -q binutils gcc glibc glibc-headers glibc-kernheaders glibc-devel xorg-x11-deprecated-libs\
compat-libstdc++ cpp compat-gcc make compat-db compat-gcc-c++ compat-libstdc++\
compat-libstdc++-devel openmotif openmotif21 setarch pdksh libaio libaio-devel

make sure /tmp is mounted with executable permissions Start by running ./runInstaller

. advanced

. Enterprise Edition

. choose db_1 for name and /u01/app/oracle/product/10.2.0/db_1 for home

. Install database software only

. Install

. (one some point the installer will ask you to run roo.sh as root)

Open a new window and run /u01/app/oracle/product/10.2.0/db_1/root.sh as root

also orainstRoot.sh located in /u01/app/oracle/oraInventory .exit add to .profile

ORAENV_ASK=NO
. /usr/local/bin/oraenv