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