Oracle 12c RAC Setup

1.1 Hardware Requirements

? The server has the same architecture (such as 64bit and 32bit cannot be the same cluster)

? Non-cluster environments require higher physical memory than the 2g,cluster environment requires more than 3G of physical memory

1.2 Operating system Requirements

? Operating system version to maintain at least the same as the source side or higher version, the operating system patches and source-side consistent

? Database version 11.2.0.3.0, requires AIX6.1 TL04 above, 7.1

? Database version 11.2.0.4.0, requires AIX6.1 TL04 above, 7.1, 7.2

? Linux OS version best RHEL 6.7 +

? Server operating system running in 3 or 5 mode (LINUX)

? Swap partition as a multiple of physical memory (1-2g swap=1.5ram;2-16g swap=ram;>16g swap=16g)

? TMP>1G, disk space >10g

1.3 Database Software Preparation

2 Pre-Installation Preparation

2.1 Linux

2.1.1 Checking the operating system environment

Check the operating system architecture

uname -A

Check operating system vendor and version

Cat /etc/issue

Check disk space (install the Oracle software mount point and/tmp)

DF -H

2.1.2. Check System software Suite

Rpm-q--QF'%{name}-%{version}-%{release} (%{arch}) \ n'binutils Compat-libstdc++- -Compat-libstdc++-296elfutils-libelf elfutils-libelf-develGCC GCC-c++glibc glibc-Common glibc-devel glibc-headers Libaio Libaio-devel LIBGCC libstdc++LIBSTDC++-devel Makesysstat UnixODBC UnixODBC-devel

Yum Install binutils.x86_64 compat-libcap1.x86_64 compat-libstdc++-. x86_64 compat-libstdc++-33  gccgcc make sysstat.x86_64 unixodbc.x86_64 unixodbc.i686 unixodbc-devel.x86_64 unixodbc-devel.i68

2.1.3. Shutting down unnecessary services

 service iptables stopservice NetworkManager stopservice bmc -watchdog stopservice autofs stopservice acpid stopservice sendmail stopservice cups -config-daemon stopservice xfs stopservice gpm stopservice openibd stopservice iiim StopService PCMCIA Stop Service Cpuspeed stopservice nfslock stopservice iptables stopservice ip6tables stopservice rpcidmapd stopservice apmd sto Pservice sendmail stopservice arptables_jf stopservice rpcgssd stopservice ip6tables stop  

CHKCONIFG microcode_ctl stopchkconfig NetworkManager offchkconfig BMC-watchdog Offchkconfig AutoFS Offchkconfig acpid offchkconfig sendmail offchkconfig cups-config-daemon offchkconfig xfs offchkconfig gpm Offchkconfig openibd offchkconfig iiim offchkconfig PCMCIA offchkconfig cpuspeed offchkconfig nfslock offchkconfig iptabl Es offchkconfig ip6tables offchkconfig rpcidmapd offchkconfig apmd offchkconfig sendmail offchkconfig arptables_jf offchk Config microcode_ctl offchkconfig rpcgssd off

2.1.4. Disabling SELinux

vi /etc/selinux/configselinux=disabled

2.1.5. Adjusting system parameters

Tuning Kernel Parameters

VI /etc/sysctl.conf

Kernel.shmall =536870912Kernel.shmmax=536870912Kernel.shmmni=4096Kernel.sem= - 32000  -  -Fs.aio-MAX-NR =1048576FS.file-max =6815744Net.ipv4.ip_local_port_range=9000 65500Net.core.rmem_default=262144Net.core.rmem_max=4194304Net.core.wmem_default=262144Net.core.wmem_max=1048586

#使修改生效

/sbin/sysctl-p

#确认修改成功

/sbin/sysctl-a

Adjust Shell resource Limits

VI /etc/security/limits.conf

*       Soft    nproc   2047*       hard    nproc   16384*       soft    nofile   1024x768*       hard    nofile  65536*       soft    stack   10240  3145728  3145728

2.1.6. modifying hostname

vi /etc/sysconfig/networkhostname=
2.1.7. Configuring the Hosts
/etc/hosts Example
#public-IP10.10.115.45ora12c110.10.115.46ora12c2#virtual-IP10.10.115.50Ora12c1-VIP10.10.115.51ora12c2-vip#private-IP192.168.1.8Ora12c1-Priv192.168.1.8ora12c2-Priv#scan-IP10.10.115.52Ora12c1-scan
2.1.8. Creating Users and Groups
Log in with the root user
Create a group
   1100 1300 1400  Oper
Create Grids and Oracle users
1101 G Oinstall-g dba,oper,asmdba Oracleecho Oracle passwd ---1301 -G oinstall-g dba,asmadmin,asmdba,asmoper gridecho"  grid"passwd --stdin grid
2.1.9. Creating the installation directory
mkdir -p/u01/app/gridmkdir -p/u01/app/12.2. 0.1/gridmkdir -p/u01/app/Oraclemkdir -p/u01/app/oracle/product/  12.2. 0.1/db_1chown -R grid:oinstall/u01chown oracle:oinstall/ u01/app/Oraclechmod775 /u01
2.1.10. Setting User Environment variables
User Oracle
oracle_sid=<sid>1oracle_base=/u01/app/oracleoracle_home= $ORACLE _base/product/ 12.2. 0.1/db_1grid_home=/u01/app/12.2. 0.1/Gridld_library_path= $ORACLE _home/lib:/usr/LibPATH= $PATH: $ORACLE _home/bin: $GRID _ home/bin:/sbin:/usr/sbin:/bin:/usr/local/Binnls_lang=022
User Grid
oracle_base=/u01/app/gridoracle_home=/u01/app/12.2. 0.1/gridoracle_sid=+asm<n>PATH= $PATH: $ORACLE _home/bin:/usr/local/  022
2.1.11. Configuration equivalence
Using grids and Oracle user execution on all cluster servers
mkdir ~/. SSH chmod  ~/. SSH Ssh-keygen -t RSASsh-keygen -T DSA
Using grids and Oracle users on a single server
Cat~/.SSH/id_rsa.pub >> ~/.SSH/Authorized_keysCat~/.SSH/id_dsa.pub >> ~/.SSH/Authorized_keysSSHOra12c2Cat~/.SSH/id_rsa.pub >> ~/.SSH/Authorized_keysSSHOra12c2Cat~/.SSH/id_dsa.pub >> ~/.SSH/Authorized_keysSCP~/.SSH/authorized_keys ora12c2:~/.SSH/authorized_keys
Using grids and Oracle user execution on all cluster servers
SSH Date SSH Date SSH Date SSH Date
2.1.12. Configuring shared storage
Suppose/dev/sd[c-e] is a shared disk
Bare Device mode configuration shared storage
Modify/etc/udev/rules.d/60-raw.rules Add Content
Use the following script to add the permission information after execution is complete.
 num=1  for  I in   J K l m N;  do  echo   " action==\ "add\", kernel==\ "sddlma$i\", run+=\ "/bin/raw/dev/raw/raw$num%n\"  Span style= "COLOR: #800000" > " >>/etc/udev/rules.d/60 -raw.rules;let num  ++;  done ; 
kernel=="raw*", action=="add", owner="grid  ", group="asmadmin", mode="0660 "
Refresh Disk Group Start_udev
Start_udev
2.1.13. Configuring NTP to keep two-machine time synchronization
3. Installing the grid
The first is where to extract, directly unzip the file into the specified grid_home directory, it does not need to install the file copy to the Grid_home directory. After unpacking, remember to remove the unpacking package from the Grid_home, lest you also upload the package to other nodes during the installation of the grid.
Again, the installation, after the decompression can see this is not as before there is a grid directory, grid directory Runinstaller scripts and other files. This decompression is like a direct installation of the same, extracted a lot of files. And there is no Runinstaller script in the directory, instead of the gridsetup.sh script, run the script to perform the installation of the grid.
After that the various options in the graphical interface are not much different from the previous version. Executes the root.sh script after the installation is complete.
3.1. Run the installation script
$Grid _home/gridsetup. SH
3.2. Select Configure Grid Infrastructure for a New Cluster and click Next
3.3. Select Configure an Oracle Standalone Cluster, then click Next
3.4.scan-name to be the same as Scan-ip in/etc/hosts, cancel the GNS and click Next
3.5. Choose Add node, fill in Public-ip and virtual-ip hostname, then select all nodes, click SSH connectivity, enter the grid password, click Reuse Private and public keys Existing in user home, click Setup, and then click Next
3.6. Check that the IP and type are correct, then click Next
3.7. Select the block device and click Next
3.8. Select Yes, then click Next
3.9.DISK name fill in OCR and create an OCR disk group, select Redundancy High, change the bare device path/dev/raw/raw*
3.10.GIMR cluster basic information management database Create MGMT Disk group, select Redundancy External, click Next
3.11. Select the same ASM sys and ASMSNMP user password, then click Next
3.12. Select not to use Intelligent Platform Management Interface (IPMI), click Next
3.13. Because no register with Enterprise Manager (EM) Cloud Control is installed, click Next directly
3.14. The following are the default options, all click Next, (For resolv.conf and DNS options can be ignored)
3.15. Two node execution root script
3.16. Installation Complete
Oracle 12c RAC Setup