Oracle RAC Installation Deployment documentation

1. Deployment Environment Step 1.1 software Environment

Operating system:
CentOS Release 6.5 (recommended for use with 5.* system)
192.168.1.151 Racnode1
192.168.1.152 Racnode2
Oracle installation package:
P10404530_112030_linux-x86-64_1of7.zip
P10404530_112030_linux-x86-64_2of7.zip
P10404530_112030_linux-x86-64_3of7.zip
kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpm
oracleasmlib-2.0.4-1.el6.x86_64.rpm
oracleasm-support-2.1.8-1.el6.x86_64.rpm

1.2 Configuring host names

Racnode1 Host
Vim/etc/sysconfig/network;
Change Hostname=racnode1
Racnode2 Host
Vim/etc/sysconfig/network;
Change Hostname=racnode2
or with hostname [RACNODE1|RACNODE2]

1.3 Configuring the Network

Vim/etc/hosts
# Public Network-(eth0)
192.168.1.151 Racnode1
192.168.1.152 Racnode2

# Private Interconnect-(ETH1)
192.168.2.151 Racnode1-priv
192.168.2.152 Racnode2-priv

# public Virtual IP (VIP) addresses-(eth0:1)
192.168.1.251 RACNODE1-VIP
192.168.1.252 RACNODE2-VIP

# single Client Access Name (SCAN)
192.168.1.187 Racnode-cluster-scan

1.4 Cluster Time Synchronization Service

If you want to use the cluster time synchronization service to provide synchronization services in the cluster, you need to uninstall the Network Time Protocol (NTP) and its configuration.
To deactivate the NTP service, you must stop the current NTPD service, disable the service from the initialization sequence, and delete the ntp.conf file.
To complete these steps on Oracle Enterprise Linux, run the following command on two Oracle RAC nodes as root:
[[email protected] ~]#/sbin/service ntpd stop
[Email protected] ~]# Chkconfig ntpd off
[Email protected] ~]# mv/etc/ntp.conf/etc/ntp.conf.original
Also delete the following files:
[Email protected] ~]# Rm/var/run/ntpd.pid
This file holds the PID of the NTP daemon.

1.5 Configuring ASM Disks

installation of ORACLEASM3 packages;
Configuring ASM drivers will require the designation of the driver's master user and user group information:
Oracleasm Configure
>grid
>asmdba
>y
>y
Initializing ASM
Oracleasm Init
Creating an ASM Disk
Oracleasm Createdisk VOL1/DEV/SDB1
If you have more than one, continue to create. Execute after completion
Oracleasm Scandisks
View ASM Disks
Oracleasm Listdisks

1.6 Creating grid/oracle Users and Groups

Groupadd Oinstall
Groupadd dba
Groupadd Oper
Groupadd Asmadmin
Groupadd ASMDBA
Groupadd Asmoper
Useradd-g oinstall-g dba,asmdba,asmadmin,asmoper Grid
USERADD-G oinstall-g Dba,oper,asmdba,asmadmin Oracle
Verify that the user nobody exists
Before installing the software, perform the following procedure to verify that a user nobody exists on two Oracle RAC nodes:
To determine whether the user exists, enter the following command:
# ID Nobody
If the command displays information about the nobody user, you do not need to create the user.
If the user nobody does not exist, enter the following command to create it:
#/usr/sbin/useradd Nobody
Repeat this process on all other Oracle RAC nodes in the cluster

Create an Oracle Software installation directory
Mkdir-p/u01/app/grid
Mkdir-p/u01/app/11.2.0/grid
Chown-r grid:oinstall/u01
Mkdir-p/u01/app/oracle
Chown oracle:oinstall/u01/app/oracle
Chmod-r 775/u01

[RACNODE1]
Configure environment variables for a grid user
Export Oracle_base=/u01/app/grid
Export Oracle_home=/u01/app/11.2.0/grid
Export ORACLE_SID=+ASM1
Export Nls_lang=american_america.al32utf8
Export nls_date_format= "Yyyy-mm-dd hh24:mi:ss"
Export Path=.:${path}: $HOME/bin: $ORACLE _home/bin: $ORACLE _home/opatch
Export Path=${path}:/usr/bin:/bin:/usr/bin/x11:/usr/local/bin
Export Path=${path}: $ORACLE _base/common/oracle/bin
Export Oracle_term=xterm
Export Ld_library_path= $ORACLE _home/lib
Export Ld_library_path=${ld_library_path}: $ORACLE _home/oracm/lib
Export Ld_library_path=${ld_library_path}:/lib:/usr/lib:/usr/local/lib
Export Classpath= $ORACLE _home/jre
Export Classpath=${classpath}: $ORACLE _home/jlib
Export Classpath=${classpath}: $ORACLE _home/rdbms/jlib
Export Classpath=${classpath}: $ORACLE _home/network/jlib
Export Threads_flag=native
Export Temp=/tmp
Export Tmpdir=/tmp
Umask 022
Export tmout=0

Configuring environment variables for Oracle users
Export Oracle_base=/u01/app/oracle
Export Oracle_home= $ORACLE _base/product/11.2.0
Export ORACLE_SID=RACDB1
Export Lang=en_us. UTF-8
Export Nls_lang=american_america.al32utf8
Export nls_date_format= "Yyyy-mm-dd hh24:mi:ss"
Export Path=.:${path}: $HOME/bin: $ORACLE _home/bin: $ORACLE _home/opatch
Export Path=${path}:/usr/bin:/bin:/usr/bin/x11:/usr/local/bin
Export Path=${path}: $ORACLE _base/common/oracle/bin:/home/oracle/run
Export Oracle_term=xterm
Export Ld_library_path= $ORACLE _home/lib
Export Ld_library_path=${ld_library_path}: $ORACLE _home/oracm/lib
Export Ld_library_path=${ld_library_path}:/lib:/usr/lib:/usr/local/lib
Export Classpath= $ORACLE _home/jre
Export Classpath=${classpath}: $ORACLE _home/jlib
Export Classpath=${classpath}: $ORACLE _home/rdbms/jlib
Export Classpath=${classpath}: $ORACLE _home/network/jlib
Export Threads_flag=native
Export Temp=/tmp
Export Tmpdir=/tmp
Export Gi_home=/oracle/app/11.2.0/grid
Export Path=${path}: $GI _home/bin
Export ora_nls10= $GI _home/nls/data
Umask 022
Export tmout=0

1.7 Setting resource limits for Oracle software installation users

Configuration/etc/security/limits.conf File: Add the following content
Grid Soft Nproc 2047
Grid hard Nproc 16384
Grid Soft Nofile 1024
Grid hard Nofile 65536
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536
Next, modify the/etc/pam.d/login and add the following at the end of the file:
Session required/lib/security/pam_limits.so
Finally, modify the/etc/profile to add the following at the end of the file
if [$USER = "Oracle"] | | [$USER = "Grid"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
All modifications are completed and all Linux systems are restarted.

1.8 Configuring System Kernel Parameters

Configure/etc/sysctl.conf: Add the following:
FS.AIO-MAX-NR = 1048576
Fs.file-max = 6815744
Kernel.shmall = 2097152
Kernel.shmmax = 4294967296
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_default = 262144
Net.core.rmem_max = 4194304
Net.core.wmem_default = 262144
Net.core.wmem_max = 1048586
Note that in the above parameters, the value of the Kernel.shmmax parameter needs to be modified according to the actual situation and can be set directly to physical memory size.
Execute the order to make it effective:
#/sbin/sysctl-p

1.9 SSH Trust configuration

Configure SSH password-free login between all nodes to ensure inter-node file transfer. Need to configure SSH Trust for grid and Oracle users separately
Log on to the grid user on all nodes and execute the following command:
#所有节点均执行
$RM-RF ~/.ssh
$mkdir ~/.ssh
$chmod ~/.ssh
$/USR/BIN/SSH-KEYGEN-T RSA

#仅节点1执行
$ssh racnode1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
$ssh racnode2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
$SCP ~/.ssh/authorized_keys Racnode2:.ssh/authorized_keys

#仅节点2执行
$chmod ~/.ssh/authorized_keys

Test whether SSH Trust is configured successfully:
#所有节点均执行, the following command needs to enter a password for the first time, but not later, indicating a successful configuration
$ssh Racnode1 Date
$ssh Racnode2 Date

Oracle users do this one time.

1.10 Disabling SELinux

Vim/etc/selinux/config
Selinux=permissive

1.11 Shutting down the iptables firewall

Service Iptables Stop
Chkconfig iptables off

2. Installing the Cluster software

You can use VNC or xmanage software to log in to the Linux interface to install Oracle Grid infrastructure software
After logging into the Linux interface
Before installation, perform pre-installation environmental validation to check whether the requirements are passed:
Only need to be executed on node 1[racnode1]
./runcluvfy.sh Stage-pre Crsinst-n Racnode1,racnode2-verbose
If a check does not pass, please check with each amendment to check again until all the items have passed.
Note
If the SSH port in the environment is not 22, please change it to 22 port first, and then change it back after the installation is complete.

3. Installing Oraclerac

Plot a little!

Oracle RAC Installation Deployment documentation