In most businesses, the main business requirement for true Oracle Application cluster (RAC) configuration based on the Linux platform is the scalability of the database layer in the entire system-in this way, when the number of users increases, you can add additional instances to the cluster to distribute the load.
In Oracle RAC 10GThis particular feature has become easier. When the node/Instance becomes available, Oracle can include this plug-and-play function through several necessary setup steps.
In this article, I will discuss how to add nodes to existing Oracle RAC 10GSteps required for cluster version 2nd.
Current Environment
For demonstration purposes, the environment here is a four-node Rd Hat Linux cluster. This task is to add an additional node to make it a five-node cluster.
Database Name |
Node number |
Database Version |
Instance id |
Operating system kernel version |
File System |
Cluster Manager |
SSKYDB |
Four nodes: oradb1, oradb2, oradb3, and oradb4 |
10.2.0.1 |
Four instances: SSKY1, SSKY2, SSKY3, and SSKY4 |
Red Hat Enterprise Linux AS 3 Linux sumsky.net 2.4.21-32. ELsmp |
OCFS 1.0 and ASM |
Oracle Cluster |
This process is implemented in the following seven steps:
- Dependencies and prerequisites
- Configure network components
- Install Oracle Cluster
- Configure Oracle Cluster
- Install Oracle software
- Add new instances (one or more instances)
- Execute routine management tasks
Step 2: Consider dependencies and prerequisites
The first major step of any software installation or upgrade is to ensure that the complete backup of the system is available, including the operating system and data files. The next step is to verify the system requirements, operating system versions, and patch levels for all applications.
The new node should have the same OS version as the existing node, including all Patches required by Oracle. In this example, because the operating system residing on nodes 1 to 4 is Red Hat Enterprise Linux 3, the new node should also have this version. In addition, in order to maintain the current naming convention, the new node should be called oradb5.
In addition to the basic operating system, you should also install the following packages required by Oracle:
[root@oradb5 root]# rpm -qa | grep -i gcccompat-gcc-c++-7.3-2.96.128compat-gcc-7.3-2.96.128libgcc-3.2.3-42gcc-3.2.3-42[root@oradb5 root]# rpm -qa | grep -i openmotifopenmotif-2.2.3-3.RHEL3openmotif21-2.1.30-8[root@oradb5 root]# rpm -qa | grep -i glibcglibc-2.3.3-74glibc-utils-2.3.3-74glibc-kernheaders-2.4-8.34.1glibc-common-2.3.3-74glibc-headers-2.3.3-74glibc-devel-2.3.3-74[root@oradb5 root]# rpm -qa | grep -i compatcompat-libstdc++-7.3-2.96.128compat-gcc-c++-7.3-2.96.128compat-gcc-7.3-2.96.128compat-db-4.0.14-5compat-libstdc++-devel-7.3-2.96.128[root@oradb5 root]#
Use the following values to update kernel parameters.
kernel.core_uses_pid = 1kernel.hostname = oradb5.sumsky.netkernel.domainname = sumsky.netkernel.shmall = 2097152#kernel.shmmax = 536870912kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.shmseg = 4096kernel.sem = 250 32000 100 150kernel.msgmnl = 2878kernel.msgmnb = 65535fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.wmem_default = 262144net.core.rmem_max = 262144net.core.wmem_max = 262144
Add the following parameters to/etc/security/limits. conf.
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
Add the device to/etc/fstab-copy the device definition from one of the existing nodesOradb5.
[root@oradb5 root]$ more /etc/fstabLABEL=/ / ext3 defaults 1 1none /dev/pts devpts gid=5,mode=620 0 0none /proc proc defaults 0 0none /dev/shm tmpfs defaults 0 0/dev/sda2 swap swap defaults 0 0/dev/cdrom /mnt/cdrom udf,iso9660 noauto,owner,kudzu,ro 0 0/dev/fd0 /mnt/floppy auto noauto,owner,kudzu 0 0/dev/sdb5 /u01 ocfs _netdev 0 0/dev/sdb6 /u02 ocfs _netdev 0 0/dev/sdb7 /u03 ocfs _netdev 0 0/dev/sdb8 /u04 ocfs _netdev 0 0/dev/sdb9 /u05 ocfs _netdev 0 0/dev/sdb10 /u06 ocfs _netdev 0 0/dev/sdb14 /u14 ocfs _netdev 0 0