Today, after repeated tests, the RAC was successfully configured. Now, the detailed operation steps are posted for your reference, we hope that we can avoid unnecessary detours when we are confused about RAC configurations. We also hope that our friends will find many shortcomings and make common progress.
1. Environment:
Vmware server 1.7, ORALCE 10 Gb, system platform is Red Hat 4 Enterprise Edition, based on RAW device RAC, disk array is replaced by analog shared storage, with two nodes.
Node information: IP PRIVIP VIP HOSTNAME 123.125.17.2 192.168.100.2 123.125.17.6 RAC-01 123.125.17.4 192.168.100.3 123.125.17.8 RAC-02 |
2. Configure the system
The steps for installing, creating, and creating shared storage are omitted. As long as the corresponding development kit has to be fully loaded, I believe that since you can play RAC, the following operations will be required:
(1) Add Oracle users and their groups
Command:
/Usr/sbin/groupadd oinstall /Usr/sbin/groupadd dba /Usr/sbin/useradd-m-g oinstall-G dba oracle Id oracle |
Note that the user ID and group ID must be the same on all cluster hosts.
Set the password for the oracle account:
# Passwd oracle Changing password for user oracle. New password: Retype new password: Passwd: all authentication tokens updated successfully. |
(2) create a mount point
Run the following command as the root user:
Mkdir-p/u01/app/oracle Chown-R oracle: oinstall/u01/app/oracle Chmod-R 775/u01/app/oracle |
(3) Configure Kernel Parameters
Log on as a root user and configure Linux Kernel Parameters on each host.
Cat>/etc/sysctl. conf> EOF Kernel. shmall = 2097152 Kernel. shmmax = 2147483648 Kernel. shmmni = 4096 Kernel. sem = 250 32000 100 128 Fs. file-max = 65536 Net. ipv4.ip _ local_port_range = 1024 65000 Net. core. rmem_default = 262144 Net. core. wmem_default = 262144 Net. core. rmem_max = 262144 Net. core. wmem_max = 262144 EOF /Sbin/sysctl-p |
For specific Kernel Parameter Values, set them according to the system environment. In this example, the test environment is used.
(4) Configure LIMIT
We recommend that you set a limit on the number of processes that each Linux Account can use and the number of files opened. To make these changes, cut and paste the following commands as the root user.
Cat>/etc/security/limits. conf> EOF Oracle soft nproc 2047 Hard nproc 16384 Oracle soft nofile 1024 Oracle hard nofile 65536 EOF |
(5) configure the Hangcheck timer for all RHEL versions:
Modprobe hangcheck-timer hangcheck_tick = 30 hangcheck_margin = 180 Cat>/etc/rc. d/rc. local> EOF Modprobe hangcheck-timer hangcheck_tick = 30 hangcheck_margin = 180 EOF |
(6) Configure/etc/hosts
In some Linux distributions, the host name is associated with the return address (127.0.0.1. In this case, the host name is deleted from the return address.
The/etc/hosts file used in this Guide:
127.0.0.1 localhost. localdomain localhost The 192.168.100.2 rac-priv01 192.168.100.3 rac-priv02 123.125.17.2 rac-01 Rac-02 123.125.17.4 123.125.17.6 rac-vip01 123.125.17.8 rac-vip02 |
Note that the host name should not appear in the loopback address, and the public IP address of the local machine must be in the same network segment (or local area network) as the VIP address. When setting the IP address, the IP gateway of the same network segment must be the same.
The preceding six steps must be performed on all nodes.