Oracle 12c RAC Setup

Source: Internet
Author: User
Tags chmod file copy mkdir iptables

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

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.