Linux-based Oracle RAC 10g cluster Tutorial: steps required to add nodes

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:

1. Dependencies and prerequisites
2. Configure network components
3. Install Oracle Cluster
4. Configure Oracle Cluster
5. Install Oracle software
6. Add new instances (one or more instances)
7. 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

1 2 3 4 5 6 7 Next Page