Oracle 12CR2 rac+asm Installation

First, the preparatory work

1. Some changes about Oracle Gird infrastructure

Beginning with Oracle Grid Infrastructure 12c 2nd (12.2), Oracle grid Infrastructure software can be used as an image file for download and installation. This feature greatly simplifies the installation of the Oracle Grid infrastructure.

Note: The grid software must be decompressed to the directory where the grid software is installed, for example:/u01/app/12.2.0/grid, and then run the gridsetup.sh script to start the Oracle Grid infrastructure installation.

1.1. Support Oracle Domain server cluster Oracle member cluster

Oracle Standalone clusters:oracle Standalone cluster

Oracle Cluster domain and Oracle domains Services Cluster:oracle

Oracle Member clusters:oracle member cluster

Oracle Extended clusters:oracle Scalable Cluster

1.2. Global Grid Infrastructure management Knowledge Base-GIMR

Oracle Grid Infrastructure Deployment now supports the global Outlier Grid Infrastructure Management Repository (GIMR). This repository is a multi-tenant database with an pluggable database (PDB) for GIMR for each cluster. The global GIMR runs in the Oracle Domain Services cluster. Global GIMR enables local clusters to be exempt from private storage for this data in their disk groups and allows long-term historical data storage for diagnostic and performance analysis.

2, the hardware requirements

3. RAC Planning

3.1. Shared disk planning

Ocr_vote 2G 3 x

GIMR 40G A

DATA 30G One

Note: After Oracle 12cr2, you need to add a GIMR ASM volume group, at least 38G of space, or stored in a Ocr_vote volume group with a space size of at least 40G

3.2. IP planning

# # #hosts File

Vim/etc/hosts

192.168.2.50 RAC01

192.168.2.51 RAC02

192.168.2.53 Rac01-vip1

192.168.2.54 Rac02-vip1

10.10.10.50 Rac01-pri1

10.10.10.51 Rac02-pri1

192.168.2.55 Rac-scan

192.168.2.56 Rac-scan

192.168.2.57 Rac-scan

# # #创建用户组

GROUPADD-G 501 Oinstall

GROUPADD-G 502 DBA

GROUPADD-G 503 Oper

GROUPADD-G 504 Asmadmin

GROUPADD-G 505 ASMDBA

GROUPADD-G 506 Asmoper

Useradd-u 501-g oinstall-g asmadmin,asmdba,asmoper grid

Useradd-u 502-g oinstall-g Dba,asmdba,oper Oracle

# # #创建文件目录及权限配置

Mkdir-p/u01/app/grid

Mkdir-p/u01/app/12.2.0/grid

Mkdir-p/u01/app/oracle

Mkdir-p/u01/app/oracle/product/12.2.0/db_1

Mkdir-p/u01/app/orainventory

Chown-r Grid:oinstall/u01/app

Chown-r oracle:oinstall/u01/app/oracle

Chmod-r 775/u01/app

# # #配置环境变量

Su-grid

Vim. Bash_profile

Rac01

Export Tmp=/tmp

Export tmpdir= $TMP

Export Oracle_base=/u01/app/grid

Export Oracle_home=/u01/app/12.2.0/grid

Export ORACLE_SID=+ASM1

Export Path=/usr/sbin: $PATH

Export path= $ORACLE _home/bin: $PATH

Export Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib

Export classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib

Rac02

Export Tmp=/tmp

Export tmpdir= $TMP

Export Oracle_base=/u01/app/grid

Export Oracle_home=/u01/app/12.2.0/grid

Export ORACLE_SID=+ASM2

Export Path=/usr/sbin: $PATH

Export path= $ORACLE _home/bin: $PATH

Export Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib

Export classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib

Su-oracle

VI. bash_profile

Rac01

Export Tmp=/tmp

Export tmpdir= $TMP

Export Oracle_base=/u01/app/oracle

Export Oracle_home= $ORACLE _base/product/12.2.0/db_1

Export ORACLE_SID=ORCLDB1

Export Path=/usr/sbin: $PATH

Export path= $ORACLE _home/bin: $PATH

Export Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib

Export classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib

Rac02

Export Tmp=/tmp

Export tmpdir= $TMP

Export Oracle_base=/u01/app/oracle

Export Oracle_home= $ORACLE _base/product/12.2.0/db_1

Export ORACLE_SID=ORCLDB2

Export Path=/usr/sbin: $PATH

Export path= $ORACLE _home/bin: $PATH

Export Ld_library_path= $ORACLE _home/lib:/lib:/usr/lib

Export classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib

# # # #修改操作系统配置

1. Turn off the firewall

2. Disable SELinux

3. Turn off NTP

Delete or modify ntp.conf

4, Configuration/etc/security/limits.conf

Grid Soft Nproc 2047

Grid hard Nproc 16384

Grid Soft Nofile 1024

Grid hard Nofile 65536

Grid Soft Stack 10240

Grid Hard Stack 32768

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

Oracle Soft Stack 10240

Oracle Hard Stack 32768

5, Configuration/etc/sysctl.conf

FS.AIO-MAX-NR = 1048576

Fs.file-max = 6815744

Kernel.shmall = 67108864

Kernel.shmmax = 274877906944

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.ipv4.tcp_rmem = 4096 87380 4194304

Net.ipv4.tcp_wmem = 4096 16384 4194304

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

#net. Ipv4.conf.eth2.rp_filter = 2

#net. Ipv4.conf.eth1.rp_filter = 2

#net. Ipv4.conf.eth0.rp_filter = 1

For the Rp_filter section, if there are not more than one private NIC, no configuration is required, and the document ID1286796.1 has a description.

6, configure the Vim/etc/pam.d/login, add a line below the file

Session Required Pam_limits.so

7. Edit Vi/etc/profile

if [/$USER = "Oracle"] | | [/$USER = "Grid"];then

if [/$SHELL = "/bin/ksh"];then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

umask022

Fi

8. Configuring the Avahi-daemon Server

/etc/init.d/avahi-daemon Stop or service Avahi-daemon stop

Chkconfig Avahi-daemon off

Add the following to/etc/sysconfig/network

Nozeroconf=yes

9. Configure HDD I/oscheduler, modify disk properties

On all cluster node, enter the following command to ensure, the Deadline disk I/O Scheduler is configured for use:

echo Deadline >/sys/block/xvde/queue/scheduler

echo Deadline >/sys/block/xvdf/queue/scheduler

echo Deadline >/sys/block/xvdg/queue/scheduler

echo Deadline >/sys/block/xvdh/queue/scheduler

echo Deadline >/sys/block/xvdi/queue/scheduler

Validating property Results

More/sys/block/xvde/queue/scheduler

10, #disable transparent hugepages close transparenthugepages

Vi/etc/rc.local

If Test-f/sys/kernel/mm/redhat_transparent_hugepage/enabled; Then

echo Never >/sys/kernel/mm/redhat_transparent_hugepage/enabled

Fi

# # #配置互信

In the software catalog of the grid software, build trust with sshusersetup.sh under/u01/app/12.2.0/grid/oui/prov/resources/scripts

The following two commands are executed on a single node (can be executed under root user):

./sshusersetup.sh-user grid-hosts "Rac02 rac01"-advanced-exverify–confirm

./sshusersetup.sh-user oracle-hosts "Rac02 rac01"-advanced-exverify-confirm

# # #ASM磁盘配置

RAC01 node:

fdisk/dev/xvde/f/g/h/i

Partprobe

Oracleasm Init

Oracleasm Configure-i

Grid

Asmadmin

Y

Y

Oracleasm Createdisk Gimr/dev/xvde1 40

Oracleasm Createdisk DATA/DEV/XVDF1 30

Oracleasm Createdisk OCR_VOTE1/DEV/XVDG1

Oracleasm Createdisk OCR_VOTE2/DEV/XVDH1

Oracleasm Createdisk Ocr_vote3/dev/xvdi1

RAC02 node:

Oracleasm Init

Oracleasm Configure-i

Oracleasm Scandisks

Oracleasm Listdisks

# # #安装GRID软件

The boot kernel sequence needs to be modified due to upgrading the kernel

[Email protected] ~]# vim/etc/grub.conf

Default=0 change to the corresponding kernel sequence number

Timeout=5

Note: The installation of the 12CR2 grid is different from the previous version, using the direct decompression mode. It is necessary to copy the installation media to the grid HOME first and then unzip it directly. This directory must be under the grid home to be uncompressed

Upload directly to the/u01/app/12.2.0/grid directory for decompression

About image-based Oracle Grid Infrastructure Installation

Starting with Oracle Grid Infrastructure 12c Release 2 (12.2), installation and configuration of Oracle grid Infrastructur e software is simplified with image-based installation.

1. Full inspection of nodes

Switch to the grid user, unzip the grid software, and execute the following command in the directory

./runcluvfy.sh Stage-pre Crsinst-n Rac01,rac02-verbose

[Email protected] software]$/runcluvfy.sh stage-pre crsinst-n rac01,rac02-verbose

2. # # #安装cvuqdisk

Cvuqdisk stored in the cv/rpm directory of Oracle GI installation media

Export Cvuqdisk_grp=asmadmin

RPM–IVH cvuqdisk-1.0.10-1.rpm

Note: A new redundant type of flex is added: And there is a higher requirement for disk group space

Official documentation explains:

FLEX redundancy is a disk group that allows the database to specify its own redundancy after the disk group is created. The redundancy of the file can also be changed after it is created. This type of disk group supports Oracle ASM file groups and quota groups. A flexible disk group requires at least three fault groups. If an elastic disk group has fewer than five fault groups, it can tolerate the loss of one; Otherwise, it can tolerate the loss of two failure groups. To create an elastic disk group, COMPATIBLE. ASM and Compatible.rdbms Disk group properties must be set to 12.2 or higher.

If the prerequisites check for NTP, memory warnings, there is nothing avahi-deamon the problem. can be ignored.

No upload, edit it later

This article is from "Steven Home" blog, please make sure to keep this source http://shxke.blog.51cto.com/1173559/1958243

Oracle 12CR2 rac+asm Installation