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

野性酷女 2022-07-27 13:43 231阅读 0赞

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

环境：

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

集群软件： CRS 10.2.0.1

数据库：   Oracle 10.2.0.1

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

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

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

**系统架构：**

**![Center][]**

**本案例是用于基于VG Concurrent 的共享存储：**

**一、查看系统环境信息**

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

System Model: IBM,7028-6C4
    Machine Serial Number: 10681AA
    Processor Type: PowerPC_POWER4
    Processor Implementation Mode: POWER 4
    Processor Version: PV_4
    Number Of Processors: 2
    Processor Clock Speed: 1002 MHz
    CPU Type: 64-bit
    Kernel Type: 64-bit
    LPAR Info: 1 NULL
    Memory Size: 2048 MB
    Good Memory Size: 2048 MB
    Platform Firmware level: 3R080425
    Firmware Version: IBM,RG080425_d79e22_r
    Console Login: enable
    Auto Restart: true
    Full Core: false
    NX Crypto Acceleration: Not Capable
     
    Network Information
            Host Name: aix203
            IP Address: 192.168.8.203
            Sub Netmask: 255.255.255.0

**二、操作系统版本  **         
**\[root@aix203 /\]\#oslevel -r**  
**6100-09**  
**三、文件系统**

**\[oracle@aix203 ~\]$df -g**

Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
    /dev/hd4           6.00      5.82    4%    10247     1% /
    /dev/hd2           2.38      0.20   92%    45258    47% /usr
    /dev/hd9var        1.00      0.69   32%     8778     6% /var
    /dev/hd3           2.00      1.99    1%       57     1% /tmp
    /dev/hd1           1.00      1.00    1%       22     1% /home
    /dev/hd11admin      1.00      1.00    1%        5     1% /admin
    /proc                 -         -    -         -     -  /proc
    /dev/hd10opt       1.00      0.79   21%     8881     5% /opt
    /dev/livedump      0.25      0.25    1%        4     1% /var/adm/ras/livedump
    /dev/fslv00       10.00      7.40   26%     3460     1% /u01
    /aha                  -         -    -        16     1% /aha

**---- Oracle 和 CRS软件安装在/u01文件系统下，对于Oracle 10g安装，/tmp文件系统不能低于400M**

**四、页面交换空间**

**\[oracle@aix203 ~\]$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@aix203 /]#lslpp -l |grep bos.adt
      bos.adt.base               6.1.9.0  COMMITTED  Base Application Development
      bos.adt.debug              6.1.9.0  COMMITTED  Base Application Development
      bos.adt.include            6.1.9.0  COMMITTED  Base Application Development
      bos.adt.lib                6.1.8.0  COMMITTED  Base Application Development
      bos.adt.libm               6.1.9.0  COMMITTED  Base Application Development
      bos.adt.base               6.1.9.0  COMMITTED  Base Application Development
    [root@aix203 /]#lslpp -l |grep 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.0  COMMITTED  Performance Statistics Library
      bos.perf.perfstat          6.1.9.0  COMMITTED  Performance Statistics
      bos.perf.pmaix             6.1.9.0  COMMITTED  Performance Management 
      bos.perf.proctools         6.1.9.0  COMMITTED  Proc Filesystem Tools 
      bos.perf.tools             6.1.9.0  COMMITTED  Base Performance Tools 
      bos.perf.tune              6.1.9.0  COMMITTED  Performance Tuning Support 
      bos.perf.diag_tool        6.1.8.15  COMMITTED  Performance Diagnostic Tool 
      bos.perf.libperfstat       6.1.9.0  COMMITTED  Performance Statistics Library
      bos.perf.perfstat          6.1.9.0  COMMITTED  Performance Statistics
      bos.perf.pmaix             6.1.9.0  COMMITTED  Performance Management 
      bos.perf.tools             6.1.9.0  COMMITTED  Base Performance Tools 
      bos.perf.tune              6.1.9.0  COMMITTED  Performance Tuning Support

**补丁**：  
**\[root@aix204 /\]\#instfix -i |grep 10223**  
    All filesets for IZ10223 were found.  
  
**六、网络环境**  
网络配置：  
**\[root@aix203 /\]\#ifconfig -a**

en0: flags=5e084863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
            inet 192.168.8.203 netmask 0xffffff00 broadcast 192.168.8.255
    en2: flags=5e084863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
            inet 10.10.10.203 netmask 0xffffff00 broadcast 10.10.10.255

**\[root@aix203 /\]\#cat /etc/hosts**

# Internet Address      Hostname        # Comments
    # 192.9.200.1           net0sample      # ethernet name/address
    # 128.100.0.1           token0sample    # token ring name/address
    # 10.2.0.2              x25sample       # x.25 name/address
    # 2000:1:1:1:209:6bff:feee:2b7f         ipv6sample      # ipv6 name/address
    127.0.0.1               loopback localhost      # loopback (lo0) name/address
    192.168.8.203   aix203
    192.168.8.204   aix204
    
    192.168.8.251  aix203-vip
    192.168.8.252  aix204-vip
    
    10.10.10.203   aix203-priv
    10.10.10.204   aix204-priv

**七、创建并配置Oracle用户（所有node）**

**\[root@aix203 /\]\#id oracle**  
uid=300(oracle) gid=300(oinstall) groups=301(dba),302(hagsuser)

**配置Oracle用户对系统资源的访问：**

修改/etc/security/limits文件中default参数部分(需重启生效)

default:
        fsize = -1  ##(Unlimited) 
        core = -1    ##(Unlimited) 
        cpu = -1    ##(Unlimited) 
        data = -1    ##(Unlimited) 
        rss = -1    ##(Unlimited) 
        stack = -1  ##(Unlimited) 
        nofiles = -1 ##(Unlimited)

**\[oracle@aix203 ~\]$cat .profile**

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
    then echo "$MAILMSG"        # operation, the Shell checks
    fi                          # periodically.
    export ORACLE_SID=prod1
    export ORACLE_BASE=/u01/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
    export ORACLE_CRS_HOME=/u01/crs_1
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_CRS_HOME/lib:$ORACLE_CRS_HOME/lib32
    export PATH=$ORACLE_CRS_HOME/bin:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/es/sbin/cluster:/usr/es/sbin/cluster/sbin:/usr/es/sbin/cluster/utilities:/usr/es/sbin/cluster/diag:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
    umask 022 
    export EDITOR=vi

\-------- 未完，待续 ！

[Center]: /images/20220727/990863e4b71b4d8a93467bdf6dcd1568.png