Oracle10gOnAIXHACMP.docx
- 文档编号:8441853
- 上传时间:2023-01-31
- 格式:DOCX
- 页数:18
- 大小:22.06KB
Oracle10gOnAIXHACMP.docx
《Oracle10gOnAIXHACMP.docx》由会员分享,可在线阅读,更多相关《Oracle10gOnAIXHACMP.docx(18页珍藏版)》请在冰豆网上搜索。
Oracle10gOnAIXHACMP
Oracle10gRACForAix5.3配置文档(存储采用hacmp5.5并行卷组方式)
Dfrog2009.12.15
1rootvg配置
#df-g
FilesystemGBblocksFree%UsedIused%IusedMountedon
/dev/hd40.250.1923%498910%/
/dev/hd21.500.0995%3333859%/usr
/dev/hd9var0.250.1828%451810%/var
/dev/hd30.250.251%231%/tmp
/dev/fwdump0.750.751%41%/var/adm/ras/platform
/dev/hd10.250.251%51%/home
/proc-----/proc
/dev/hd10opt0.250.1733%17095%/opt
/dev/lv000.250.244%211%/audit
首先扩一下根盘
smitjfs2change2024288扩到1g方法1
chfs-asize=2048M/usr把/usr扩到2g方法2
chfs-asize=2G/var
chfs-asize=5G/tmp
在根盘上给oracle建立个lv
smitmklv名字oraclelv大小60ppx256m类型jfs2
smitjfs2选在已有lv上建立选择oraclelv挂载到/oracle
2建Oracle用户
/bin/mkgroupoinstall
/bin/mkgroupdba
smittyuser
建立oracle
*UserNAME[oracle]
UserID[500]
PrimaryGROUP[oinstall]
GroupSET[dba,hagsuser]
SoftFILEsize[-1]
SoftCPUtime[-1]
SoftDATAsegment[-1]
SoftSTACKsize[-1]
SoftCOREfilesize[-1]
Home[/oracle]
确认用户id一致
#idoracle
uid=500(oracle)gid=201(oinstall)groups=202(dba)
mkdir-p/oracle/product/10.2.0/crs
mkdir-p/oracle/product/10.2.0/crs
mkdir-p/oracle/product/10.2.0/crs
groupadd-g600dba
groupadd-g601oinstall
useradd-u700-goinstall-Gdba-d/oracle-c"OracleSoftwareOwner"oracle
passwdoracle
chown-Roracle:
oinstall/oracle
chmod-R775/oracle
3网络配置
使用smittcpip配置私网网卡ip地址
然后用ifconfig–a检查一下
编辑/etc/hosts
172.16.51.11cpaixds-pri
10.111.41.25cpaixds
10.111.41.229cpaixds-vip
172.16.51.12cpaixbs-pri
10.111.41.28cpaixbs
10.111.41.230cpaixbs-vip
注意检查hostname用smithostname
查看现有参数
#no-p-a|grepp_|grepsp
tcp_recvspace=262144
tcp_sendspace=262144
udp_recvspace=42080
udp_sendspace=9216
执行下面的命令否则在创建ASM的时候会报错
no-p-oudp_sendspace=65536
no-p-oudp_recvspace=262144
no-p-otcp_sendspace=262144
no-p-otcp_recvspace=262144
no-p-orfc1323=1
no-p-osb_max=2*655360
no-r-oipqmaxlen=512
查看结果
#no-p-a|grepp_|grepsp
tcp_recvspace=262144
tcp_sendspace=262144
udp_recvspace=262144
udp_sendspace=65536
#
4存储配置PowerPath
存储规划
LUN63100G->datavg->hdiskpower0
LUN64150G->backupvg->hdiskpower1
首先在存储上映射好LUN给2台主机
lspv
lsdev-Ccdisk
如果两边现实的设备不一致则需要重新识别
rmdev-lhdisk1-d
rmdev-lhdisk2-d
rmdev-lfcs0-Rd
rmdev-lfcs1-Rd
删掉不一样的部分然后运行cfgmgr–v
识别完成后重新运行lspv和lsdev-Ccdisk
开始安装PowerPath
把PowerPathODM和PowerPath传上来
先装ODM
smitinstallp
/PowerPath/ODM
EMCCLARiiONAIXSupportSoftware;
EMCCLARiiONFCPSupportSoftware
装好以后删除设备重新认可以看到多路径,但此时没有hdiskpowerx
安装PowerPath
smitinstallp
/PowerPath
EMCpowerALL
ACCEPTnewlicenseagreements?
Yes
#emcpreg-install输入powerpath序列号
1.
2QZC-DGBK-E3AF-WNT2-7DVS-WV7T
2.
2RZZ-GGBE-A347-WQA6-73V6-Z6ZM
powermtcheck_registration检查lisence
powermtconfig此时再看lspv就可以看到hdiskpowerx了
删除PowerPath
lslpp-l|grepEMC
installp-uEMC*
查看普通物理硬盘大小
lsdev-Ccdisk
lspv-lhdiskx
lsattr-Elhdiskx
查看EMC磁盘
powermtdispdev=all看LUN号然后和存储里面的对应
5Swap调整及软件包检查
lsattr-E-lmem0
goodsize7680AmountofusablephysicalmemoryinMbytesFalse
size7680TotalamountofphysicalmemoryinMbytesFalse
#lsps-a
PageSpacePhysicalVolumeVolumeGroupSize%UsedActiveAutoType
hd6hdisk0rootvg512MB1yesyeslv
扩展虚拟内存extendlvhd632
#extendlvhd614扩到4g
查看CPU
#lsdev-C|grepproc
proc0Available00-00Processor
proc2Available00-02Processor
#
#lsattr-E-lproc0
frequency3826000000ProcessorSpeedFalse
smt_enabledtrueProcessorSMTenabledFalse
smt_threads2ProcessorSMTthreadsFalse
stateenableProcessorstateFalse
typePowerPC_POWER6ProcessortypeFalse
确认安装oracle所需的系统库文件是否安装
lslpp-lbos.adt.basebos.adt.libbos.adt.libmbos.perf.perfstatbos.perf.libperfstatbos.perf.proctoolsbos.adt.profbos.cifs_fs.rte
lslpp:
0504-132Filesetbos.adt.libmnotinstalled.
lslpp:
0504-132Filesetbos.adt.profnotinstalled.
lslpp:
0504-132Filesetbos.cifs_fs.rtenotinstalled.
lslpp-lbos.adt.basebos.adt.libbos.adt.libmbos.perf.perfstatbos.perf.libperfstatbos.perf.proctoolsrsct.basic.rte
lslpp:
0504-132Filesetrsct.basic.rtenotinstalled.
lslpp-lbos.adtbos.cifs_fsbos.clvmpatbos.databos.perfrsct.basicpat.basicpat.clientsrsct.core
lslpp:
0504-132Filesetbos.adtnotinstalled.
lslpp:
0504-132Filesetbos.cifs_fsnotinstalled.
lslpp:
0504-132Filesetbos.clvmnotinstalled.
lslpp:
0504-132Filesetpatnotinstalled.
lslpp:
0504-132Filesetbos.datanotinstalled.
lslpp:
0504-132Filesetbos.perfnotinstalled.
lslpp:
0504-132Filesetrsct.basicnotinstalled.
lslpp:
0504-132Filesetpat.basicnotinstalled.
lslpp:
0504-132Filesetpat.clientsnotinstalled.
lslpp:
0504-132Filesetrsct.corenotinstalled.
注:
安装rsct.basicpat.basicpat.clients是要把支持HACMP的选项不要选择
lslpp-lxlC.aix50.rte:
7.0.0.4或以上(AIX5.3默认是8.*的)
lslpp-lxlC.rte:
7.0.0.1
oraclerac专用
lslpp-lbos.rte.lvm.rte(5.2.0.25orhigher)------默认安装
lslpp-lbos.clvm.enh--------------------------------前面已包括
6系统配置
smittychgsys
MaximumnumberofPROCESSESallowedperuser[4096]
HIGHwatermarkforpendingwriteI/Osperfile[33]
LOWwatermarkforpendingwriteI/Osperfile[24]
StackExecutionDisable(SED)Modeoff
7内存配置
设置内存参数:
vmo-p-olru_file_repage=0
vmo-p-ominperm%=5
vmo-p-omaxclient%=20
vmo-p-omaxperm%=20
vmo-p-ostrict_maxperm=0
vmo-p-ostrict_maxclient=1
配置AIO
smittyaio
AIXparameters:
--onlyapplicabletofilesystembasedconfigs
minservers=100
maxservers=100
maxreqs=16384
8Limit配置
vi/etc/security/limits加入以下
root:
fsize=-1
core=-1
cpu=-1
data=-1
rss=-1
stack=-1
nofiles=-1
oracle:
fsize=-1
data=-1
stack=-1
core=-1
cpu=-1
rss=-1
nofiles=-1
9配rhost相互信任
设置rhost
/.rhosts里面写+然后测试
#rlogincpaixbs
#rlogincpaixds
10配置并行vg.lv
smitmkvg
创建datavg
选择BigVG–PP512M选择允许并行VG
开始建裸设备(lv)
mklv-y'rac_crs_1024'-w'n'-s'n'-r'n'datavg2
mklv-y'rac_vote_1024'-w'n'-s'n'-r'n'datavg2
mklv-y'rac_system_1024'-w'n'-s'n'-r'n'datavg2
mklv-y'rac_pwdfile_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_sysaux_1024'-w'n'-s'n'-r'n'datavg2
mklv-y'rac_undo1_4096'-w'n'-s'n'-r'n'datavg8
mklv-y'rac_undo2_4096'-w'n'-s'n'-r'n'datavg8
mklv-y'rac_temp_4096'-w'n'-s'n'-r'n'datavg8
mklv-y'rac_users_1024'-w'n'-s'n'-r'n'datavg2
mklv-y'rac_redo1_1_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_redo1_2_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_redo1_3_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_redo2_1_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_redo2_2_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_redo2_3_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_ctl1_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_ctl2_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_ctl3_512'-w'n'-s'n'-r'n'datavg1
mklv-y'rac_spfile_512'-w'n'-s'n'-r'n'datavg1
完成以后可以运行以下命令查看
#ls-l/dev/rr*看到有建立的字符设备
#chownoracle:
oinstall/dev/rrac*修改属主
#ls-l/dev/rr*
在第一台机器上varyoffvgdatavg
在第二台机器上导入vg
smitvg
导入datavg
varyonvgdatavg
#chownoracle:
oinstall/dev/rrac*修改属主
#ls-l/dev/rr*
11安装、配置HACMP
放入PowerHa光盘装HACMP5.5全部安装即可
设置rhost
/.rhosts里面写+然后测试
#rlogincpaixbs
#rlogincpaixds
smithacmp
创建HACMPcluster
*clustername[cpaixha]
NewNodes[cpaixdscpaixbs]
创建资源组
Smithacmp
InitializationandStandardconfiguration
ConfigureHACMPResourceGroups
AddaResourceGroup
*ResourceGroupName[racdatagroup]
*ParticipatingNodes[cpaixdscpaixbs]
StartupPolicyOnlineOnAllAvailableNodes
FalloverPolicyBringOffline(OnErrorNodeOnly)
FallbackPolicyNeverFallback
给资源组添加共享磁盘
Smithacmp
InitializationandStandardconfiguration
ConfigureHACMPResourceGroups
Change/ShowResourcesforaResourceGroup(standard)
RescourceGroupName[racdatagroup]
ParticipatingNodes[cpaixdscpaixbs]
StartupPolicyOnlineOnAllAvailableNodes
FalloverPolicyBringOffline(OnErrorNodeOnly)
FallbackPolicyNeverFallback
ConcurrentVolumeGroups[datavg]
Useforcedvaryonofvolumegroupsifnecessaryfalse
配置心跳
Smithacmp
Extendedconfiguration
ExtendedTopologyconfiguration
Configurehacmpnetworks
Change/showanetworkintheHACMPcluster
修改net_ether_02(172.16.1.0/24)网络的属性从public改为private
同步HACMP配置
Smithacmp
Extendedconfiguration
ExtendedVerificationandsynchronization
*Verify,synchronizeorBoth[Both]
*Automaticallycorrecterrorsfounddringverification?
[Yes]
*forcesynchronizationifverificationfails[no]
*verifychangesonly?
[no]
测试datavg是否正常
Smitclstart
在选则在2个节点上都启动hacmp
然后在两边分别查看
lsvg–o
#lspv
hdisk0noneNone
hdisk10004274a6c25b30crootvgactive
hdisk2noneNone
hdisk3noneNone
hdisk4noneNone
hdisk5noneNone
hdisk6noneNone
hdisk7noneNone
hdisk8noneNone
hdisk9noneNone
hdiskpower00004274a04478fc6datavgconcurrent
hdiskpower1noneNone
12准备安装oracle
mkdir-p/oracle/product/10.2.0/crs
mkdir-p/oracle/product/10.2.0/racdb
chown-Roracle:
oinstall/oracle
chmod755/oracle
/oracle/.profile
exportORACLE_BASE=/oracle
exportORACLE_HOME=$ORACLE_BASE/product/10.2.0/racdb
exportORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs
exportORACLE_PATH=$ORACLE_BASE/common/oracle/sql:
.:
$ORACLE_HOME/rdbms/admin
exportORACLE_SID=cpaixrac01
exportNLS_LANG=AMERICAN_AMERICA.UTF8
exportNLS_DATE_FORMAT="mm/dd/yyyyhh24:
mi:
ss"
exportPATH=.:
${PATH}:
$HOME/bin:
$ORACLE_HOME/bin:
$ORA_CRS_HOME/bin
exportPATH=${PATH}:
/usr/bin:
/bin:
/usr/bin/X11:
/usr/local/bin
exportPATH=${PATH}:
$ORACLE_BASE/common/oracle/bin
exportORACLE_TERM=xterm
exportTNS_ADMIN=$ORACLE_HOME/network/admin
exportORA_NLS10=$ORACLE_HOME/nls/data
exportTNS_ADMIN=$ORACLE
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle10gOnAIX HACMP