Oracle 12CR2 RAC installation configuration and some pits

Oracle 12CR2 version has been released for some time, and has been trying to test the installation of RAC, from last weekend to today for two weekends and today's time to finally put the RAC installed successfully. This records the configuration of the operating system during installation and some of the pits encountered during installation.

1, the first is the operating system selection problem, Oracle now certified operating system and kernel version as follows:

Oracle Linux 7:

• Oracle Linux 7 with the Unbreakable Enterprise kernel 3:3.8.13-35.3.1.el7uek.x86_64 or later
  

• Oracle Linux 7 with the Red Hat Compatible kernel: 3.10.0-54.0.1.el7.x86_64 or later

Oracle Linux 6：

• Oracle Linux 6.4 with the Unbreakable Enterprise kernel 2: 2.6.39-400.211.1.el6uek.x86_64or later
  

• Oracle Linux 6.4 with the Red Hat Compatible kernel: 2.6.32-358.el6.x86_64 or later
  

Red Hat Enterprise Linux 7：

• Red Hat Enterprise Linux 7: 3.10.0-54.0.1.el7.x86_64 or later
  

Red Hat Enterprise Linux 6：

• Red Hat Enterprise Linux 6.4: 2.6.32-358.el6.x86_64 or later

SUSE Linux Enterprise Server：

• SUSE Linux Enterprise Server 12 SP1: 3.12.49-11.1 or later

The installation was successful today on the rhel6.7 operating system

[[email protected] ~]# uname -a
Linux rhel6 2.6.32-573.el6.x86_64 #1 SMP Wed Jul 1 18:23:37 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux
[[email protected] ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 6.7 (Santiago)

You chose to use rhel6.7 because you previously tried to install on rhel7.2 and OEL7.3, but because there may be a bug or a resource that uses a notebook that is not sufficient to cause the installation to succeed. However, even if you install a single instance of grid on rhel7.2, clsrsc-400:a system reboot is required to continue installing. So I chose the rhel6.7 version.

2, the operating system resource allocation problem

If you are using a server, the resources are sufficient so that you can ignore this article.

If you want to install 12CR2 RAC with a virtual machine on your laptop, be careful, especially if the memory is small (less than 16G).

I use the notebook memory is 12G, each virtual machine 5 G, the other applications are all closed, memory has been supporting around 95%. Another colleague of a 16G memory notebook in the installation grid, multiple times at about 85% when the virtual machine restarts directly, has not been installed successfully.

Today, with a VMware ESXi virtual server configured by a company colleague, the memory is only 16G, but no other virtual machines are running, each VM is allocated 7G of memory, and the memory is more than 90% during the installation process.

3, the operating system configuration

This there is nothing to say, directly according to the requirements of the official documentation step-by-step configuration on the line, the following gives the configuration I do, interested friends can refer to:

#install RPMs

Yum Install-y binutils*

Yum Install-y compat-libcap1*

Yum Install-y compat-libstdc++*

Yum Install-y compat-libstdc++*686*

Yum Install-y e2fsprogs*

Yum Install-y e2fsprogs-libs*

Yum Install-y glibc*686*

Yum Install-y glibc*

Yum Install-y glibc-devel*

Yum Install-y glibc-devel*686*

Yum Install-y ksh*

Yum Install-y libgcc*686*

Yum Install-y libgcc*

Yum Install-y libs*

Yum Install-y libstdc++*

Yum Install-y libstdc++*686*

Yum Install-y libstdc++-devel*

Yum Install-y libstdc++*686*

Yum Install-y libaio*

Yum Install-y libaio*686*

Yum Install-y libaio-devel*

Yum Install-y libaio-devel*686*

Yum Install-y libxtst*

Yum Install-y libxtst*686*

Yum Install-y libx11*686*

Yum Install-y libx11*

Yum Install-y libxau*686*

Yum Install-y libxau*

Yum Install-y libxcb*686*

Yum Install-y libxcb*

Yum Install-y libxi*

Yum Install-y libxi*686*

Yum Install-y make*

Yum Install-y net-tools*

Yum Install-y nfs-utils*

Yum Install-y sysstat*

Yum Install-y smartmontools*

Yum Install-y unixodbc*

Yum Install-y unixodbc-devel*

Yum Install-y unixodbc*686*

Yum Install-y unixodbc-devel*686*

#configure kernel

/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

#configure User Limit

/etc/security/limits.conf

Grid Soft Nofile 1024

Grid hard Nofile 65536

Grid Soft Nproc 2047

Grid hard Nproc 16384

Grid Soft Stack 10240

Grid Hard Stack 32768

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Stack 10240

Oracle Hard Stack 32768

#configure Pam

/etc/pam.d/login

Session Required Pam_limits.so

#configure Network

/etc/hosts

#public

192.168.1.31 Rac1

192.168.1.33 RAC2

#private

192.168.0.11 Rac1-priv

192.168.0.12 Rac2-priv

#virtual

192.168.1.32 RAC1-VIP

192.168.1.34 RAC2-VIP

#scan IP

192.168.1.35 Rac-scan

#configure hostname

/etc/sysconfig/network

Hostname=rac1

#disable Transparent Hugepages

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

#disable Fireware

Service Iptables Stop

Chkconfig--del iptables

#disable SELinux

/etc/selinux/config

Selinux=disabled

#create Users and Groups

Groupadd-g 54421 Oinstall

Groupadd-g 54422 dba

Groupadd-g 54423 Oper

Groupadd-g 54424 BACKUPDBA

Groupadd-g 54425 DGDBA

Groupadd-g 54426 KMDBA

Groupadd-g 54428 Asmoper

Groupadd-g 54427 ASMDBA

Groupadd-g 54429 Asmadmin

Groupadd-g 54430 RACDBA

Useradd-u 54321-g oinstall-g Dba,asmdba,oper,asmadmin,asmdba,backupdba,dgdba,asmoper,kmdba,racdba Oracle

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

passwd Oracle

passwd grid

#configure Directories

Mkdir-p/u01/app/12.2.0/grid

Mkdir-p/u01/app/grid

Mkdir-p/U01/APP/ORACLE/PRODUCT/12.2.0/DB1

Chown-r oracle:oinstall/u01

Chown-r grid:oinstall/u01/app/12.2.0

Chown-r Grid:oinstall/u01/app/grid

Chmod-r 775/u01

#configure Environment variables

Rac1:

Grid

Export ORACLE_SID=+ASM1

Export Oracle_home=/u01/app/12.2.0/grid

Export Oracle_base=/u01/app/grid

Export path= $ORACLE _home/bin: $PATH

Oracle

Export ORACLE_SID=RAC1

Export Oracle_base=/u01/app/oracle

Export Oracle_home= $ORACLE _BASE/PRODUCT/12.2.0/DB1

Export path= $ORACLE _home/bin: $PATH

RAC2:

Grid

Export ORACLE_SID=+ASM2

Export Oracle_home=/u01/app/12.2.0/grid

Export Oracle_base=/u01/app/grid

Export path= $ORACLE _home/bin: $PATH

Oracle

Export ORACLE_SID=RAC2

Export Oracle_base=/u01/app/oracle

Export Oracle_home= $ORACLE _BASE/PRODUCT/12.2.0/DB1

Export path= $ORACLE _home/bin: $PATH

#configure SSH

Ssh-keygen-t DSA

Ssh-keygen-t TSA

SSH Rac1 cat ~/.ssh/id_rsa.pub >> Authorized_keys

SSH rac2 cat ~/.ssh/id_rsa.pub >> Authorized_keys

SSH Rac1 cat ~/.ssh/id_dsa.pub >> Authorized_keys

SSH rac2 cat ~/.ssh/id_dsa.pub >> Authorized_keys

#configure Raw Disks

Raw/dev/raw/raw1/dev/sdb

Raw/dev/raw/raw2/dev/sdc

Raw/dev/raw/raw3/dev/sdd

Raw/dev/raw/raw4/dev/sde

Raw/dev/raw/raw5/dev/sdf

Raw/dev/raw/raw6/dev/sdg

Chown grid:asmadmin/dev/raw/raw*

Here's the configuration disk, introduced the concept of mgmtdb in oracle12c, This is in the 12.1 RAC with OCR in the same disk group, and occupy the space of about a few g, but to 12CR2, MGMT can be in the same disk group with OCR can also use a single disk group, Oracle by default is used alone, but in the 12CR2 in the Mgmtdb occupied space is particularly large, requires the disk The space should be above 38G. So here I allocate space capacity is SDB and SDC do OCR disk, each 2G,SDD and SDE do Mgmt disk, each 20G,SDF and SDG do data disk. If the space is not installed when the error will be reported as:

Here's what you need to be aware of when installing a grid.

The first is where to extract, 12cr2 grid name and previous version of the different, Linuxx64_12201_grid_home.zip, file name with a home, I think this is oracle want to tell everyone this file directly extracted to grid_home under it. It is also true that the files are extracted directly into the specified Grid_home directory, and it does not require the installation to copy the files 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. The problem is the most problematic during the execution of Root.sh, which is the determining factor for the success of RAC installation. The following three types of errors occurred during my testing:

CLSRSC-400:A system reboot is required to continue installing.

Crs-1704:initialization of the required component Gpnp failed; Details at (: CSSSC00005:) in

Crs-2674:start of ' ora.cssd ' on ' Node1 ' failed

Disk groups created successfully. Check/u01/app/grid/cfgtoollogs/asmca/asmca-170325am010920.log for details.

2017/03/25 01:10:23 clsrsc-184:configuration of ASM failed

2017/03/25 01:10:27 clsrsc-258:failed To configure and start ASM

Died at/u01/app/12.2.0/grid/crs/install/crsinstall.pm Line 2091.

Google and MoS have not found the relevant article to solve. But today on the rhel6.7 did not appear above the problem, smooth installation success.

5. Install Oracle software and DBCA CREATE database

There is no big difference between the DBCA and the previous version of the software, the software is also used Runinstaller to adjust the graphical interface installation, the same way as the previous installation on the line.

First wrote here, because today did not think of the test will be installed success, so did not do, but the general process is still the same as the previous version, it is recommended to operate the official documents, you can eliminate unnecessary trouble and mistakes.

Official Document: Http://docs.oracle.com/database/122/CWLIN/toc.htm

Reference: http://blog.csdn.net/ljunjie82/article/details/51577841

This article is from the "DBA fighting!" blog, so be sure to keep this source http://hbxztc.blog.51cto.com/1587495/1910922

Oracle 12CR2 RAC installation configuration and some pits