In the Previous post, we have discussed the rac node 1 server setup. In this post, we would be configuring the rpms,asm libraries and users/groups on racnode1.


Oracle Installation (Automatic Setup)

Oracle provides rpm for automatic setup for the installation, download and installs the rpm via yum.
Oracle user will be created here

 I have used automatic method.It will require your server is connected to the internet.

yum install oracle-rdbms-server-12cR1-preinstall -y

 Oracle Installation (Manual Setup)

In case you do not wish to use automatic installation please follow steps for manually configuring the env. for Oracle 12c installation. Even if you go for automatic setup please ensure below settings to avoid any gaps.

Add or Amend following lines to “/etc/sysctl.conf”.

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

Run following command to make these changes in effect.

/sbin/sysctl -p


Install following packages recommended for Oracle 12c installation.


yum install binutils -y
yum install compat-libcap1 -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y

------------------------------Manual Steps End  Here--------------------------------------------

Additional steps:
Every time
Add the following lines to the “/etc/security/limits.conf” file.

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

Installing ASM libraries.

yum install kmod-oracleasm -y
yum install oracleasm-support -y

oracleasmlib is not available from the default yum repository. You can pull the oracleasmlib RPM from Oracle’s ASMLIB page for Oracle Linux 6:

rpm -ihv oracleasmlib-2.0.12-1.el6.x86_64.rpm


Other steps:


Regardless of Automatic or Manual setup following steps needs to be performed.

yum install xclock

Create required Users, Groups and directories.

groupadd  oinstall
groupadd  dba
groupadd  asmadmin
groupadd  asmdba
useradd -u -g oinstall -G dba,asmdba oracle -- Not required if automatic method for rpm installation is used--
usermod -g oinstall -G dba,asmdba,asmadmin oracle
mkdir -p /u01/app/12.1.0/grid  ####{grid-home}
mkdir -p /u01/app/grid  ######{grid-base}
mkdir -p /u01/app/oracle/product/12.1.0  ######(oracle home)
chown -R  oracle:oinstall /u01/app/

chmod -R 775 /u01
useradd -u 1100 -g oinstall -G asmadmin,asmdba grid
chown -R grid:oinstall /u01

passwd oracle
passwd grid

Set Bash Profile for both Grid & Oracle User
#Grid user
export ORACLE_HOME=/u01/app/12.1.0/grid
export ORACLE_SID=+ASM1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE=/u01/app/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib





#Oracle User
export ORACLE_HOME=/u01/app/oracle/product/12.1.0
export ORACLE_SID=RACDB
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
chmod -R 775 /u01/app/oracle/product/12.1.0
chown -R oracle:oinstall /u01/app/oracle/product/12.1.0
Add entry in /etc/hosts
192.168.56.10   racnode1    
192.168.56.11   racnode2    
10.10.0.10      racnode1-priv
10.10.0.11      racnode2-priv
192.168.56.111   racnode1-vip
192.168.56.112   racnode2-vip
192.168.56.121   racdb-scan  
192.168.56.122   racdb-scan  
192.168.56.123   racdb-scan 

Disable firewall

  • service iptables stop
  • chkconfig iptables off

 Disable SELINUX
Edit the /etc/selinux/config file as:-


  • SELINUX=permissive
And then run the following command:-
  • setenforce Permissive

Disable NTP
  • service ntpd stop
  • chkconfig ntpd off
  • mv /etc/ntp.conf /etc/ntp.conf.orig.bkp
  • rm -rf /var/run/ntpd.pid


Amend the “/etc/security/limits.d/90-nproc.conf” file as below

  • *          -       nproc     16384
  • root       soft    nproc     unlimited

For virtual box
usermod -G vboxsf,dba,asmdba oracle

usermod -g oinstall -G asmadmin,asmdba,vboxsf  grid