OracleDB‎ > ‎


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 as root)

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

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

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