CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Linux Configuration for Database Installation
Version 11.1
 
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 = 65536
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 = 262144
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.ip_local_port_range = 1024 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
-- read the file and place above the last lines as indicated
session required /lib/security/pam_limits.so
session required pam_limits.so

As root: Change Default Profile
-- if Bourne, Korn or Bash 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

-- if C shell
cat >> /etc/csh.login <<EOF
if ( \$USER == "oracle" ) then
  limit maxproc 16384
  limit descriptors 65536
  umask 022
end if
EOF

As root: Append servers to hosts file
cd /etc

Note: the line:
127.0.0.1   omega#.psoug.org   omega#   localhost.localadmin localhost
must remain. If you delete it ... nothing will work properly.


vi hosts
Append Esc A
Insert Esc I
Abort and quit Esc q!
Save and quit Esc wq
 
192.168.1.211 alpha1 alpha1.psoug.org
192.168.1.212 alpha2 alpha2.psoug.org
192.168.1.221 beta1 beta1.psoug.org
192.168.1.222 beta2 beta2.psoug.org
192.168.1.231 gamma1 gamma1.psoug.org
192.168.1.232 gamma2 gamma2.psoug.org
192.168.1.241 delta1 delta1.psoug.org
192.168.1.242 delta2 delta2.psoug.org
192.168.1.251 eta1 eta1.psoug.org
192.168.1.252 eta2 eta2.psoug.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.psoug.org
ping omega2.psoug.org

As root: Modify .bashrc
# cd /home/oracle

vi .bashrc

-- append the following:
umask 022

ORACLE_BASE=/app/oracle/product/
ORACLE_HOME=/app/oracle/product/11.1.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"'
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [219 users online]    © 2010 psoug.org