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

Oracle Study-AIX6.1 to build 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 to build RAC under AIX platform according to the use of shared storage:

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

2. Establish shared storage based on RAW under ASM.

Because the system array (SUN T300) does not support concurrent storage and does not have reserve_policy or reserve_lock attributes, when using ASM for concurrent storage, one node will lock the disk after accessing the disk, while the other node can no longer access the shared disk; so this environment is to realize the sharing of concurrent volume groups through HACMP, and then establish ASM DISKGOUP through logical volumes. In this way, there is more hacmp in the whole system, which increases the complexity of management.

System architecture:

The system architecture is: AIX 6100-09 (SP3) + HACMP6.1+ASM+Oracle GI + Oracle 11gR2

I. system environment

[root@aix209 /] # oslevel-s

6100-09-03-1415

[root@aix209 /] # prtconf | more

System Model: IBM,7028-6C4Machine Serial Number: 1096B0DProcessor Type: PowerPC_POWER4Processor Implementation Mode: POWER4Processor 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 at least 3G page swap space)

[root@aix210 /] # 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

[root@aix210 /] # lsps-s

Total Paging Space Percent Used

4096MB 0%

Packages that need to be installed:

[root@aix210 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 COMMITTED 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 Come accounts + Runtime for AIX 5.2

[root@aix210 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:

[root@aix209 /] # ifconfig-a

En2: flags=5e084863,c0 inet 192.168.8.209 netmask 0xffffff00 broadcast 192.168.8.255en0: flags=5e084863,c0 inet 10.10.10.209 netmask 0xffffff00 broadcast 10.10.10.255

[root@aix210 /] # ifconfig-a

En2: flags=5e084863,c0 inet 192.168.8.210 netmask 0xffffff00 broadcast 192.168.8.255en0: flags=5e084863,c0 inet 10.10.10.210 netmask 0xffffff00 broadcast 10.10.10.255

[root@aix209 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

-DNS Server is not used in this build, so parse scan ip in the hosts file.

Second, create a configuration user

[root@aix209 /] # cat mkuser.sh

Mkgroup -'A 'id='1000' 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='root' 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)

[root@aix210 /] # / usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid [root@aix210 /] # / usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

[root@aix209 /] # 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 threads =-1 nproc =-1

Configure user profile:

Grid users:

[grid@aix210 ~] $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:

[oracle@aix210 ~] $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

Create file systems and directories

[root@aix209 /] # 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.

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.