您好,登錄后才能下訂單哦!
Oracle Study之-AIX6.1構(gòu)建Oracle 11gR2 RAC(1)
環(huán)境:
操作系統(tǒng): AIX 6100-09(SP3)
Cluster: HACMP6.1
集群軟件: GI 11.2.0.1
數(shù)據(jù)庫(kù):
構(gòu)建AIX平臺(tái)下RAC 依據(jù)共享存儲(chǔ)的使用方式可以分兩種:
1、建立基于并發(fā)卷組(VG concurrent)的共享存儲(chǔ)
2、建立基于ASM下的RAW的共享存儲(chǔ)
由于本系統(tǒng)陣列(SUN T300)不支持并發(fā)存儲(chǔ),不具有reserve_policy或reserve_lock屬性;所以在使用ASM做并發(fā)存儲(chǔ)時(shí),其中一個(gè)節(jié)點(diǎn)訪問(wèn)磁盤(pán)后會(huì)鎖定磁盤(pán),而另外的節(jié)點(diǎn)就不能再訪問(wèn)共享盤(pán);所以本次環(huán)境是通過(guò)HACMP實(shí)現(xiàn)并發(fā)卷組的共享,然后再通過(guò)邏輯卷建立ASM DISKGOUP. 這樣整個(gè)系統(tǒng)多了hacmp,增加了管理的復(fù)雜性。
系統(tǒng)架構(gòu):
本次系統(tǒng)架構(gòu)為:AIX 6100-09(SP3)+HACMP6.1+ASM+Oracle GI + Oracle 11gR2
一、系統(tǒng)環(huán)境
[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:
頁(yè)面交換空間:(Oracle 11g需要頁(yè)面交換空間最少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
網(wǎng)絡(luò)環(huán)境:
[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
-------- 本次構(gòu)建不使用DNS Server,所以在hosts文件解析scan ip。
二、創(chuàng)建配置用戶(hù)
[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
配置用戶(hù):(分配權(quán)限、資源配置)
[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
配置用戶(hù)profile:
grid用戶(hù):
[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 用戶(hù):
[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
三、創(chuàng)建文件系統(tǒng)及目錄
[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/
-----未完,待續(xù)...
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。