Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at

RAC Node1 RPM and Users - RAC 12c Setup Step by Step on Oracle Virtual Box with Oracle Enterprise Linux(OEL) - Chapter 2

1 comment
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 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 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:

Other steps:

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

#Grid user
export ORACLE_HOME=/u01/app/12.1.0/grid
export ORACLE_BASE=/u01/app/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

#Oracle User
export ORACLE_HOME=/u01/app/oracle/product/12.1.0
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
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   racnode1   racnode2      racnode1-priv      racnode2-priv   racnode1-vip   racnode2-vip   racdb-scan   racdb-scan   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/

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

1 comment :