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

I. installation instructions

1. Environmental description

System version database version schema IP address patch rhel6.911.2.0.4RAC192.168.3.229698727rhel6.911.2.0.4RAC192.168.3.329698727

2. The location of the software is planned as follows:

Software storage location Grid/u01/11.2.0/gridOracle/u01/app/oracle/product/11.2.0/db_1

3. RAC database needs shared storage:

The CRSDG:3 block is a disk at least above 3GB, which is used to store the spfile of ocr and voting disk,asm.

DATADG: at least 200GB, used to store redolog, control files, database spfile, database system table space, undo table space, temp table space. According to the actual business requirements, increase the capacity of DATADG.

ARCHDG: at least 100GB, users store archive logs. According to the actual business requirements, increase the capacity of DATADG.

Diskgroup size CRSDG3 block 1GB storage DATADG > = 100GBARCHDG > = 100GB

Second, installation steps

1. Dependent package

Cpp-4.8.2-16.el7.x86_64glibc-headers-2.17-55.el7.x86_64mpfr-3.1.1-4.el7.x86_64compat-libstdc++-33-3.2.3binutils-2.23.52.0.1-12.el7.x86_64compat-libcap1-1.10-3.el7.x86_64gcc-4.8.2-3.el7.x86_64gcc-c++-4.8.2-3.el7.x86-64glibcly2.17- 36.el7.i686glibc-2.17-36.el7.x86_64glibc-devel-2.17-36.el7.i686glibc-devel-2.17-36.el7.x86_64kshlibaio-0.3.109-9.el7.i686libaio-0.3.109-9.el7.x86_64libaio-devel-0.3.109-9.el7.i686libaio-devel-0.3.109-9.el7.x86_64libgcc-4.8.2-3.el7.i686libgcc-4.8.2-3. El7.x86_64libstdc++-4.8.2-3.el7.i686libstdc++-4.8.2-3.el7.x86_64libstdc++-devel-4.8.2-3.el7.i686libstdc++-devel-4.8.2-3.el7.x86_64libXi-1.7.2-1.el7.i686libXi-1.7.2-1.el7.x86_64libXtst-1.2.2-1.el7.i686libXtst-1.2.2-1.el7.x86_64make-3.82-19. El7.x86_64sysstat-10.1.5-1.el7.x86_64

2. System parameters

Please refer to the system kernel parameter MOS Doc ID: 169706.1

Vi / etc/sysctl.conf:fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 10485760kernel.shmmax = 34359738368kernel.shmmni = 4096kernel.sem = 25032000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586

3. Set the shell limit for oracle users:

/ etc/security/limits.conforacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536oracle soft stack 10240oracle hard stack 32768

4. / etc/pam.d/login add:

Session required pam_limits.so/etc/profile add: if [$USER = "oracle"]; then if [$SHELL = "/ bin/ksh"]; then ulimit-u 16384 ulimit-n 65536 else ulimit-u 16384-n 65536 fifi

5 、 hosts

Vi / etc/hosts192.168.3.2 tim110.10.10.1 tim1-priv192.168.3.88 tim1-vip192.168.3.3 tim210.10.10.2 tim1-priv192.168.3.99 tim2-vip192.168.3.111 rac-scan

6. Users and groups

Groupadd-g 200 oinstallgroupadd-g 201 dbagroupadd-g 202 opergroupadd-g 203 asmadmingroupadd-g 204 asmopergroupadd-g 205 asmdbauseradd-u 200-g oinstall-G dba,asmdba,oper oracleuseradd-u 201-g oinstall-G asmadmin,asmdba,asmoper,oper,dba grid

7. Catalogue

Mkdir-p / u01/app/oraInventorychown-R grid:oinstall / u01/appchmod-R 775 / u01/app/oraInventory/mkdir-p / u01/11.2.0/gridchown-R grid:oinstall / u01/11.2.0chmod-R 775 / u01/11.2.0mkdir-p / u01/app/oraclemkdir-p / u01/app/oracle/cfgtoollogsmkdir-p / u01/app/oracle/product/11.2.0/db_1chown-R oracle:oinstall / u01/app/oraclechmod-R 775 / u01/app/oracle

8. Environmental variables

# Note the following environment variable parameter is Node1, which is different from Node2 in Oracle_sid.

Grid user

Export EDITOR=viexport ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/11.2.0/gridexport GRID_HOME=/u01/11.2.0/gridexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport THREADS_FLAG=nativeexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022

Oracle user

Export EDITOR=viexport ORACLE_SID=prod1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022

8 、 udev

# all node1,node2 needs to be configured

[root@tim1] # vi / etc/udev/rules.d/60-raw.rules is written in example as follows: ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "33", RUN+= "/ bin/raw / dev/raw/raw1% M%" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "34", RUN+= "/ bin/raw / dev/raw/raw2% M" ACTION== "add", ENV {MAJOR} = = "8" ENV {MINOR} = = "35", RUN+= "/ bin/raw / dev/raw/raw3% M" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "36", RUN+= "/ bin/raw / dev/raw/raw4% M" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "37", RUN+= "/ bin/raw / dev/raw/raw5% M% m" ACTION== "add", ENV {MAJOR} = "8", ENV {MINOR} = "38" RUN+= "/ bin/raw / dev/raw/raw6% M" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "39", RUN+= "/ bin/raw / dev/raw/raw7% M" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "40", RUN+= "/ bin/raw / dev/raw/raw8% M% m" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = "41" RUN+= "/ bin/raw / dev/raw/raw9% M" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "42", RUN+= "/ bin/raw / dev/raw/raw10% M" ACTION== "add", ENV {MAJOR} = = "8", ENV {MINOR} = = "43", RUN+= "/ bin/raw / dev/raw/raw11% M" KERNEL== "raw [1-9]", OWNER= "grid", GROUP= "dba", MODE= "660" KERNEL== "raw10", OWNER= "grid" GROUP= "dba", MODE= "660" KERNEL== "raw11", OWNER= "grid", GROUP= "dba", MODE= "660" [root@node1] # start_ udevs [root @ node2 ~] # ll / dev/raw/raw*crw-rw---- 1 grid dba 162,1 Apr 17 21:10 / dev/raw/raw1crw-rw---- 1 grid dba 162,10 Apr 17 21:10 / dev/raw/raw10crw-rw---- 1 grid dba 162 11 Apr 17 21:10 / dev/raw/raw11crw-rw---- 1 grid dba 162, 2 Apr 17 21:10 / dev/raw/raw2crw-rw---- 1 grid dba 162, 3 Apr 17 21:10 / dev/raw/raw3crw-rw---- 1 grid dba 162, 4 Apr 17 21:10 / dev/raw/raw4crw-rw---- 1 grid dba 162, 5 Apr 17 21:10 / dev/raw/raw5crw-rw---- 1 grid dba 162 6 Apr 17 21:10 / dev/raw/raw6crw-rw---- 1 grid dba 162, 7 Apr 17 21:10 / dev/raw/raw7crw-rw---- 1 grid dba 162, 8 Apr 17 21:10 / dev/raw/raw8crw-rw---- 1 grid dba 162, 9 Apr 17 21:10 / dev/raw/raw9

9. Start the graphics

10. Install grid

Grid only recognizes the Node1 node, and Node2 needs to be added manually.

11. Install oracle

Simplified Chinese can be added.

This is copying data to node2, which can be found under $ORACLE_HOME of node2.

Check progress via du-sh

This is the end of the installation! Maybe some people who have just learned about oracle will report an error according to this step, because I have not configured two nodes grid and oracle users to trust each other. In fact, they can operate it graphically. Try to find it!

12. Check

View cluster resources [grid@tim1 ~] $crsctl status res-t check ASM status [grid@tim1 ~] $asmcmd-p check ocr status [grid@tim1 ~] $ocrcheck check voting disk status [grid@tim1 ~] $crsctl query css votedisk check node information [grid@tim1 ~] $srvctl config nodeapps check database information [grid@tim1 ~] $srvctl config database -d prod check interface status [grid@tim1 ~] $oifcfg iflist-p-n [grid@tim1 ~] $oifcfg getif-global check listening status [grid@tim1 ~] $lsnrctl status

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.