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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.