Oracle Study-aix6.1 Building Oracle 11gR2 RAC (1)

Oracle Study-aix6.1 Building Oracle 11gR2 RAC (1)

Environment:

Operating System: AIX 6100-09 (SP3)

cluster:hacmp6.1

Cluster Software: GI 11.2.0.1

Database: Oracle 11.2.0.1

There are two ways in which RAC can be used to build an AIX platform based on shared storage:

1. Establish shared storage based on concurrent volume group (VG concurrent)

2. Build shared storage based on ASM Raw

Since the system array (SUN T300) does not support concurrent storage and does not have Reserve_policy or Reserve_lock properties, when using ASM for concurrent storage, one of the nodes will lock the disk after accessing the disk, and the other node will no longer be able to access the shared disk Therefore, this environment is realized by hacmp the sharing of the concurrent volume group, and then the ASM Diskgoup is established through the logical volume. This makes the whole system more hacmp, increasing the complexity of management.

System Architecture:

650) this.width=650; "Src=" http://img.blog.csdn.net/20160405180917663?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

This system architecture is: AIX 6100-09 (SP3) +hacmp6.1+asm+oracle GI + Oracle 11gR2

First, the system environment

[[email protected]/] #oslevel-S
6100-09-03-1415

[[email protected]/] #prtconf |more

system model: ibm,7028-6c4machine serial number: 1096b0dprocessor type:  Powerpc_power4processor implementation mode: power 4processor version: pv_4_ 2number of processors: 2processor clock speed: 1453 mhzcpu type:  64-bitkernel type: 64-bitlpar info: 1 nullmemory size: 4096 mbgood  memory size: 4096 mbplatform firmware level: 3r041029firmware version : ibm,rg041029_d79e00_rconsole login: enableauto restart: truefull core:  falsenx crypto acceleration: not capablenetwork information         Host Name: aix209        IP  address: 192.168.8.209        sub netmask:  255.255.255.0        gateway:         name server:          domain name:

page Swap space : (Oracle 11g requires a minimum of 3G of page swap space)

[[email protected]/] #lsps-A
Page Space physical Volume Volume Group Size%used Active Auto Type chksum
paging00 hdisk0 ROOTVG 2048MB 0 Yes Yes LV 0
Hd6 hdisk0 ROOTVG 2048MB 0 Yes Yes LV 0

[[email protected]/] #lsps-S
Total Paging Space Percent used
4096MB 0%

Packages that need to be installed :

[[email protected] soft] #lslpp-L |grep-i xlc

XlC.aix61.rte 12.1.0.1 COMMITTED IBM XL C + + Runtime for AIX 6.1 xlC.cpp 9.0.0.0 Committ          ED C for AIX preprocessor xlc.rte 12.1.0.1 COMMITTED IBM XL C + + Runtime for AIX xlC.sup.aix50.rte 9.0.0.1 COMMITTED XL/C + + Runtime for AIX 5.2

[[email protected] soft] #lslpp-L |grep-i bos.perf

  bos.perf.diag_tool        6.1.8.15  committed   Performance Diagnostic Tool   bos.perf.fdpr              6.1.8.15  COMMITTED  Feedback  directed program  bos.perf.libperfstat      6.1.9.15   committed  performance statistics library  bos.perf.perfstat          6.1.9.15  COMMITTED  Performance Statistics   bos.perf.pmaix            6.1.9.15   COMMITTED  Performance Management  bos.perf.proctools         6.1.9.15  COMMITTED  Proc Filesystem Tools   bos.perf.tools            6.1.9.15  committed  base  performance tools  bos.perf.tune              6.1.9.15  COMMITTED  Performance Tuning Support   bos.perf.diag_tool        6.1.8.15  committed   performance diagnostic tool   bos.perf.libperfstat       6.1.9.15  COMMITTED  Performance Statistics Library   bos.perf.perfstat          6.1.9.0  committed   Performance Statistics  bos.perf.pmaix             6.1.9.15  COMMITTED  Performance Management   Bos.perf.tools            6.1.9.15  committed  base performance  tools  bos.perf.tune              6.1.9.15  committed  performance tuning support

Network environment:

[[email protected]/] #ifconfig-A

En2:flags=5e084863,c0<up,broadcast,notrailers,running,simplex,multicast,grouprt,64bit,checksum_offload ( ACTIVE),pseg,largesend,chain> inet 192.168.8.209 netmask 0xffffff00 broadcast 192.168.8.255en0:flags=5e084863,c 0<up,broadcast,notrailers,running,simplex,multicast,grouprt,64bit,checksum_offload (ACTIVE), PSEG,LARGESEND, Chain> inet 10.10.10.209 netmask 0xffffff00 broadcast 10.10.10.255

[[email protected]/] #ifconfig-A

En2:flags=5e084863,c0<up,broadcast,notrailers,running,simplex,multicast,grouprt,64bit,checksum_offload ( ACTIVE),pseg,largesend,chain> inet 192.168.8.210 netmask 0xffffff00 broadcast 192.168.8.255en0:flags=5e084863,c 0<up,broadcast,notrailers,running,simplex,multicast,grouprt,64bit,checksum_offload (ACTIVE), PSEG,LARGESEND, Chain> inet 10.10.10.210 netmask 0xffffff00 broadcast 10.10.10.255

[[email protected] tmp] #cat/etc/hosts

192.168.8.209 aix209192.168.8.251 aix209-vip10.10.10.209 aix209-priv192.168.8.210 aix210192.168.8.252 aix210-vip10 .10.10.210 aix210-priv192.168.8.253 Rac_scan

--------This build does not use DNS Server, the Hosts file resolves the scan IP.

Second, create the configuration user

[[email protected]/] #cat mkuser.sh

Mkgroup-' A ' id= ' adms= ' root ' oinstall mkgroup-' a ' id= ' 1020 ' adms= ' root ' asmadmin mkgroup-' a ' id= ' 1021 ' adms= ' root ' ASMDBA Mkgroup-' a ' id= ' 1022 ' adms= ' root ' asmoper mkgroup-' a ' id= ' 1031 ' adms= ' root ' dba mkgroup-' a ' id= ' 1032 ' adms= ' roo T ' oper mkuser id= ' 1001 ' pgrp= "Oinstall ' groups= ' dba,asmdba,asmadmin,oper ' home= '/home/oracle ' Oracle mkuser id= ' 1002 ' pgrp= ' Oinstall ' groups= ' asmadmin,asmdba,asmoper,oper,dba ' home= '/home/grid ' grid

Configure users: (Assign permissions, resource configuration)

[Email protected]/]#/usr/bin/chuser capabilities=cap_numa_attach,cap_bypass_rac_vmm,cap_propagate Grid[[email Protected]/]#/usr/bin/chuser Capabilities=cap_numa_attach,cap_bypass_rac_vmm,cap_propagate Oracle

[[email protected]/] #cat/etc/security/limits

oracle:        fsize = -1         data = -1        stack = -1         core = -1         rss = -1        nofiles = -1         threads = -1         nproc = -1grid:        fsize = -1         data = -1        stack  = -1        core = -1         rss = -1        nofiles =  -1      &nBsp; threads = -1        nproc = -1 

Configure User profile:

Grid users:

[[Email protected] ~] $cat. Profileexport editor=viexport oracle_sid=+asm2export Oracle_base=/u01/app/oracleexport Oracle_home=/u01/gridexport grid_home=/u01/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 Users:

[[Email protected] ~] $cat. profileoracle_base=/u01/app/oracleoracle_home= $ORACLE _base/product/11.2.0/db_1oracle_ Sid=prod2path= $PATH: $ORACLE _home/binexport oracle_base oracle_home oracle_sid PATH

Iii. creating file Systems and directories

[[email protected]/] #cat mkdir.sh

Mkdir-p/u01/app/oracle mkdir-p/u01/grid mkdir-p/u01/app/orainventory chown-r Oracle:oinstall/u01/app/oraclechown- R grid:oinstall/u01/grid chown-r grid:oinstall/u01/app/orainventory chmod-r 775/u01/

-----not finished, to be continued ...

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1760597

Oracle Study-aix6.1 Building Oracle 11gR2 RAC (1)