Oracle Database Quick Installation steps 11g Release 2 for Linux x86-64

This article is a comprehensive steps for installing Oracle Database 11g Release 2 (11.2.0.1) on the Red Hat Enterprise Linux 6 (RHEL6)  operating environment.

Both 32-bit (x86) and 64-bit (x86_64) architectures are covered in this guide. Unless otherwise noted, the installation steps are the same for either. Having said that, one of the first decisions to make before continuing with this guide is which architecture you will be using. Both Oracle and Linux must be installed on the same operating system architecture. For example, 32-bit Oracle is only supported to run on 32-bit Linux OS and 64-bit Oracle is only supported to run on 64-bit Linux OS.


Install Required Linux Packages for Oracle:

After installing the Linux OS, the next step is to verify and install all packages required for Oracle Database 11g Release 2. The Oracle Universal Installer (OUI) performs checks on the machine during installation to verify that it meets the appropriate operating system package requirements. To ensure that these checks complete successfully, verify the software requirements documented in this section before starting the Oracle install. 

The following or later version of packages for Oracle Linux 6, and Red Hat Enterprise Linux 6 must be installed:


binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
unixODBC-2.2.14
unixODBC-2.2.14 (32 bit)
unixODBC-devel-2.2.14


Create Groups and User for Oracle Database Software:

# groupadd -g 501 oinstall

#  groupadd -g 502 dba

# groupadd -g 503 oper

# useradd -m -u 501 -g oinstall -G dba,oper -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle


# passwd oracle


Create the Oracle Base Directory Path:

# mkdir -p /u01/app/oracle

# chown -R oracle:oinstall /u01/app/oracle

# chmod -R 775 /u01/app/oracle






Configuring Kernel Parameters and Resource Limits:

Verify that the kernel parameters shown in the following table are set to values greater than or equal to the minimum value shown.

# vim /etc/sysctl.conf

 

kernel.shmmax = 68719476736

kernel.shmall = 4294967296
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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

Note:
If the current value of any parameter is higher than the value listed in this table, then do not change the value of that parameter.

  Placing the kernel parameters in the /etc/sysctl.conf startup file persists the required kernel parameters through reboots. Linux allows modification of these kernel parameters to the current system while it is up and running, so there's no need to reboot the system after making kernel parameter changes. To activate the new kernel parameter values for the currently running system, run the following as root.

# sysctl -p

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 2097152
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
fs.file-max = 6815744
fs.aio-max-nr = 1048576
 
 
 

Confirm Fully Qualified Name for the Server in /etc/hosts

<IP-address>  <fully-qualified-machine-name>  <machine-name>
 
 

update the resource limits in the /etc/security/limits.conf configuration file for the Oracle installation owner by adding the following lines. 

oracle         soft    nproc          2047
oracle         hard    nproc          16384
oracle         soft    nofile         1024
oracle         hard    nofile         65536
oracle         soft    stack          10240

 Add the following line to the /etc/pam.d/login file, if it does not already exist. 

session    required     pam_limits.so
 

to change ulimit settings for the Oracle installation owner, for the Bourne, Bash, or Korn shell, add the following lines to the /etc/profile file. 

if [ $USER = "oracle" ]; then
  if [ $SHELL = "/bin/ksh" ]; then
    ulimit -p 16384
    ulimit -n 65536
  else
    ulimit -u 16384 -n 65536
  fi
fi

 

Finally Configure the bash_profile for oracle user:

Look like this:

 [oracle@oracle-soa ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
# ---------------------------------------------------
# ORACLE_SID
ORACLE_SID=soadb1; export ORACLE_SID
# ORACLE_UNQNAME and ORACLE_HOSTNAME
ORACLE_UNQNAME=soadb1; export ORACLE_UNQNAME
ORACLE_HOSTNAME=oracle.example.local; export ORACLE_HOSTNAME
# ---------------------------------------------------
# JAVA_HOME
JAVA_HOME=/usr/java; export JAVA_HOME
# ORACLE_BASE
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
# ORACLE_HOME
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/dbhome_1; export ORACLE_HOME
# ORACLE_PATH
ORACLE_PATH=/u01/app/oracle/dba_scripts/sql:$ORACLE_HOME/rdbms/admin; export ORACLE_PATH
# ORACLE_TERM
ORACLE_TERM=xterm; export ORACLE_TERM
# NLS_DATE_FORMAT
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
# TNS_ADMIN
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
# ORA_NLS11
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
# PATH
PATH=.:${JAVA_HOME}/bin:$JAVA_HOME/db/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/oracle/dba_scripts/bin
export PATH
# LD_LIBRARY_PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
# CLASSPATH
CLASSPATH=.:$ORACLE_HOME/jdbc/lib/ojdbc6.jar
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
# TEMP, TMP, and TMPDIR
export TEMP=/tmp
export TMPDIR=/tmp
# UMASK
umask 022

 Finally after configuration of each file for oracle, reboot the server:

 

Download Oracle Database Software:



 Oracle Database

 

 

# mkdir -p /home/oracle/software/oracle

# mv linux.x64_11gR2_database_*  /home/oracle/software/oracle

For installation of Oracle Release 11.2.0.3 Patch Set

# mv p10404530_112030_Linux-x86-64_1of7.zip /home/oracle/software/oracle/

 # mv p10404530_112030_Linux-x86-64_2of7.zip /home/oracle/software/oracle/


 # mv p10404530_112030_Linux-x86-64_6of7.zip /home/oracle/software/oracle/

# unzip linux.x64_11gR2_database_1of2.zip

# unzip linux.x64_11gR2_database_2of2.zip

# unzip  p10404530_112030_Linux-x86-64_1of7.zip

# unzip  p10404530_112030_Linux-x86-64_2of7.zip

# unzip  p10404530_112030_Linux-x86-64_6of7.zip

 

 Install Oracle Database:

Log into the node as the Oracle software owner (oracle). If you are using X emulation then set the DISPLAY environmental variable accordingly.  

$ DISPLAY=<hostname>:0.0; export DISPLAY

Start the Oracle Universal Installer (OUI) by issuing the following command in the database install directory.  

$ cd /home/oracle/software/oracle/database

$ ./runInstaller

& follow the instructions....

 

 

Comments

Post a Comment

Thank you for visiting my blog.

Popular posts from this blog

Defining Audit Rules

The Audit system operates on a set of rules that define what is to be captured in the log files. There are three types of Audit rules that can be specified: Control rules — allow the Audit system's behavior and some of its configuration to be modified. File system rules — also known as file watches, allow the auditing of access to a particular file or a directory. System call rules — allow logging of system calls that any specified program makes.  Audit rules can be specified on the command line with the auditctl utility (note that these rules are not persistent across reboots), or written in the /etc/audit/audit.rules file. The following two sections summarize both approaches to defining Audit rules.   Auditing goals By using a powerful audit framework, the system can track many event types to monitor and audit the system. Examples include: Audit file access and modification See who changed a particular file Detect unauthorized cha...
Read more

AIX Install packages, upgrade, patching commands

lslpp -L                             displays info about all installed filesets or fileset updates lslpp -L <fileset>                   displays info about that fileset lslpp -h <fileset>                   shows the history of the fileset lslpp -l | grep <fileset>           shows if it is installed or not lslpp -lc| grep <fileset>           shows the state (Aplp., Comm., Broken..) in /etc/objrepos and in /usr/lib/objrepos of a fileset lslpp -f <fileset>                   shows all files that are installed with  a particular fileset lslpp -w /usr/local/bin/lsof        shows the fileset which contains the giv...
Read more