Oracle Study之-AIX6.1构建Oracle 11gR2 RAC(1)

心已赠人 2022-07-26 00:29 175阅读 0赞

**Oracle Study之-AIX6.1构建Oracle 11gR2 RAC(1)**

环境：

操作系统： AIX 6100-09（SP3)

Cluster：HACMP6.1

集群软件： GI 11.2.0.1

数据库：   Oracle 11.2.0.1

**构建AIX平台下RAC 依据共享存储的使用方式可以分两种：**

**1、建立基于并发卷组（VG concurrent）的共享存储**

**2、建立基于ASM下的RAW的共享存储**

**        由于本系统阵列（SUN T300）不支持并发存储，不具有reserve\_policy或reserve\_lock属性；所以在使用ASM做并发存储时，其中一个节点访问磁盘后会锁定磁盘，而另外的节点就不能再访问共享盘；所以本次环境是通过HACMP实现并发卷组的共享，然后再通过逻辑卷建立ASM DISKGOUP. 这样整个系统多了hacmp，增加了管理的复杂性。**

系统架构：

**![Center][]**

**本次系统架构为：AIX 6100-09(SP3)+HACMP6.1+ASM+Oracle GI + Oracle 11gR2**

**一、系统环境**

**\[root@aix209 /\]\#oslevel -s**  
6100-09-03-1415

**\[root@aix209 /\]\#prtconf |more**

System Model: IBM,7028-6C4
    Machine Serial Number: 1096B0D
    Processor Type: PowerPC_POWER4
    Processor Implementation Mode: POWER 4
    Processor Version: PV_4_2
    Number Of Processors: 2
    Processor Clock Speed: 1453 MHz
    CPU Type: 64-bit
    Kernel Type: 64-bit
    LPAR Info: 1 NULL
    Memory Size: 4096 MB
    Good Memory Size: 4096 MB
    Platform Firmware level: 3R041029
    Firmware Version: IBM,RG041029_d79e00_r
    Console Login: enable
    Auto Restart: true
    Full Core: false
    NX Crypto Acceleration: Not Capable
    Network Information
            Host Name: aix209
            IP Address: 192.168.8.209
            Sub Netmask: 255.255.255.0
            Gateway: 
            Name Server: 
            Domain Name:

**页面交换空间**：（Oracle 11g需要页面交换空间最少3G）

**\[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%

**需要安装的软件包：**

**\[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 C/C++ 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

**网络环境：**

**\[root@aix209 /\]\#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.255
    en0: flags=5e084863,c0<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

**\[root@aix210 /\]\#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.255
    en0: flags=5e084863,c0<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

**\[root@aix209 tmp\]\#cat /etc/hosts**

192.168.8.209  aix209
    192.168.8.251  aix209-vip
    10.10.10.209   aix209-priv
    192.168.8.210   aix210
    192.168.8.252   aix210-vip
    10.10.10.210    aix210-priv
    192.168.8.253   rac_scan

\-------- 本次构建不使用DNS Server，所以在hosts文件解析scan ip。

**二、创建配置用户**

**\[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

**配置用户：（分配权限、资源配置）**

<strong>[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</strong>

**\[root@aix209 /\]\#cat /etc/security/limits**

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

**配置用户profile：**

**grid用户：**

**\[grid@aix210 ~\]$cat .profile**

export EDITOR=vi
    export ORACLE_SID=+ASM2
    export ORACLE_BASE=/u01/app/oracle
    export ORACLE_HOME=/u01/grid
    export GRID_HOME=/u01/grid
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    export THREADS_FLAG=native
    export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
    umask 022

**Oracle 用户:  
\[oracle@aix210 ~\]$cat .profile**

ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
    ORACLE_SID=prod2
    PATH=$PATH:$ORACLE_HOME/bin
    export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

**三、创建文件系统及目录**

**\[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/oracle
    chown -R grid:oinstall /u01/grid 
    chown -R grid:oinstall /u01/app/oraInventory 
    chmod -R 775 /u01/

**-----未完，待续...**

[Center]: /images/20220724/e923a56b987947ffb8674590b6ba73f7.png