oracle11gr2 RAC For AIX安装Word下载.docx
《oracle11gr2 RAC For AIX安装Word下载.docx》由会员分享,可在线阅读,更多相关《oracle11gr2 RAC For AIX安装Word下载.docx(13页珍藏版)》请在冰点文库上搜索。
/usr/sbin/no-p-oudp_recvspace=1310720
/usr/sbin/no-p-otcp_sendspace=65536
/usr/sbin/no-p-otcp_recvspace=65536
/usr/sbin/no-p-orfc1323=1
/usr/sbin/no-p-osb_max=1310720
/usr/sbin/no-r-oipqmaxlen=512
fi
1.1.5配置异步I/O
#smittychgaio
#mkdev-laio0使异步I/O可用
需要将maxreqs调整至oracle推荐的大小65536,6.1版本默认大小65536,则无需更改
checking
#lsattr-Elaio0-amaxreqs
change
smittychgaio
将maximumnuberofrequests调整至65536
说明:
aix6.1
#ioo-oaio_maxreqs
aio_maxreqs=65536
1.1.6调整process大小
checking:
lsattr-Elsys0-amaxuproc
change:
/usr/sbin/chdev-lsys0-amaxuproc='
16384'
1.1.7设置ncargs参数
增加systemblocksize。
推荐增加ARG/ENV空间分配至128,也就是128个4k的block
#lsattr-E-lsys0-ancargs
#/usr/sbin/chdev-lsys0-ancargs='
128'
默认256,不做变更
1.1.8VMM内存参数修改
Checking:
#vmo-Lminperm%
#vmo-Lmaxperm%
#vmo-Lmaxclient%
#vmo-Llru_file_repage
#vmo-Lstrict_maxclient
#vmo-Lstrict_maxperm
Change:
#vmo-p-ominperm%=3
#vmo-p-omaxperm%=90
#vmo-p-omaxclient%=90
#vmo-p-olru_file_repage=0
#vmo-p-ostrict_maxclient=1
#vmo-p-ostrict_maxperm=0
1.1.9检查scan配置
#nslookup
1.2oracle环境配置
1.2.1创建组用户
组:
#mkgroup-'
A'
id='
1000'
adms='
root'
oinstall
1100'
asmadmin
1200'
dba
1300'
asmdba
1301'
asmoper
用户:
#mkuserid='
pgrp='
dba'
groups='
oinstall,asmadmin,asmdba,asmoper'
home='
/home/grid'
grid
1101'
oinstall,asmdba'
/home/oracle'
oracle
通过smittychuser更改root及oracle用户属性
#chusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEgrid
#chusercapabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATEoracle
#lsuser-acapabilitiesgridgrid
capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE
#lsuser-acapabilitiesgridoracle
1.2.2配置ssh(grid用户及oracle用户)
gird用户:
aix177生成密钥
[oracle@aix177~]$ssh-keygen-trsa
[oracle@aix177~]$ssh-keygen-tdsa
aix178生成密钥
[oracle@aix178~]$ssh-keygen-trsa
[oracle@aix178~]$ssh-keygen-tdsa
aix177生成认证文件
[oracle@aix177~]$sshaix177cat/home/grid/.ssh/id_rsa.pub>
>
~/.ssh/authorized_keys
[oracle@aix177~]$sshaix177cat/home/grid/.ssh/id_dsa.pub>
[oracle@aix177~]$sshaix178cat/home/grid/.ssh/id_rsa.pub>
Theauthenticityofhost'
aix178can'
tbeestablished.
RSAkeyfingerprintis40:
5b:
e9:
d0:
52:
c5:
3c:
80:
fe:
81:
d5:
c6:
08:
28:
7e:
58.
Areyousureyouwanttocontinueconnecting(yes/no)yes
Warning:
Permanentlyadded(RSA)tothelistofknownhosts.
[oracle@aix177~]$sshaix178cat/home/grid/.ssh/id_dsa.pub>
aix178生成认证文件
[oracle@aix178~]$sshaix177cat/home/grid/.ssh/id_rsa.pub>
[oracle@aix178~]$sshaix177cat/home/grid/.ssh/id_dsa.pub>
oracle@aix177'
spassword:
[oracle@aix178~]$sshaix178cat/home/grid/.ssh/id_rsa.pub>
[oracle@aix178~]$sshaix178cat/home/grid/.ssh/id_dsa.pub>
有效性验证检查,不需要输入口令表明配置成功。
[oracle@aix177~]$sshaix177date;
sshaix178date
FriDec2816:
59:
12CST2007
58:
[oracle@aix178~]$sshaix177date;
24CST2007
oracle用户
[oracle@aix177~]$sshaix177cat/home/oracle/.ssh/id_rsa.pub>
[oracle@aix177~]$sshaix177cat/home/oracle/.ssh/id_dsa.pub>
[oracle@aix177~]$sshaix178cat/home/oracle/.ssh/id_rsa.pub>
[oracle@aix177~]$sshaix178cat/home/oracle/.ssh/id_dsa.pub>
[oracle@aix178~]$sshaix177cat/home/oracle/.ssh/id_rsa.pub>
[oracle@aix178~]$sshaix177cat/home/oracle/.ssh/id_dsa.pub>
[oracle@aix178~]$sshaix178cat/home/oracle/.ssh/id_rsa.pub>
[oracle@aix178~]$sshaix178cat/home/oracle/.ssh/id_dsa.pub>
1.2.3配置.profile文件
先不要设置ORACLE_HOME/ORACLE_BASE/ORACLE_SID
gird用户
#exportORACLE_BASE=/haclu/app/oracle
#exportORACLE_HOME=/haclu/app/11.2.0/grid
exportAIXTHREAD_SCOPE=S
exportTEMP=/tmp
exportTMP=/tmp
exportTMPDIR=/tmp
umask022
oracle用户:
#ORACLE_BASE=/haclu/app/db
#ORACLE_HOME=/haclu/app/db/product/11.2.0/db_1
1.2.4创建安装文件系统
smittyjfs2->
/haclu30G
#mkdir-p/haclu/app/11.2.0/grid
#chown-Rgrid:
dba/haclu
#mkdir-p/haclu/app/oracle
#chownoracle:
dba/haclu/app/oracle
#chmod-R775/haclu
1.2.5配置ASM磁盘组
配置用于ocr/vote设备及数据库存储的ASM磁盘组
root@aix177:
/#lspv
hdisk000c7f6d4a99c322brootvgactive
hdisk100c7f6d4a5edc04arootvgactive
hdisk200c7f6d491dd6fd3None
hdisk300c7f6d491dd709dNone
hdisk400c7f6d491dd715dNone
hdisk500c7f6d491dd7244None
hdisk600c7f6d491dd734fNone
hdisk700c7f6d491dd743bNone
hdisk800c7f6d491dd76a0None
hdisk900c7f6d491dd7940None
hdisk1000c7f6d491dd7a58None
hdisk1100c7f6d491dd7c39None
hdisk1200c7f6d491dd7d0dNone
hdisk1300c7f6d491dd7de0None
hdisk1400c7f6d491dd7f3fNone
hdisk1500c7f6d491dd800aNone
hdisk1600c7f6d491dd81c4None
hdisk1700c7f6d491dd82a4None
hdisk1800c7f6d491dd8461None
hdisk1900c7f6d491021e69None
hdisk2000c7f6d491021f41None
hdisk2100c7fNone
查看磁盘属性
getconfDISK_SIZE/dev/rhdisk*
lscfg-vlhdisk*
修改磁盘策略及清除PVID
chdev-lhdisk*-apv=clear
chdev-lhdisk*-areserve_policy=no_reserve
修改磁盘属主及权限:
chowngrid:
dbarhdisk*
chmod660rhdisk*
1.2.6上传及解压文件
aix.ppc64_11gR2_grid.zip
aix.ppc64_11gR2_database_1of2.zip
aix.ppc64_11gR2_database_2of2.zip
第2章安装及配置GRIDInfrastructure
2.1安装GRID
使用root用户执行:
#./rootpre.sh
安装前的检查cuv
#./runcluvfy.shstage-precrsinst-naix177,aix178-r11gR2-verbose
#su-grid
$./runInstaller
创建OCRVOTE磁盘组
实际情况是这里选择了External外部冗余
按照提示执行上述脚本,并完成安装
第3章DB软件安装
3.1安装数据库软件
由于11.2.0.1的BUG,在选择集群安装无法找到第二个节点,需要使用grid用户分别在两台机器上执行以下命令:
cd/haclu/app/11.2.0/grid/oui/bin
节点1:
./runInstaller-updateNodeList"
CLUSTER_NODES={aix177,aix178}"
ORACLE_HOME_NAME="
GI_11201"
LOCAL_NODE="
aix177"
CRS=true
节点2:
aix178"
注:
选定双节点
以root用户执行相关脚本(两台服务器均做)
第4章创建ASM磁盘组
4.1配置.profile文件
修改grid用户和oracle用户的.profile
exportORACLE_BASE=/haclu/app/oracle
exportORACLE_HOME=/haclu/app/11.2.0/grid
exportPATH=$PATH:
/usr/css/bin:
$ORACLE_HOME/bin
ORACLE_BASE=/haclu/app/db
ORACLE_HOME=/haclu/app/db/product/11.2.0/db_1
exportORACLE_SID=testdb1/testdb2
4.2创建磁盘组
使用grid用户执行:
$asmca
完成DATA及RACOVERY磁盘组的创建
第5章创建数据库
5.1创建数据库TESTDB
使用oracle用户登录,并执行dbca创建数据库
退出,并完成数据库的创建
第6章管理维护
6.1CRS管理
1.显示CRS各资源状态
aix177:
/home/grid$crs_stat-t
/home/grid$crs_stat–t–v
检查cluster状态
$crsctlcheckcluster
查看scan配置及状态
$srvctlstatusscan
$srvctlconfigscan
启动oracleclusterare
#crsctlstartcluster–all
#crsctlstartcluster–naix177aix178
#crsctlstartcrs
停止oraclecluster
#crsctlstopcluster–all
#crsctlstopcluster–naix177aix178
#crsctlstopcrs