配置双机has
上一篇 / 下一篇 2014-05-27 17:01:13 / 个人分类:总结
- 主机上配置
- 以Oracle用户登录主节点。
- 添加监听器。
.T8DJ![+JAu0
wA"jF(Y0Eo0$cd $ORACLE_HOME/network/admin/51Testing软件测试网*Gv;{!l3n3afrz
^%H&KHW Q9Y}'y0$vi listener.ora
4Y4U O;Ad4S[0J,Ou4I"Wl)~f0在“listener.ora”文件中修改如下内容:
]{ BE.xJ'P0LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526)) (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526)) ) ) ADR_BASE_LISTENER = /home/oracrs/base ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
$x$zaM#hw)R0“floatIP”修改为双机浮动IP地址。51Testing软件测试网 rLd'BX_0yw
)G0h/|3a A$c2dt \ax^0
.x[1X+{/GaZ0 - 修改tnsnames.ora。51Testing软件测试网'E}!tAO3i
$?B[8x6T;\"^w0$cd $ORACLE_HOME/network/admin/51Testing软件测试网z n"L6QmF4S#A
51Testing软件测试网gOS7^5@$vi tnsnames.ora51Testing软件测试网t#i5JUE
e*Ps$cA v~0在“tnsnames.ora”文件中修改如下内容:
f,wBE4u"F)F{!T0MMSGDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mmsgdb) ) )
51Testing软件测试网DGE\q x7X G @“floatIP”修改为双机浮动IP地址。
qc'JqBb)V0%[Ych~+[^;q x0
zX K&n+Z0 - 以grid用户登录主节点。
- 执行如下命令,查看HAS状态。
- $crsctl stat res -t
-------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE mmsg01 ora.asm ONLINE ONLINE mmsg01 Started ora.ons OFFLINE OFFLINE mmsg01 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 ONLINE ONLINE mmsg01 ora.diskmon 1 OFFLINE OFFLINE ora.evmd 1 ONLINE ONLINE mmsg01
- 51Testing软件测试网s'A!Mb_2vD
如果显示“ora.LISTENER.lsnr”,表示默认监听已经添加,则不需要继续添加默认监听。
#SaF`#hJo k;O0
w2[jUD/}%G-^0如果没有显示“ora.LISTENER.lsnr”,表示默认监听未添加,请按照6继续添加默认监听。
q5irr#I#Q/k0- 51Testing软件测试网!y7S2O;R4je+b,a
Ub
如果显示“ora.DG_ORA.dg”,表示DG_ORA已经创建成功,则不需要添加ASM实例。51Testing软件测试网$tw/TyP6a"O
- 51Testing软件测试网4yh y3jDp&m
如果没有显示“ora.DG_ORA.dg”,表示DG_ORA未创建成功,请按照6添加ASM实例。51Testing软件测试网]L`.yj@IH)Rt
/F0K%w M*Gl2G#yAY6AU0
*iI!_(}D^qU0- 添加默认监听和ASM实例。
- 检查空间大小。
/Qi#Zz2NM ^0%/home/oracrs/product/11gR2/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true "CLUSTER_NODES={}" ORACLE_HOME=/home/oracrs/product/11gR2/grid
^ PfS v C5nZ0Bgw K{+wp%Pj0屏幕显示如下所示:
5}U:`.A%\ YD0Starting Oracle Universal Installer...Checking swap space: must be greater than 500 MB. Actual 16386 MB PassedThe inventory pointer is located at /etc/oraInst.loc The inventory is located at /opt/oraInventory
- 51Testing软件测试网]P8DKm*f'P ~"~
执行如下命令,添加默认监听。
@HiP)E0*F&Sj6u'kv7\~.p0$netca -silent -responsefile /home/oracrs/product/11gR2/grid/network/install/netca_typ.rsp
raO:R+d TA051Testing软件测试网)~ ?oq_+mU:H添加成功则显示如下信息:
I tH;[L0Parsing command line arguments: Parameter "silent" = true Parameter "responsefile" = /home/oracrs/product/11gR2/grid/network/install/netca_typ.rsp Done parsing command line arguments. Oracle Net Services Configuration: Profile configuration complete. Listener "LISTENER"already exists. Oracle Net Services configuration successful. The exit code is 0
- 51Testing软件测试网Uqp2L"v"J
执行如下命令,添加ASM实例。
$v~1Q7];uY&}A+D051Testing软件测试网4E:U e6OL说明:
在添加ASM实例前,请以root用户登录到主节点,执行sh /etc/init.d/after.local$asmca -silent -oui_internal -sysAsmPassword AsmSys123 -asmsnmpPassword AsmSnmp123 -configureASM -diskString '/dev/diskgroup' -diskGroupName dg_ora -diskList /dev/diskgroup/dg_ora -redundancy EXTERNAL51Testing软件测试网%~1W pW B2R
51Testing软件测试网#J _4[.gC4T屏幕显示如下信息表示ASM实例创建成功。51Testing软件测试网gH3r0A-c\
Disk Group dg_ora created successfully.
J6Z,k k9y#jT6@0$export asmspfile=`asmcmd spget`51Testing软件测试网'EX,`Z0l
51Testing软件测试网y^$S2JGT$asmcmd spset $ORACLE_HOME/dbs/spfile+ASM.ora
-nCW+T:xCDduW0
V+b0TrB%M,az051Testing软件测试网-y OF$m]4^O&@4U
Z]p9_x[,X)xmo0执行如下命令,检查HAS状态。51Testing软件测试网8`7U*d7r[c-k-\
51Testing软件测试网4_e2fn5TOel51Testing软件测试网FA6V1i&aGi({%\ s
$crsctl stat res -t51Testing软件测试网|4l!h9uj
g6wT-U#C_t} [0屏幕显示如下信息:51Testing软件测试网J7uQD+^GN ]
-------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources 备机上配置:
- 以Oracle用户登录备节点。
- 添加监听器。51Testing软件测试网2iMTK8kJ
e [
)m&IP7_m1T.XO0$cd $ORACLE_HOME/network/admin/
D"x\0V;`06jS d7dhl[d~0$vi listener.ora
~7e%C&?6fkbtp02i'jQ8BfC+O2wXl0在“listener.ora”文件中修改如下内容:
5^^IoYq)\0LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1526)) (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526)) ) ) ADR_BASE_LISTENER = /home/oracrs/base ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
51Testing软件测试网 T)?"r8aH|M7GL“floatIP”修改为双机浮动IP地址。51Testing软件测试网y+l#o?!P7g2s
51Testing软件测试网f P7}\C da4Rq51Testing软件测试网\f5k1K5IBu V
- 修改tnsnames.ora。51Testing软件测试网QM!z8S)tW!s#z2}
lQ}.e"_|6`N,OR;|0$cd $ORACLE_HOME/network/admin/
i,kS~(H051Testing软件测试网"h{)Vh S$vi tnsnames.ora51Testing软件测试网,Bu7b(ptkq
51Testing软件测试网7]6Kx4G/i0kYm在“tnsnames.ora”文件中修改如下内容:
!Qg/n `u|0mr0MMSGDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =floatIP)(PORT = 1526)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mmsgdb) ) )
2EM#r7R}J%j0“floatIP”修改为双机浮动IP地址。51Testing软件测试网[2AzJ#t[/g3\ E-P
51Testing软件测试网|;F1i F ODi51Testing软件测试网fNP@-}t4d ^6^[
- 以grid用户登录备节点。
- 在备节点上执行如下命令检查空间大小。51Testing软件测试网%yl8c
w A/vw&j
51Testing软件测试网l7@@ d)kD
$/home/oracrs/product/11gR2/grid/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true "CLUSTER_NODES={}" ORACLE_HOME=/home/oracrs/product/11gR2/grid51Testing软件测试网,Qm1v%sW
u KjF,Uu NOTo0屏幕显示如下信息:
$m&m8Ek"_;A{0Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 16386 MB Passed The inventory pointer is located at /etc/oraInst.loc The inventory is located at /opt/oraInventory
51Testing软件测试网-B8n"i3[#^%Gu1N51Testing软件测试网wPI-O-V\ rVH2M0l
- 启动HAS,查看HAS状态。51Testing软件测试网
Q?*WWs+zhmy
i5|+D(\5~0$crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
\5P1X'y0~i09Uk.X$F3Qg GD0$crsctl stop has -f51Testing软件测试网a+\#Le+s
`)hSkW3Hj,r+{/E0$crsctl start has
/oh8jX,t,}+[0屏幕显示如下信息时,表示HAS启动成功。51Testing软件测试网*P7[I~%}&?(a*xCRS-4123: Oracle High Availability Services has been started.
$crsctl stat res -t
9e2~nZ]1rH051Testing软件测试网p8x1`F2m7NlIj屏幕显示如下信息:
g?+` u8d @SJ(G0-------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources --------------------------------------------------------------------------------ora.DG_ORA.dgONLINE ONLINE mmsg02 ora.LISTENER.lsnr ONLINE ONLINE mmsg02 ora.asm ONLINE ONLINE mmsg02 Started ora.ons OFFLINE OFFLINE mmsg02 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 ONLINE ONLINE mmsg02 ora.diskmon 1 OFFLINE OFFLINE ora.evmd 1 ONLINE ONLINE mmsg02
6H+y\G9j#y#@Dr0如果“ora.DG_ORA.dg”没有显示,请执行如下操作添加相应的资源。51Testing软件测试网"N-g-x4p|!j%C
- 以root用户登录备节点。
- 51Testing软件测试网o[*n2n8sM*^ {
执行如下命令,查看“DG_ORA”对应的scsi信息。
/Thm#|Hc051Testing软件测试网$^,^uh/r(pL4V"f#more /etc/init.d/after.local51Testing软件测试网'W-YO%uii
51Testing软件测试网pl4pHHLU显示类似如下信息时,表示“DG_ORA”对应的scsi信息为“scsi-360022a110003135eae8c38ec00000001”。51Testing软件测试网*?.A:{,I1@
mkdir -p /dev/diskgroup chmod 770 /dev/diskgroup chown grid:oinstall /dev/diskgroup ln -f -s /dev/disk/by-id/scsi-360022a110003135eae8c38ec00000001/dev/diskgroup/dg_ora chmod 660 /dev/diskgroup/dg_* chown -R grid:oinstall /dev/diskgroup/dg_*
L AwZa0执行如下命令,查看“DG_ORA”scsi对应的物理分区。51Testing软件测试网/r6{5}'Yh4~,fN
7|'N y;qQe Z0#ls -lt /dev/disk/by-id/scsi*
T5~h*}0mv[d051Testing软件测试网Xv.Y LU;lr显示类似如下信息时,表示“scsi-360022a110003135eae8c38ec00000001”对应的物理分区为“sdb”。
aY7aE*L0lrwxrwxrwx 1 root root 9 Mar 30 04:07 /dev/disk/by-id/scsi-360022a110003135e8f4e665d00000002 -> ../../sdc lrwxrwxrwx 1 root root 9 Mar 30 04:07 /dev/disk/by-id/scsi-360022a110003135eae8c38ec00000001-> ../../sdb lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part1 -> ../../sda1 lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part2 -> ../../sda2 lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part6 -> ../../sda6 lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part7 -> ../../sda7 lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part5 -> ../../sda5 lrwxrwxrwx 1 root root 10 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07-part3 -> ../../sda3 lrwxrwxrwx 1 root root 9 Mar 30 04:07 /dev/disk/by-id/scsi-3600508e0000000008dea14afb99ddb07 -> ../../sda
x!wmei%c0更改物理分区的属主。
1Z M_s"@"HM051Testing软件测试网1YDGjDf.rHR^!J#chown -R grid:oinstall /dev/sdb
2F s,K [;|w0- 以grid用户登录备节点,设置DISPLAY环境变量,具体操作请参见设置DISPLAY环境变量。
- 执行asmca命令,启动ASMCA安装配置界面。
TAG:
标题搜索
日历
|
|||||||||
日 | 一 | 二 | 三 | 四 | 五 | 六 | |||
1 | |||||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 | |||
9 | 10 | 11 | 12 | 13 | 14 | 15 | |||
16 | 17 | 18 | 19 | 20 | 21 | 22 | |||
23 | 24 | 25 | 26 | 27 | 28 | 29 | |||
30 |
我的存档
数据统计
- 访问量: 111531
- 日志数: 89
- 图片数: 1
- 文件数: 15
- 建立时间: 2013-03-01
- 更新时间: 2018-08-23