Oracle11g搭建RAC步骤.docx
- 文档编号:10460843
- 上传时间:2023-02-13
- 格式:DOCX
- 页数:31
- 大小:140.70KB
Oracle11g搭建RAC步骤.docx
《Oracle11g搭建RAC步骤.docx》由会员分享,可在线阅读,更多相关《Oracle11g搭建RAC步骤.docx(31页珍藏版)》请在冰豆网上搜索。
Oracle11g搭建RAC步骤
一、网卡绑定
1、修改配置文件
/etc/modprobe.conf
aliasbond0bonding
aliasbond1bonding
/etc/sysconfig/network-scripts/ifcfg-bond0
DEVICE=bond0
BOOTPROTO=static
ONBOOT=yes
USERCTL=no
IPADDR=192.168.56.101
BROADCAST=192.168.56.255
NETWORK=192.168.56.0
NETMASK=255.255.255.0
TYPE=Ethernet
BONDING_OPTS="mode=1miimon=100"
/etc/sysconfig/network-scripts/ifcfg-bond1
DEVICE=bond1
BOOTPROTO=static
ONBOOT=yes
USERCTL=no
IPADDR=192.168.136.101
BROADCAST=192.168.136.255
NETWORK=192.168.136.0
NETMASK=255.255.255.0
TYPE=Ethernet
BONDING_OPTS="mode=1miimon=100"
/etc/sysconfig/network-scripts/ifcfg-eth0
#AdvancedMicroDevices[AMD]79c970[PCnet32LANCE]
DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
USERCTL=no
HWADDR=00:
0c:
29:
9e:
87:
44
MASTER=bond0
SLAVE=yes
/etc/sysconfig/network-scripts/ifcfg-eth1
#AdvancedMicroDevices[AMD]79c970[PCnet32LANCE]
DEVICE=eth1
BOOTPROTO=none
ONBOOT=yes
HWADDR=00:
0c:
29:
9e:
87:
4e
MASTER=bond0
SLAVE=yes
/etc/sysconfig/network-scripts/ifcfg-eth2
#AdvancedMicroDevices[AMD]79c970[PCnet32LANCE]
DEVICE=eth2
BOOTPROTO=none
ONBOOT=yes
USERCTL=no
HWADDR=00:
0c:
29:
9e:
87:
58
MASTER=bond1
SLAVE=yes
/etc/sysconfig/network-scripts/ifcfg-eth3
#AdvancedMicroDevices[AMD]79c970[PCnet32LANCE]
DEVICE=eth3
BOOTPROTO=none
ONBOOT=yes
HWADDR=00:
0c:
29:
9e:
87:
62
USERCTL=no
MASTER=bond1
SLAVE=yes
命令:
ifensalvebond0eth0eth1
ifensalvebond1eth2eth3
servicenetworkrestart
2、检查配置
cat/proc/net/bonding/bond0
EthernetChannelBondingDriver:
v3.6.0(September26,2009)
BondingMode:
fault-tolerance(active-backup)
PrimarySlave:
None
CurrentlyActiveSlave:
eth0
MIIStatus:
up
MIIPollingInterval(ms):
100
UpDelay(ms):
0
DownDelay(ms):
0
SlaveInterface:
eth0
MIIStatus:
up
LinkFailureCount:
0
PermanentHWaddr:
00:
0c:
29:
9e:
87:
44
SlavequeueID:
0
SlaveInterface:
eth1
MIIStatus:
up
LinkFailureCount:
0
PermanentHWaddr:
00:
0c:
29:
9e:
87:
4e
SlavequeueID:
0
cat/proc/net/bonding/bond1
EthernetChannelBondingDriver:
v3.6.0(September26,2009)
BondingMode:
fault-tolerance(active-backup)
PrimarySlave:
None
CurrentlyActiveSlave:
eth2
MIIStatus:
up
MIIPollingInterval(ms):
100
UpDelay(ms):
0
DownDelay(ms):
0
SlaveInterface:
eth2
MIIStatus:
up
LinkFailureCount:
0
PermanentHWaddr:
00:
0c:
29:
9e:
87:
58
SlavequeueID:
0
SlaveInterface:
eth3
MIIStatus:
up
LinkFailureCount:
0
PermanentHWaddr:
00:
0c:
29:
9e:
87:
62
SlavequeueID:
0
3、测试自动切换
在vmwareworkstation界面上将相应的网卡(cat/proc/met/bonding/bondN)disconnect,依次测试。
用ifdown、ifup方式不行不会自动切换
/etc/modprobe.conf(redhat6.0+:
/etc/modprobe.d/dist.conf)需要添加fail_over_mac=1=> 切换的时候改MAC地址,不加不会切换成功(virtualbox、vmwareworkstation下测试)
二、建用户和组
groupaddoinstall-g1000
groupadddba-g1001
groupaddasmadmin-g1101
groupaddasmdba-g1102
groupaddasmoper-g1103
useradd -m-u1001-goinstall-Gasmadmin,asmdba,asmoper-d/home/gridgrid
useradd-m-u1002-gdba-Goinstall,asmdba,asmoper-d/home/oracleoracle
三、创建磁盘
ocr、data...
KERNEL=="sd?
",BUS=="scsi",PROGRAM=="/sbin/scsi_id-g-u/dev/$name",RESULT=="36000c293bc7e9c8139a42cb118aa8913",NAME="asm-ocr",OWNER="grid",GROUP="asmadmin",MODE="0660"RUN+="/bin/raw/dev/raw/raw1/dev/asm-ocr"
KERNEL=="sd?
",BUS=="scsi",PROGRAM=="/sbin/scsi_id-g-u/dev/$name",RESULT=="36000c2910f9afeae89aa3ef976f95c50",NAME="asm-data",OWNER="grid",GROUP="asmadmin",MODE="0660"RUN+="/bin/raw/dev/raw/raw2/dev/asm-data"
ACTION=="add",KERNEL=="raw1",OWNER="grid",GROUP="asmadmin",MODE="660"
ACTION=="add",KERNEL=="raw2",OWNER="grid",GROUP="asmadmin",MODE="660"
四、安装GridInfrastructure
这一步老是报错(报diskgroup相关错误,忘记记录了),改成预分配harddisk空间后成功
node1:
[root@oel501~]#/opt/grid/app/11.2.0/grid/root.sh
PerformingrootuseroperationforOracle11g
Thefollowingenvironmentvariablesaresetas:
ORACLE_OWNER=grid
ORACLE_HOME= /opt/grid/app/11.2.0/grid
Enterthefullpathnameofthelocalbindirectory:
[/usr/local/bin]:
Thefile"dbhome"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Thefile"oraenv"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Thefile"coraenv"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Creating/etc/oratabfile...
Entrieswillbeaddedtothe/etc/oratabfileasneededby
DatabaseConfigurationAssistantwhenadatabaseiscreated
Finishedrunninggenericpartofrootscript.
Nowproduct-specificrootactionswillbeperformed.
Usingconfigurationparameterfile:
/opt/grid/app/11.2.0/grid/crs/install/crsconfig_params
Creatingtracedirectory
UserignoredPrerequisitesduringinstallation
OLRinitialization-successful
rootwallet
rootwalletcert
rootcertexport
peerwallet
profilereaderwallet
pawallet
peerwalletkeys
pawalletkeys
peercertrequest
pacertrequest
peercert
pacert
peerrootcertTP
profilereaderrootcertTP
parootcertTP
peerpacertTP
papeercertTP
profilereaderpacertTP
profilereaderpeercertTP
peerusercert
pausercert
CRS-2728:
Aresourcetypewiththename'ora.daemon.type'isalreadyregistered
CRS-4000:
CommandAddfailed,orcompletedwitherrors.
CRS-2728:
Aresourcetypewiththename'ora.haip.type'isalreadyregistered
CRS-4000:
CommandAddfailed,orcompletedwitherrors.
CRS-2728:
Aresourcetypewiththename'ora.mdns.type'isalreadyregistered
CRS-4000:
CommandAddfailed,orcompletedwitherrors.
FailedtoregisterGridInfrastructuretypeora.mdns.typeat/opt/grid/app/11.2.0/grid/crs/install/crsconfig_lib.pmline7777.
/opt/grid/app/11.2.0/grid/perl/bin/perl-I/opt/grid/app/11.2.0/grid/perl/lib-I/opt/grid/app/11.2.0/grid/crs/install/opt/grid/app/11.2.0/grid/crs/install/rootcrs.plexecutionfailed
[root@oel501~]#/opt/grid/app/11.2.0/grid/root.sh
PerformingrootuseroperationforOracle11g
Thefollowingenvironmentvariablesaresetas:
ORACLE_OWNER=grid
ORACLE_HOME= /opt/grid/app/11.2.0/grid
Enterthefullpathnameofthelocalbindirectory:
[/usr/local/bin]:
Thefile"dbhome"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Thefile"oraenv"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Thefile"coraenv"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Entrieswillbeaddedtothe/etc/oratabfileasneededby
DatabaseConfigurationAssistantwhenadatabaseiscreated
Finishedrunninggenericpartofrootscript.
Nowproduct-specificrootactionswillbeperformed.
Usingconfigurationparameterfile:
/opt/grid/app/11.2.0/grid/crs/install/crsconfig_params
UserignoredPrerequisitesduringinstallation
^C
INTat/opt/grid/app/11.2.0/grid/crs/install/crsconfig_lib.pmline1379.
/opt/grid/app/11.2.0/grid/perl/bin/perl-I/opt/grid/app/11.2.0/grid/perl/lib-I/opt/grid/app/11.2.0/grid/crs/install/opt/grid/app/11.2.0/grid/crs/install/rootcrs.plexecutionfailed
Oraclerootscriptexecutionaborted!
[root@oel501~]#/opt/grid/app/11.2.0/grid/root.sh
PerformingrootuseroperationforOracle11g
Thefollowingenvironmentvariablesaresetas:
ORACLE_OWNER=grid
ORACLE_HOME= /opt/grid/app/11.2.0/grid
Enterthefullpathnameofthelocalbindirectory:
[/usr/local/bin]:
Thefile"dbhome"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Thefile"oraenv"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Thefile"coraenv"alreadyexistsin/usr/local/bin. Overwriteit?
(y/n)
[n]:
Entrieswillbeaddedtothe/etc/oratabfileasneededby
DatabaseConfigurationAssistantwhenadatabaseiscreated
Finishedrunninggenericpartofrootscript.
Nowproduct-specificrootactionswillbeperformed.
Usingconfigurationparameterfile:
/opt/grid/app/11.2.0/grid/crs/install/crsconfig_params
UserignoredPrerequisitesduringinstallation
CRS-2672:
Attemptingtostart'ora.mdnsd'on'oel501'
CRS-2676:
Startof'ora.mdnsd'on'oel501'succeeded
CRS-2672:
Attemptingtostart'ora.gpnpd'on'oel501'
CRS-2676:
Startof'ora.gpnpd'on'oel501'succeeded
CRS-2672:
Attemptingtostart'ora.cssdmonitor'on'oel501'
CRS-2672:
Attemptingtostart'ora.gipcd'on'oel501'
CRS-2676:
Startof'ora.cssdmonitor'on'oel501'succeeded
CRS-2676:
Startof'ora.gipcd'on'oel501'succeeded
CRS-2672:
Attemptingtostart'ora.cssd'on'oel501'
CRS-2672:
Attemptingtostart'ora.diskmon'on'oel501'
CRS-2676:
Startof'ora.diskmon'on'oel501'succeeded
CRS-2676:
Startof'ora.cssd'on'oel501'succeeded
ASMcreatedandstartedsuccessfully.
DiskGroupOCRcreatedsuccessfully.
clscfg:
-installmodespecified
SuccessfullyaccumulatednecessaryOCRkeys.
CreatingOCRkeysforuser'root',privgrp'root'..
Operationsuccessful.
CRS-4256:
Updatingtheprofile
Successfuladditionofvotingdisk71e7f2f09e7d4f1bbfa5e6eebf203d8f.
Successfullyreplacedvotingdiskgroupwith+OCR.
CRS-4256:
Updatingtheprofile
CRS-4266:
Votingfile(s)successfullyreplaced
## STATE FileUniversalId FileNameDiskgroup
-- ----- ----------------- ------------------
1.ONLINE 71e7f2f09e7d4f1bbfa5e6eebf203d8f(/dev/raw/raw1)[OCR]
Located1votingdisk(s).
CRS-2672:
Attemptingtostart'ora.asm'on'oel501'
CRS-2676:
Startof'ora.asm'on'oel501'succeeded
CRS-2672:
Attemptingtostart'ora.OCR.dg'on'oel501'
CRS-2676:
Startof'ora.OCR.dg'on'oel501'succeeded
ConfigureOracleGridInfrastructureforaCluster...succeeded
node2:
[root@oel502~]#/opt/grid/app/oraInventory/orainstRoot.sh
[root@oel502~]#/opt/grid/app/11.2.0/grid/root.sh
PerformingrootuseroperationforOracle11g
Thefollowingenvironmentvariablesaresetas:
ORACLE_OWNER=grid
ORACLE_HOME= /opt/grid/app/11.2.0/
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle11g 搭建 RAC 步骤