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，增加了管理的復雜性。
系統架構：
本次系統架構為：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
配置用戶：（分配權限、資源配置）
[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 = -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/
-----未完，待續...
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
