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

The Oracle 12cR2 version has been released for some time and has been trying to test the installation of RAC. It took two weekends and one day to install RAC from last weekend to today. Here is a record of the configuration of the operating system during installation, as well as some pits encountered during installation.

1. First of all, the choice of operating system. The operating system and kernel versions certified by Oracle are as follows:

Oracle Linux 7:

Oracle Linux 7 with the Unbreakable Enterprise kernel 3 35.3.1.el7uek.x86_64 or later 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.4with the Unbreakable Enterprise kernel 2: 2.6.39-400.211.1.el6uek.x86_64or later

Oracle Linux 6.4with 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.42.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

Today's successful installation is on the rhel6.7 operating system.

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

I chose to use rhel6.7 because I tried to install it on rhel7.2 and OEL7.3 before, but the installation was not successful because of the lack of resources for BUG or the notebook I used. However, even if you install a single instance of grid on rhel7.2, you will get an error CLSRSC-400: A system reboot is required to continue installing. So I chose the rhel6.7 version.

2. Resource allocation of operating system

If you are using a server and have enough resources, you can ignore this one.

Be careful if you want to install 12cR2's RAC from a virtual machine on your laptop, especially if you have less memory (less than 16G).

The notebook memory I use is 12 gigabytes, each virtual machine is divided into 5 gigabytes, all other applications are turned off, and the memory has been around 95%. In addition, when installing grid, a colleague's laptop with 16G memory restarted the virtual machine directly at about 85% for many times, but the installation has not been successful.

Today, we are using a vmware esxi virtual server configured by our colleagues with only 16 gigabytes of memory, but no other virtual machines are running. Each virtual machine has allocated 7 gigabytes of memory, and the memory has been more than 90 percent during the installation process.

3. Configuration of operating system

There is nothing to say about this. Just follow the step-by-step configuration required by the official documentation. Here is my configuration, which can be referenced by interested friends:

# 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 e2fsprogsMurlibs *

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 to talk about the configuration of disks, in Oracle12c introduced the concept of MGMTDB, this in 12.1 RAC is in the same disk group with OCR, and the space occupied is about several G, but in 12cR2, MGMT and OCR can be in the same disk group or a separate disk group can be used, Oracle is used alone by default, but in 12cR2 MGMTDB occupies a particularly large space, requiring disk space of more than 38g. So the space capacity I allocate here is the disk for sdb and sdc to do OCR, each 2G for MGMT and sde for MGMT, and each 20G for DATA for SDF and sdg. If the space will not be installed, the error shown below will be reported:

4. Install grid

Here are some things to pay attention to when installing grid.

The first is where to extract, 12cR2 grid name is different from previous versions, linuxx64_12201_grid_home.zip, the file name with a home, I think this is Oracle wants to tell you that this file is extracted directly to the GRID_HOME bar. Indeed, extract the files directly to the specified GRID_HOME directory, it does not need to install the files copy to the GRID_HOME directory. Remember to remove the package from GRID_HOME after decompression, so as not to transfer the package to other nodes during the installation of grid.

As for the installation, after unzipping it, you can see that there is not a grid directory, runInstaller scripts and other files in the grid directory. This decompression is like a direct installation, unzipping a lot of files. And there is no runInstaller script in the directory. Instead, the gridSetup.sh script is run to perform the installation of grid.

The various choices in the graphical interface after that are not much different from the previous version. Execute the root.sh script after installation. There are the most problems in the execution of root.sh, which is the decisive factor in the successful installation of RAC. In the course of my test, there are three kinds of errors:

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.

Checked GOOGLE and MOS did not find the relevant articles to solve. However, the above problem did not appear on rhel6.7 today, and the installation was successful.

5. Install oracle software and dbca to create database

Security software and dbca library is not much different from the previous version, the software is still using runInstaller to adjust the graphical interface installation, reference to the previous way of installation on the line.

That's all for now. Because I didn't expect the installation to be successful when I was doing the test today, I didn't take a screenshot, but the general process is still more or less the same in previous versions. It is also recommended to operate against official documents to avoid unnecessary troubles and errors.

Official document: http://docs.oracle.com/database/122/CWLIN/toc.htm

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

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.