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

1. Version Notes:

Software version: oracle 11.2.0.4 RAC

System version: Redhat 6.4

This time, the RAC environment of Oracle 11g R2 11.2.0.4 is built, and the operating system version is Oracle Linux 6.4.

Operating system description: when installing the operating system in the early stage, it is recommended to select all the parts on the desktop. Including all gnome,kde desktops and so on. System tools also need to be selected. Otherwise, you may not be able to open the installer, or the package installation may fail due to complex dependencies when installing the gcc package.

Remote tool: X-manager

This time, the RAC environment of Oracle 11g R2 11.2.0.4 is built, and the operating system version is Oracle Linux 6.4. this time, the RAC environment of Oracle 11g R2 11.2.0.4 is built, and the operating system version is Oracle Linux 6.4.

two。 Install the required packages on two machines:

Rpm-Q binutils compat-libstdc++-33 elfutils-libelf

Elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers

Ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat

Required package:

Binutils-2.17.50.0.6-14.el5

Compat-libstdc++-33-3.2.3-61

Elfutils-libelf-0.137-3.el5

Elfutils-libelf-devel-0.137-3.el5

Gcc-4.1.2-51.el5

Gcc-c++-4.1.2-51.el5

Glibc-2.5-65

Glibc-common-2.5-65

Glibc-devel-2.5-65

Glibc-headers-2.5-65

Pdksh.5.2.14 needs to be extracted from Redhat 5

Libgomp-4.4.0-6.el5

Libaio-0.3.106-5

Libaio-devel-0.3.106-5

Libgcc-4.1.2-51.el5

Libstdc++-4.1.2-51.el5

Libstdc++-devel-4.1.2-51.el5

Make-3.81-3.el5

Sysstat-7.0.2-11.el5

UnixODBC-2.2.11

UnixODBC-devel-2.2.11

Install the packages that come with grid:

# check whether it has been installed

# rpm-qi cvuqdisk

# if installed, you need to uninstall the previous version first

# rpm-e cvuqdisk

# install the new version

# CVUQDISK_GRP=oinstall; export CVUQDISK_GRP

# rpm-ivh cvuqdisk-1.0.9-1.rpm

Parsing: without cvudqdisk, the cluster verification utility cannot find the shared disk, and when you run the cluster validator, you will receive the following error message: "Package"

The cvuqdisk not installed ".cvuqdisk RPM is included in the rpm directory on the oracle grid infrastructure installation media. Set the environment variable: CVUQDISK_GRP to point to the group that is the owner of the cvuqdisk (this article is oinstall)

Put all the RPM packages under / mnt/rpm. Although rpm-Uvh * will install all the packages, it will still miss some. Check carefully to make sure all the packages are installed.

1.2 Network card binding: (with the cooperation of the system engineer)

1. You need to completely shut down the NetworlManger service before binding, otherwise it will conflict with the bond Nic.

Chkconfig Networ Manager off # stops booting and starts the service

Service NetworkManager stop # now shut down the service

# cd / etc/sysconfig/network-scripts

# vi ifcfg-bond0

DEVICE=bond0

ONBOOT=yes

BOOTPROTO=staticT

YPE=Ethernet

USERCTL=no

IPADDR=10.80.1.11

NETMASK=255.255.255.0

GATEWAY=10.80.1.254

BONDING_OPTS= "million=100 xmit_hash_policy=1 mode=2"

# vi ifcfg-eth2

DEVICE=eth2

TYPE=Ethernet

ONBOOT=yes

HWADDR=90:E2:BA:83:76:89 # Mac address unchanged

MASTER=bond0

SLAVE=yes

USERCTL=no

BOOTPROTO=none

# vi ifcfg-eth4

DEVICE=eth4

TYPE=Ethernet

ONBOOT=yes

HWADDR=HG:E3:FA:53:26:6A # Mac address unchanged

MASTER=bond0

SLAVE=yes

USERCTL=no

BOOTPROTO=none

# service network restart / / Network restart

# cat / proc/net/bonding/bond0 / / View binding

# ifconfig-a / / check the network card

two。 Network Planning:

Edit / etc/hosts and configure as follows

# # Public IP

10.80.1.1 rac1.com rac1

10.80.1.2 rac2.com rac2

# VIP

10.80.1.3 rac1-vip.com rac1-vip

10.80.1.4 rac2-vip.com rac2-vip

# Private IP

11.11.11.11 rac1-priv.com rac1-priv

11.11.11.12 rac2-priv.com rac2-priv

# scan IP

10.80.1.5 rac-scan.com rac-scan

Planning for 3.ASM disk groups:

2-9 total 8 disks = >

2, 3, 3, 4, each 20 G to do OCRVOTE

5, 5, 6, 7, 8, each, 2T, do DATA.

9 do ARCH for 600g

4. Create users and groups:

Groupadd-g 1000 oinstall

Groupadd-g 1031 dba

Groupadd-g 1032 oper

Groupadd-g 1020 asmadmin

Groupadd-g 1022 asmoper

Groupadd-g 1021 asmdba

Useradd-u 1101-g oinstall-G dba,asmdba,oper oracle

Useradd-u 1100-g oinstall-G asmadmin,asmdba,asmoper,oper,dba grid

# id oracle

# id grid

Mkdir-p / u01/app/11.2.0/grid

Chown-R grid.oinstall / u01/app/11.2.0

Mkdir-p / u01/app/grid

Chown-R grid:oinstall / u01/app/grid

Chown-R grid.oinstall / U01

Mkdir-p / u01/app/oracle

Chown oracle:oinstall / u01/app/oracle

Chmod-R 775 / U01

Set the password for the user:

Passwd oracle

Passwd grid

5. Set the user environment variable:

Grid users:

# cd ~

# vi .profile

ORACLE_BASE=/u01/app/grid

Export ORACLE_BASE

ORACLE_HOME=/u01/app/11.2.0/grid

Export ORACLE_HOME

ORACLE_SID=+ASM1

Export ORACLE_SID

PATH=$PATH:$ORACLE_HOME/bin:$HOME/bin

Export PATH

Note: ORACLE_SID=+ASM2 on the second machine

ORACLE users:

# cd ~

# vi .profile

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

ORACLE_SID=jtptweb1

CRS_HOME=/u01/app/11.2.0/grid

Export ORACLE_HOME

Export ORACLE_BASE

Export ORACLE_SID

PATH=$PATH:$ORACLE_HOME/bin:$CRS_HOME/bin

Export PATH

Note: the second machine ORACLE_SID=jtptweb2

6. Modify limits.conf shell restrictions

[root@rac1 ~] # vi / etc/security/limits.conf

# ORACLE SETTING

Grid soft nproc 2047

Grid hard nproc 16384

Grid soft nofile 1024

Grid hard nofile 65536

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

7. Configure ASM disk groups with multipath+udev

1. Use the multipath-ll command to view the disk and record the wwid

two。 Modify the file multipath.conf file:

Edit the wwid identified in multipath-ll, and correspond to alias, divide the size of the disk according to the purpose and before, for example, 2T each of asm-data01-04, and store the data. Asm-arch 600g storage and archiving, asm-crs01-03 20g each, ocr_vote storage

After writing

Service multipathd restart

Multipath-F clears all paths

Multipath-v2 cleans up paths that are not active

Make sure multipathd boots up automatically:

Chkconfig-list multipathd

If closed, use the command: # / sbin/chkconfig-- level 2345 multipathd on

Do the same thing on the second machine. Note that the alias corresponding to the dm is not necessarily the same as the first one, we observe:

# cd / dev/mapper

The correspondence was found.

Write the rules file of UDEV.

Write 99-oracle-asmdevices.rules under / etc/udev/rules.d

ENV {DM_NAME} = "asm-crs01", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "asm-crs02", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "asm-crs03", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "asm-data01", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "asm-data02", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "asm-data03", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "asm-data04", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

ENV {DM_NAME} = "asm-arch", OWNER:= "grid", GROUP:= "asmadmin", MODE:= "660"

After the completion of the writing

# start_udev

View the results:

# cd / dev/

# ls-al

8. Modify / etc/sysctl.conf file

Kernel.shmall = 67108864

Kernel.shmmax = 177167400960

# kernel.shmmax = physical memory * 0.65 = 165G 165g "1024" 1024" 1024 = 177167400960

# kernel.shmall = 256 "1024" 1024 "1024" 4096 = 67108864

9. Modify / etc/pam.d/login file

Vi / etc/pam.d/login

Session required pam_limits.so

10. Memory adjustment

The default memory usage of Linux is half of the actual memory, which needs to be modified here.

Modify / etc/fstab

Modified to:

# / etc/fstab

# Created by anaconda on Thu Apr 9 15:52:10 2015

#

# Accessible filesystems, by reference, are maintained under'/ dev/disk'

# See man pages fstab (5), findfs (8), mount (8) and/or blkid (8) for more info

#

/ dev/mapper/VolGroup-lv_root / ext4 defaults 1 1

UUID=101d798b-0ac6-42be-a7c7-6b6e5ff61ad5 / boot ext4 defaults 1 2

/ dev/mapper/VolGroup-lv_home / home ext4 defaults 1 2

/ dev/mapper/VolGroup-lv_swap swap swap defaults 0 0

Tmpfs / dev/shm tmpfs defaults,size=165G 0 0

Devpts / dev/pts devpts gid=5,mode=620 0 0

Sysfs / sys sysfs defaults 0 0

Proc / proc proc defaults 0 0

~

# mount-o remount / dev/shm

11. Close ntpd

$service ntpd status

$cd / etc

$mv ntp.conf ntp.conf.bak

Weight / tmp/pgk with root

# chmod-R 777 / tmp/pgk

Extract the third package under the grid user:

Note: it is OK to use unzip. Note that it is very important to use grid users to extract it to ensure that the permissions of things in the package will not be changed. If you decompress it with root and then authorize it, the permissions in it will be changed.

Note: this step also needs to be performed on two nodes, and the grid and three packages need to be decompressed to both nodes at the same time.

Export LANG=en_US.UTF-8

Configure user equivalence: execute with grid user

Sshsetup/sshUserSetup.sh-user grid-hosts "raca1 raca2"

Sshsetup/sshUserSetup.sh-user grid-hosts "znydb01 znydb02"

Done.

Now start to install the data software!

To be continued .

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.