Shulou(Shulou.com)06/01 Report--

I. preparatory work

1. Some changes about Oracle Gird Infrastructure

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

Note: you must extract the GRID software to the directory where you installed the Grid software, 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 independent cluster

Oracle Cluster Domain and Oracle Domain Services Cluster:Oracle domain service clusters

Oracle Member Clusters:Oracle member cluster

Oracle Extended Clusters:Oracle Extensible Cluster

1.2.Global grid infrastructure management knowledge base-GIMR

Oracle Grid Infrastructure deployments now support the global outlier grid infrastructure management repository (GIMR). This repository is a multi-tenant database with a pluggable database (PDB) for the GIMR for each cluster. The global GIMR runs in the Oracle domain service cluster. Global GIMR frees the local cluster from dedicated storage for this data in its disk groups and allows long-term historical data storage for diagnostic and performance analysis.

2. Hardware requirements

3. RAC planning

3.1. Shared disk planning

OCR_VOTE 2G 3

1 GIMR 40G

1 DATA 30g

Note: after Oracle 12CR2, you need to add a GIMR ASM volume group with at least 38 GB of space, or store it in an OCR_VOTE volume group with at least 40 GB of space.

3.2.The 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

# create a user group

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

# create file directory and permissions configuration

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

# configure environment variables

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

# modify operating system configuration

1. Turn off the firewall

2. Disable Selinux

3. Close 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. Configure / 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.eth3.rp_filter = 2

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

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

For the rp_filter section, if there are no multiple private NICs, no configuration is required, as described in the document ID1286796.1.

6. Configure vim / etc/pam.d/login and add a line at the bottom of 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. Configure 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 the hard disk I/Oscheduler and modify the disk properties

On each cluster node, enter the following command to ensure that 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

Validate property results

More / sys/block/xvde/queue/scheduler

10. # disable transparent hugepages turn off 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

# configure mutual trust

In the software directory of the Grid software, use the sshUserSetup.sh under / u01/app/12.2.0/grid/oui/prov/resources/scripts to establish mutual trust

The following two commands can be executed on one node (can be executed under the root user):

. / sshUserSetup.sh-user grid-hosts "rac02 rac01"-advanced-exverify-confirm

. / sshUserSetup.sh-user oracle-hosts "rac02 rac01"-advanced-exverify-confirm

# ASM disk configuration

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/xvdh2

Oracleasm createdisk OCR_VOTE3 / dev/xvdi1

RAC02 node:

Oracleasm init

Oracleasm configure-I

Oracleasm scandisks

Oracleasm listdisks

# install GRID software

Due to kernel upgrade, the boot kernel sequence needs to be modified.

[root@rac02 ~] # vim / etc/grub.conf

Change default=0 to the corresponding kernel sequence number

Timeout=5

Note: the installation of GRID for 12cR2 is different from the previous version and is in direct unzipped mode. So you need to copy the installation media to GRID HOME, and then extract it directly. This directory must be under GRID HOME to be unzipped.

Upload it directly to / 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 Infrastructure software is simplified with p_w_picpath-based installation.

1. Check the nodes comprehensively

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

. / runcluvfy.sh stage-pre crsinst-n rac01,rac02-verbose

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

2. # install cvuqdisk

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

Export CVUQDISK_GRP=asmadmin

Rpm-ivh cvuqdisk-1.0.10-1.rpm

Note: a new redundancy type FLEX has been added: and there are new and higher requirements for disk group space.

The official document explains:

FLEX REDUNDANCY is a disk group that allows a database to specify its own redundancy after creating a disk group. The redundancy of files can also be changed after creation. This type of disk group supports Oracle ASM filegroups and quota groups. Flexible disk groups require at least three failure groups. If the elastic disk group has less than five failure groups, it can tolerate the loss of one; otherwise, it can tolerate the loss of two failure groups. To create an elastic disk group, the COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group properties must be set to 12.2 or higher.

If the premise check shows NTP, memory warnings, and any avahi-deamon problems. Can be ignored.

The screenshot has not been uploaded. Please edit it later.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.