AIX61+HA+ORACLE10G RAC.docx
- 文档编号:17643427
- 上传时间:2023-04-24
- 格式:DOCX
- 页数:21
- 大小:22.28KB
AIX61+HA+ORACLE10G RAC.docx
《AIX61+HA+ORACLE10G RAC.docx》由会员分享,可在线阅读,更多相关《AIX61+HA+ORACLE10G RAC.docx(21页珍藏版)》请在冰豆网上搜索。
AIX61+HA+ORACLE10GRAC
oracleracaix|AIX6.1+HA+ORACLE10GRA...
第一次在AIX上安装Oracle,还是做RAC,偏偏操作系统还是比较新的AIX6.1还有HACMP5.4真是痛苦呀,经历了N长的时间,寻求了不少帮助,终于成型了,呵呵……AIX6.1+HAcmp5.4+ORACLE10GRAC安装参考手册
一、系统软硬件组成及安装环境规划
硬件环境:
IBMP6570两台
HP磁盘阵列2TB
交换机;
软件环境:
AIX6.1+HAcmp5.4
OracleDatabase10gforAIX5L(64-BIT)
二、系统规划
三、安装准备
1、调整AIX文件系统
使用smitfs两台机器调整成相同调整后的文件系统情况如下:
$hostname
node1
$df-g
FilesystemGBblocksFree%UsedIused%IusedMountedon
/dev/hd420.0019.841%101561%/
/dev/hd210.008.1919%400563%/usr
/dev/hd9var10.009.882%9881%/var
/dev/hd34.003.757%3681%/tmp
/dev/hd125.008.4867%364872%/home
/dev/hd11admin0.250.251%51%/admin
/proc-----/proc
/dev/hd10opt30.0029.871%46451%/opt
#hostname
node2
#df-g
FilesystemGBblocksFree%UsedIused%IusedMountedon
/dev/hd420.0019.851%102111%/
/dev/hd210.007.8822%428133%/usr
项目
说明
备注
操作系统
AIX6.1
AIX6.1
主机名
node1
node2
内存
16GB
16GB
本地磁盘
146GB*2
146GB*2
存储(HP)
2TB
2TB
双光纤通道
专用IP
124.17.100.102
124.17.100.103
虚拟IP
192.168.1.1
192.168.1.2
公共IP
124.17.100.104
124.17.100.105
OracleRACSID
keyan1
keyan2
数据库名称
keyan
SERVERICE_NAME
keyandb
/dev/hd9var10.009.872%9211%/var
/dev/hd34.003.5611%12461%/tmp
/dev/fwdump1.001.001%41%/var/adm/ras/platform
/dev/hd125.0010.2360%327432%/home
/dev/hd11admin0.250.251%51%/admin
/proc-----/proc
/dev/hd10opt30.0029.811%55661%/opt
2、检查系统内存(两个节点相同)
#lsattr-E-lsys0-arealmem
realmem15466496AmountofusablephysicalmemoryinKbytesFalse
3、检查CPU(两个节点相同)
#lsdev-C|grepproc
proc0Available00-00Processor
proc2Available00-02Processor
proc4Available00-04Processor
proc6Available00-06Processor
4、配置HACMP集群
$hostname
node1
$ifconfig-a
en8:
flags=1e080863,c0
inet192.168.1.1netmask0xffffff00broadcast192.168.1.255
en9:
flags=5e080863,c0
inet124.17.100.102netmask0xffffff00broadcast124.17.100.255
inet124.17.100.104netmask0xffffff00broadcast124.17.100.255
tcp_sendspace131072tcp_recvspace65536rfc13230
lo0:
flags=e08084b
inet127.0.0.1netmask0xff000000broadcast127.255.255.255
inet6:
:
1/0
tcp_sendspace131072tcp_recvspace131072rfc13231
$netstat-in
NameMtuNetworkAddressZoneIDIpktsIerrsOpktsOerrsColl
en81500link#20.21.5e.2.65.91803100062094200
en81500192.168.1192.168.1.1803100062094200
en91500link#30.14.5e.74.bc.b0272543018551140
en91500124.17.100124.17.100.102272543018551140
en91500124.17.100124.17.100.104272543018551140
lo016896link#1868306086848500
lo016896127127.0.0.1868306086848500
lo016896:
:
11868306086848500
$
#hostname
node2
#ifconfig-a
en8:
flags=1e080863,c0
inet192.168.1.2netmask0xffffff00broadcast192.168.1.255
en9:
flags=5e080863,c0
inet124.17.100.103netmask0xffffff00broadcast124.17.100.255
inet124.17.100.105netmask0xffffff00broadcast124.17.100.255
tcp_sendspace131072tcp_recvspace65536rfc13230
lo0:
flags=e08084b
inet127.0.0.1netmask0xff000000broadcast127.255.255.255
inet6:
:
1/0
tcp_sendspace131072tcp_recvspace131072rfc13231
#netstat-in
NameMtuNetworkAddressZoneIDIpktsIerrsOpktsOerrsColl
en81500link#20.21.5e.2.40.31714111067957300
en81500192.168.1192.168.1.2714111067957300
en91500link#30.14.5e.74.fc.e4259675018789740
en91500124.17.100124.17.100.103259675018789740
en91500124.17.100124.17.100.105259675018789740
lo016896link#1865854086604700
lo016896127127.0.0.1865854086604700
lo016896:
:
11865854086604700
#
(1)、创建cluster
smithacmp
回车,完成创建cluster。
(2)、添加节点
#smittyhacmp
InitializationandStandardConfiguration
AddNodestoanHACMPCluster
ConfigureNodestoanHACMPCluster(standard)
Typeorselectvaluesinentryfields.
PressEnterAFTERmakingalldesiredchanges.
[EntryFields]
*ClusterName[ibm_cls]
NewNodes(viaselectedcommunicationpaths)[node1node2]+
CurrentlyConfiguredNode(s)
(3)、添加资源组
#smittyhacmp
InitializationandStandardConfiguration
ConfigureHACMPResourceGroups
AddaResourceGroup
AddaResourceGroup
Typeorselectvaluesinentryfields.
PressEnterAFTERmakingalldesiredchanges.
[EntryFields]
*ResourceGroupName[racdbrg]
*ParticipatingNodes(DefaultNodePriority)[node1node2]+
StartupPolicyOnlineOnAllAvailableNodes+
FalloverPolicyBringOffline(OnErrorNodeOnly)+
FallbackPolicyNeverFallback
(4)、配置串口通信
#smittyhacmp
ExtendedConfiguration
ExtendedTopologyConfiguration
ConfigureHACMPCommunicationInterfaces/Devices
AddCommunicationInterfaces/Devices
Selectacategory
MovecursortodesireditemandpressEnter.
>AddDiscoveredCommunicationInterfaceandDevices
AddPre-definedCommunicationInterfacesandDevices
Selectacategory
MovecursortodesireditemandpressEnter.
Discoverylastperformed:
(Dec0820:
10)
CommunicationInterfaces
>CommunicationDevices
SelectPoint-to-PointPairofDiscoveredCommunicationDevicestoAdd
MovecursortodesireditemandpressF7.Usearrowkeystoscroll.
ONEORMOREitemscanbeselected.
PressEnterAFTERmakingallselections.
NodeDeviceDevicePathPvid
node1hdisk2/dev/hdisk20002ee503cc
node2hdisk2/dev/hdisk20002ee503cc
>node1tty0/dev/tty0
>node2tty0/dev/tty0
5、修改/etc/hosts文件(两节点分别完成),添加以下内容:
192.168.2.1node1_boot2
192.168.2.2node2_boot2
192.168.1.1node1_boot1
192.168.1.2node2_boot1
124.17.100.102node1node1_pre
124.17.100.103node2node2_pre
124.17.100.104node1_vip
124.17.100.105node2_vip
6、修改/etc/,添加如下的内容(双节点)
#fororaclerac
if[-f/usr/sbin/no];then
/usr/sbin/no-oextendednetstats=0>>/dev/null2>&1
/usr/sbin/no-p-oudp_sendspace=65536
/usr/sbin/no-p-oudp_recvspace=262144
/usr/sbin/no-p-otcp_sendspace=262144
/usr/sbin/no-p-otcp_recvspace=262144
/usr/sbin/no-p-orfc1323=1
/usr/sbin/no-p-osb_max=1310720
/usr/sbin/no-r-oipqmaxlen=512
fi
#fororacleracend
7、在双节点上分别建立Oracle用户,dba、oinstall、hagsuser组,并保持组ID和用户ID相同。
使用smittygroup和smittyuser添加组和用户添加后的情况如下:
#hostname
node1
#idoracle
uid=301(oracle)gid=220(oinstall)groups=221(dba),222(hagsuser)
#hostname
node2
#idoracle
uid=301(oracle)gid=220(oinstall)groups=221(dba),222(hagsuser)
8、配置磁盘阵列,创建共享卷
#smittymkvg
AddaBigVolumeGroup
Typeorselectvaluesinentryfields.
PressEnterAFTERmakingalldesiredchanges.
[EntryFields]
VOLUMEGROUPname[datavg]+
PhysicalpartitionSIZEinmegabytes128
*PHYSICALVOLUMEnames[hdisk4,hdisk5]+
Forcethecreationofavolumegroupyes+
ActivatevolumegroupAUTOMATICALLYno+
atsystemrestart?
VolumeGroupMAJORNUMBER[60]
CreateVGConcurrentCapable?
enhancedconcurrent+
激活卷组
#varyonvg-cdatavg
建立LV
mklv-y'rac_crs'-w'n'-s'n'-r'n'datavg2
mklv-y'rac_voting'-w'n'-s'n'-r'n'datavg2
mklv-y'rac_data01'-w'n'-s'n'-r'n'datavg128
修改权限
#chownoracle:
dba/dev/rrac_*
在另外一个节点上导入并行卷组#importvg-ydata_vghdisk4
为根分区做镜像
1)、将rootvg扩展到hdisk1上(默认是hdisk0)
chdev-lhdisk1-apv=yes
extendvgrootvghdisk1
2)、镜像
mirrorvg-S-c2rootvghdisk1
3)、重新生成bootimage
bosboot-ad/dev/hdisk0
bosboot-ad/dev/hdisk1
4)、更新bootlist
bootlist-mnormalhdisk0hdisk1cd0
查看更改结果
bootlist-o-mnormal
5)、重启系统
shutdown-Fr
9、确保每个节点上的hacmp集群已经正常启动,如果没有启动使用smittyclsstart启动集群
10、设置环境变量(两个节点分别配置)
节点1
su–oracle
vi.profile添加以下内容:
exportORACLE_HOME=/home/oracle/product/10.2.0/db
exportORACLE_BASE=/home/oracle
exportORACLE_SID=keyan1
unsetUSERNAME
umask022
exportPATH=$HOME/bin:
$ORACLE_HOME/bin:
$PATH
节点2
su–oracle
vi.profile添加以下内容:
exportORACLE_HOME=/home/oracle/product/10.2.0/db
exportORACLE_BASE=/home/oracle
exportORACLE_SID=keyan2
unsetUSERNAME
umask022
exportPATH=$HOME/bin:
$ORACLE_HOME/bin:
$PATH
四、安装OracleCRS
先打补丁p6718715_10203_AIX64-5L.zip,然后以root用户执行补丁6718715里面的rootpre.sh文件;
再用oracle用户执行CRS安装程序
./runInstaller
界面如下:
点击Next
点击Next
选择CRS安装的目录/home/oracle/product/10.2.0/crs,点击Next
oracle进行系统参数检查无问题,点击Next
添加Cluster中两个节点及相关的公网、私网、VIP网络名称,点击Next
选择ocr文件的位置为/dev/rac_crs,点击Next
选择votingdisk的位置为/dev/rac_crs,点击Next
执行安装至完成。
完成后安装提示用root用户分别在每个节点执行root.sh.
CRS配置完成。
五、安装oracle数据库软件
先以root用户执行安装盘中rootpre目录中的rootpre.sh脚本;
然后用oracle用户执行数据库安装软件
./runInstaller
界面如下:
点击Next
选择EnterpriseEdition,,点击Next
选择数据库安装目录为/home/oracle/product/10.2.0/db,点击Next
点击“SelectAll”选择所有节点,点击Ne
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- AIX61+HA+ORACLE10G RAC AIX61 HA ORACLE10G