Malcolm's Tech Notes

Quick install guide for Oracle 11g on Linux

0. Requirements

  • Install X-Windows
  • Memory – more the 2GB memory
  • Swap –if > 2GB, same size as memory
  • Disk space = 1gb in /tmp, 5gb on /
  • OEL 7
  • Kernel = 3.10.0-54.0.1.el7.x86_64 or later
  • The following packages may need to be installed :
    • binutils-2.23.52.0.1-12.el7.x86_64
    • compat-libcap1-1.10-3.el7.x86_64
    • gcc-4.8.2-3.el7.x86_64
    • gcc-c++-4.8.2-3.el7.x86_64
    • glibc-2.17-36.el7.i686
    • glibc-2.17-36.el7.x86_64
    • glibc-devel-2.17-36.el7.i686
    • glibc-devel-2.17-36.el7.x86_64
    • ksh
    • libaio-0.3.109-9.el7.i686
    • libaio-0.3.109-9.el7.x86_64
    • libaio-devel-0.3.109-9.el7.i686
    • libaio-devel-0.3.109-9.el7.x86_64
    • libgcc-4.8.2-3.el7.i686
    • libgcc-4.8.2-3.el7.x86_64
    • libstdc++-4.8.2-3.el7.i686
    • libstdc++-4.8.2-3.el7.x86_64
    • libstdc++-devel-4.8.2-3.el7.i686
    • libstdc++-devel-4.8.2-3.el7.x86_64
    • libXi-1.7.2-1.el7.i686
    • libXi-1.7.2-1.el7.x86_64
    • libXtst-1.2.2-1.el7.i686
    • libXtst-1.2.2-1.el7.x86_64
    • make-3.82-19.el7.x86_64
    • sysstat-10.1.5-1.el7.x86_64
  • Oracle ODBC drivers (www.unixodbc.org)
    • unixODBC-2.3.1-6.el7.x86_64 or later
    • unixODBC-2.3.1-6.el7.i686 or later
    • unixODBC-devel-2.3.1-6.el7.x86_64 or later
    • unixODBC-devel-2.3.1-6.el7.i686 or later

1. user and group setup

 # /usr/sbin/groupadd oinstall
 # /usr/sbin/groupadd dba
 # /usr/sbin/useradd -g oinstall -G dba oracle
 # passwd oracle

2. Kernel parameters
edit the /etc/sysctl.conf file and add the following

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

3. System settings
add the following line to /etc/security/limits.conf

oracle hard nofile 65536

4. directory setup

 # mkdir -p /u01/app/
 # chown -R oracle:oinstall /u01/app/
 # chmod -R 775 /u01/app/

5. oracle user shell setup
for the Bourne, Bash or Korn shell add the following to the oracle users .bashrc file

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_SID=rabbit; export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/11.2.0/rabbit;
export ORACLE_HOME
ORACLE_HOSTNAME=oradb11g; export ORACLE_HOSTNAME
ORACLE_UNQNAME=rabbit; export ORACLE_UNQNAME
ORACLE_HOME_LISTENER=/u01/app/oracle/product/11.2.0/rabbit;
export ORACLE_HOME_LISTENER
PATH=$PATH:/u01/app/oracle/product/11.2.0/rabbit/bin; export PATH

6. Installation

$ /mount_point/db/runInstaller