Oracle Linux Configuration for Database Installation
Version 11.2.0.1
 
>As root: Append servers to hosts file
Resources
Links of Interest Download CDs

Installation Documents
Operating System Oracle Enterprise Linux 5.2
 
Operating System Configuration
As root: Install missing RPMs --mount CD3
cd /media/cdrom/Enterprise/RPMS

rpm -Uvh libaio-0 [Tab]
rpm -Uvh libaio-devel-0.3.105-2.i386.rpm

cd /

eject cdrom

-- mount CD4
cd /media/cdrom/Enterprise/RPMS

rpm -Uvh elfutils-libelf-0 [Tab]
rpm -Uvh elfutils-libelf-devel-0.91.1-3.i386.rpm

cd /

eject cdrom

-- mount CD1

cd /media/cdrom/Enterprise/RPMS

rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
As root: Create DBA Group and Oracle User /usr/sbin/groupadd -g 500 oinstall
/usr/sbin/groupadd -g 501 dba
/usr/sbin/groupadd -g 502 oper
/usr/sbin/useradd -u 500 -m -g oinstall -G dba,oper oracle
id oracle

-- set the password to oracle1
passwd oracle

id nobody
-- if nobody does not exist then
/usr/sbin/useradd nobody
As root: Create Installation Directories mkdir -p /app/oracle
chown -R oracle:dba /app/oracle
chmod -R 775 /app/oracle

mkdir /stage
chown -R oracle:dba /stage
As root: Alter Kernel Parameters cat >> /etc/sysctl.conf <<EOF
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
tcp.ipv4.tcp_wmem = 262144 262144 262144
tcp.ipv4.tcp_rmem = 4194304 4194304 4194304
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65000
EOF

-- activate changes
/sbin/sysctl -p
As root: Set Shell Limits -- modify limits.conf
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

--modify /etc/pam.d/ login
session required pam_limits.so
As root: Change Default Profile -- if Bourne, Korn or Bash shell. Check the install docs if C shell
cat >> /etc/profile <<EOF
if [ $USER = "oracle" ]; then
  if [ \$SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
  umask 022
fi
EOF
Optimize TCP/IP Stack Handling -- enable TCP kernel auto_tuning
/proc/sys/net/ipv4/tcp_moderate_rcvbuf (1=on)

--
--
--

/proc/sys

-- tune the socket buffer sizes by setting to 2xBDP
/proc/sys/net/core/rmem_max and wmem_max

-- ensure
/proc/
/proc/
/proc/

-- additionally be sure NIC cards have TCP off-loading capability
As root: Apend servers to host file cd /etc

Note: the line:
127.0.0.1   omega#.mlib.org   omega#   localhost.localadmin localhost
delete the first two entries but do not delete localhost.localadmin
and local host or nothing will work properly.


vi hosts
vi command help
Append Esc A
Insert Esc I
Abort and quit Esc q!
Save and quit Esc wq
 
192.168.1.211 alpha1 alpha1.mlib.org
192.168.1.212 alpha2 alpha2.mlib.org
192.168.1.221 beta1 beta1.mlib.org
192.168.1.222 beta2 beta2.mlib.org
192.168.1.231 gamma1 gamma1.mlib.org
192.168.1.232 gamma2 gamma2.mlib.org
192.168.1.241 delta1 delta1.mlib.org
192.168.1.242 delta2 delta2.mlib.org
192.168.1.251 eta1 eta1.mlib.org
192.168.1.252 eta2 eta2.mlib.org

-- ping all hosts (substitute actual node names for the "omega")
ping 192.168.1.1
ping www.oracle.com
ping omega1
ping omega2
ping omega1.mlib.org
ping omega2.mlib.org
As root: Modify .bashrc # cd /home/oracle

vi .bashrc

-- append the following
umask 022

ORACLE_HOSTNAME=?.mlib.org
ORACLE_BASE=/app/oracle/product
ORACLE_HOME=/app/oracle/product/11.2.0/db_1
ORACLE_SID=?
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TMP=/tmp
TEMP=/tmp
TMPDIR=/tmp
PATH=$ORACLE_HOME/bin:$PATH
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH
export TMP TEMP TMPDIR

alias oh='cd $ORACLE_HOME'
alias sql='sqlplus "/ as sysdba"'

-- close all open terminal windows and open new ones

$ set

-- validate the environment
 
Database Software-Only Installation
After unzipping the installation files change to the directory containing runInstaller

You must be the oracle user (not root) and you must verify your shell is set correctly
Step 1: Choose the Software Only install option
Step 2: For a standalone database choose the first option. For a RAC cluster the second
Step 3: Accept the default
Step 4A: Accept the default. Before selecting "Next" examine the "Select Options" choices
Step 4B: Review the "Select Options" Choices
Step 5: Accept the defaults ... they are based on the environment variables set in your shell
Step 6: Accept the default
Step 7: Accept the defaults
Step 8: This is a typical result if you didn't read and follow the docs.
Step 9: If Windows find a copy of Oracle Database 10.2.0.2 through 10.2.0.4 and follow these steps to get SQL*Plus Windows
Step # Description
1 Copy the following DDL files from the $ORACLE_HOME/bin directory of the 10gR2 database to $ORACLE_HOME\bin of the 11.2.0.1 install.
ltscsn10.dll oraldapclnt10.dll oranldap10.dll oraocr10.dll orasql10.dll
oraclient10.dll oran10.dll oranls10.dll oraocrb10.dll oraunls10.dll
oracommon10.dll orancds10.dll orannzsbb10.dll oraplp10.dll oravsn10.dll
oracore10.dll orancrypt10.dll oranro10.dll orapls10.dll oraxml10.dll
orageneric10.dll oranhost10.dll orantcp10.dll ORASLAX10.dll sqlplusw.exe
orahasgen10.dll oranl10.dll orantns10.dll orasnls10.dll  
2 Copy the file spwus.msb from $ORACLE_HOME\sqlplus\mesg to the corresponding directory in the 11gR2 file system.
 
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved