![]() |
Step by Step of
Adding Node to 11g RAC cluster on Linux: By Bhavin Hingu bhavin@oracledba.org |
Kernel
Parameters:
Oracle
recommends that you set shared memory segment attributes as well as
semaphores to the following values.
If not set, database instance creation will fail. I added the following
lines to /etc/sysctl.conf file. Every OS process needs
semaphore where It waits on for the resources. For more on semaphore,
please read the UNIX os documents.
Oracle 10g RAC requires
to have 1GB of RAM available on each node to sucessfully install 11g
RAC. Well, I have
managed to install it with 512 MB RAM. You will get warning during
checking of pre-requise step of installation
step which you can ignore. Please goto Adding an Extra Swapspace if you
want to have an extra swapspace added.
NOTE:
If the current value for any parameter is higher than the value listed
in this table, then do not change
the value of that parameter.
To see the
current setting in the kernel, please use the below command.
/sbin/sysctl
-a
| grep sem -- for semmsl, semmns, semopm, semmni
/sbin/sysctl
-a
| grep shm -- for shmall, shmmax,
shmmni
/sbin/sysctl -a | grep file-max
/sbin/sysctl
-a
| grep ip_local_port_range
/sbin/sysctl
-a
| grep rmem_default
Please add/change the appropriate
variables value in the /etc/sysctl.conf file as shown below.
After adding these lines to /etc/sysctl.conf, please run the below command as root to make them enabled.
[root@node2-pub
~]#
mkdir -p
/u01/app/crs
[root@node2-pub
~]#
mkdir -p
/u01/app/asm
[root@node2-pub
~]#
mkdir -p
/u01/app/oracle
[root@node2-pub
~]#
mkdir -p
/u02/ocfs2
[root@node2-pub
root]#
chown -R oracle:oinstall /u01
[root@node2-pub
root]#
chown -R oracle:oinstall /u02
[root@node2-pub
root]#
chmod -R 775 /u01/app/oracle
[root@node2-pub
root]#
chmod -R 775 /u01
To
improve the performance of the software on
Linux systems, you must increase the following shell limits
for the oracle user:
Add the following
lines to the
/etc/security/limits.conf file:
oracle soft nproc 2047
oracle hard
nproc 16384
oracle soft
nofile 1024
oracle hard
nofile 65536
Add or edit the following line in the /etc/pam.d/login file, if it does not already exist:
session
required
/lib/security/pam_limits.so
For
the Bourne, Bash, or Korn shell, add the following lines to the
/etc/profile:
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
For the C shell (csh or tcsh), add
the following lines to the /etc/csh.login.
if ( $USER == "oracle" ) then
limit maxproc 16384
limit
descriptors 65536
endif














