问题描述:在vmware workstation 9上搭建oracle 11g rac环境的时候,grid安装完毕,但是在执行crs_stat -t命令验证安装的时候,只能看见自己节点的信息:
我在执行数据库软件安装的时候,发现只能看见rac1的节点,rac2节点看不见
grid@rac2:~> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.up.type ONLINE ONLINE rac2
ora.asm pe ONLINE ONLINE rac2
ora.cvu pe ONLINE ONLINE rac2
ora.gsd pe OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
s application ONLINE ONLINE rac2
ora.rac2.1.type ONLINE ONLINE rac2
ora.scan1.ip.type ONLINE ONLINE rac2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
grid@rac2:~>crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora.up.typeONLINEONLINErac2
ora.peONLINEONLINErac2
ora.peONLINEONLINErac2
ora.peOFFLINEOFFLINE
ora.rac2.gsdapplicationOFFLINEOFFLINE
sapplicationONLINEONLINErac2
ora.1.typeONLINEONLINErac2
ora.ip.typeONLINEONLINErac2
笔者这里安装了2个节点的rac,2个节点都只能看见自身的crs信息,之前的安装步骤都是执行成功的,于是重启2个节点是系统,尝试是否会正常,但想法太单纯了,当我自动重启2个节点的时候,发现最先启动的那个节点能看见crs信息,而另一个后启动的节点则出现错误:
RAC 2 系统先被拉起:
grid@rac2:~> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.up.type ONLINE ONLINE rac2
ora.asm pe ONLINE ONLINE rac2
ora.cvu pe ONLINE ONLINE rac2
ora.gsd pe OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
s application ONLINE ONLINE rac2
ora.rac2.1.type ONLINE ONLINE rac2
ora.scan1.ip.type ONLINE ONLINE rac2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
grid@rac2:~>crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora.up.typeONLINEONLINErac2
ora.peONLINEONLINErac2
ora.peONLINEONLINErac2
ora.peOFFLINEOFFLINE
ora.rac2.gsdapplicationOFFLINEOFFLINE
sapplicationONLINEONLINErac2
ora.1.typeONLINEONLINErac2
ora.ip.typeONLINEONLINErac2
RAC 1在RAC 2节点后启动:
grid@rac1:~> crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
grid@rac1:~> crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.
1
2
3
4
5
6
7
grid@rac1:~>crsctlcheckcrs
CRS-4638:OracleHighAvailabilityServicesisonline
CRS-4535:CannotcommunicatewithClusterReadyServices
CRS-4530:CommunicationsfailurecontactingClusterSynchronizationServicesdaemon
CRS-4534:CannotcommunicatewithEventManager
grid@rac1:~>crs_stat-t
CRS-0184:CannotcommunicatewiththeCRSdaemon.
发现重启后,只要是后启动的那个节点,crs就启动不成功,然后查看一下节点的实例状态
RAC 1:
grid@rac1:/opt/app/grid/11.2/log/rac1/crsd> ps -ef | grep asm
grid 4786 1 0 11:00 ? 00:00:00 asm_pmon_+ASM2
grid 4791 1 0 11:00 ? 00:00:00 asm_psp0_+ASM2
grid 4797 1 2 11:00 ? 00:00:11 asm_vktm_+ASM2
grid 4804 1 0 11:00 ? 00:00:00 asm_gen0_+ASM2
grid 4809 1 0 11:00 ? 00:00:00 asm_diag_+ASM2
grid 4814 1 0 11:00 ? 00:00:00 asm_ping_+ASM2
grid 4819 1 0 11:00 ? 00:00:01 asm_dia0_+ASM2
grid 4824 1 0 11:00 ? 00:00:01 asm_lmon_+ASM2
grid 4829 1 0 11:00 ? 00:00:00 asm_lmd0_+ASM2
grid 4834 1 0 11:00 ? 00:00:01 asm_lms0_+ASM2
grid 4841 1 0 11:00 ? 00:00:00 asm_lmhb_+ASM2
grid 4846 1 0 11:00 ? 00:00:00 asm_mman_+ASM2
grid 4851 1 0 11:00 ? 00:00:00 asm_dbw0_+ASM2
grid 4856 1 0 11:00 ? 00:00:00 asm_lgwr_+ASM2
grid 4861 1 0 11:00 ? 00:00:00 asm_ckpt_+ASM2
grid 4866 1 0 11:00 ? 00:00:00 asm_smon_+ASM2
grid 4871 1 0 11:00 ? 00:00:00 asm_rbal_+ASM2
grid 4876 1 0 11:00 ? 00:00:00 asm_gmon_+ASM2
grid 4881 1 0 11:00 ? 00:00:00 asm_mmon_+ASM2
grid 4886 1 0 11:00 ? 00:00:00 asm_mmnl_+ASM2
grid 4891 1 0 11:00 ? 00:00:00 asm_lck0_+ASM2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
grid@rac1:/opt/app/grid/11.2/log/rac1/crsd>ps-ef|grepasm
grid47861011:00?00:00:00asm_pmon_+ASM2
grid47911011:00?00:00:00asm_psp0_+ASM2
grid47971211:00?00:00:11asm_vktm_+ASM2
grid48041011:00?00:00:00asm_gen0_+ASM2
grid48091011:00?00:00:00asm_diag_+ASM2
grid48141011:00?00:00:00asm_ping_+ASM2
grid48191011:00?00:00:01asm_dia0_+ASM2
grid48241011:00?00:00:01asm_lmon_+ASM2
grid48291011:00?00:00:00asm_lmd0_+ASM2
grid48341011:00?00:00:01asm_lms0_+ASM2
grid48411011:00?00:00:00asm_lmhb_+ASM2
grid48461011:00?00:00:00asm_mman_+ASM2
grid48511011:00?00:00:00asm_dbw0_+ASM2
grid48561011:00?00:00:00asm_lgwr_+ASM2
grid48611011:00?00:00:00asm_ckpt_+ASM2
grid48661011:00?00:00:00asm_smon_+ASM2
grid48711011:00?00:00:00asm_rbal_+ASM2
grid48761011:00?00:00:00asm_gmon_+ASM2
grid48811011:00?00:00:00asm_mmon_+ASM2
grid48861011:00?00:00:00asm_mmnl_+ASM2
grid48911011:00?00:00:00asm_lck0_+ASM2
RAC 2:
grid@rac2:/opt/app/grid/11.2/log/rac2/crsd> ps -ef | grep asm
grid 4301 1 0 10:54 ? 00:00:00 asm_pmon_+ASM1
grid 4306 1 0 10:54 ? 00:00:00 asm_psp0_+ASM1
grid 4311 1 0 10:54 ? 00:00:00 asm_vktm_+ASM1
grid 4318 1 0 10:54 ? 00:00:00 asm_gen0_+ASM1
grid 4323 1 0 10:54 ? 00:00:00 asm_diag_+ASM1
grid 4328 1 0 10:54 ? 00:00:00 asm_ping_+ASM1
grid 4333 1 0 10:54 ? 00:00:02 asm_dia0_+ASM1
grid 4338 1 0 10:54 ? 00:00:01 asm_lmon_+ASM1
grid 4343 1 0 10:54 ? 00:00:01 asm_lmd0_+ASM1
grid 4348 1 0 10:54 ? 00:00:02 asm_lms0_+ASM1
grid 4355 1 0 10:54 ? 00:00:00 asm_lmhb_+ASM1
grid 4360 1 0 10:54 ? 00:00:00 asm_mman_+ASM1
grid 4365 1 0 10:54 ? 00:00:00 asm_dbw0_+ASM1
grid 4370 1 0 10:54 ? 00:00:00 asm_lgwr_+ASM1
grid 4375 1 0 10:54 ? 00:00:00 asm_ckpt_+ASM1
grid 4380 1 0 10:54 ? 00:00:00 asm_smon_+ASM1
grid 4385 1 0 10:54 ? 00:00:00 asm_rbal_+ASM1
grid 4390 1 0 10:54 ? 00:00:00 asm_gmon_+ASM1
grid 4395 1 0 10:54 ? 00:00:00 asm_mmon_+ASM1
grid 4400 1 0 10:54 ? 00:00:00 asm_mmnl_+ASM1
grid 4405 1 0 10:54 ? 00:00:00 asm_lck0_+ASM1
grid 4453 1 0 10:54 ? 00:00:00 asm_asmb_+ASM1
grid 4458 1 0 10:54 ? 00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
grid@rac2:/opt/app/grid/11.2/log/rac2/crsd>ps-ef|grepasm
grid43011010:54?00:00:00asm_pmon_+ASM1
grid43061010:54?00:00:00asm_psp0_+ASM1
grid43111010:54?00:00:00asm_vktm_+ASM1
grid43181010:54?00:00:00asm_gen0_+ASM1
grid43231010:54?00:00:00asm_diag_+ASM1
grid43281010:54?00:00:00asm_ping_+ASM1
grid43331010:54?00:00:02asm_dia0_+ASM1
grid43381010:54?00:00:01asm_lmon_+ASM1
grid43431010:54?00:00:01asm_lmd0_+ASM1
grid43481010:54?00:00:02asm_lms0_+ASM1
grid43551010:54?00:00:00asm_lmhb_+ASM1
grid43601010:54?00:00:00asm_mman_+ASM1
grid43651010:54?00:00:00asm_dbw0_+ASM1
grid43701010:54?00:00:00asm_lgwr_+ASM1
grid43751010:54?00:00:00asm_ckpt_+ASM1
grid43801010:54?00:00:00asm_smon_+ASM1
grid43851010:54?00:00:00asm_rbal_+ASM1
grid43901010:54?00:00:00asm_gmon_+ASM1
grid43951010:54?00:00:00asm_mmon_+ASM1
grid44001010:54?00:00:00asm_mmnl_+ASM1
grid44051010:54?00:00:00asm_lck0_+ASM1
grid44531010:54?00:00:00asm_asmb_+ASM1
grid44581010:54?00:00:00oracle+ASM1_asmb_+asm1(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
发现实例rac2实例怎么是asm1,2 个节点的实例交换了,然后关闭rac 2节点,重启rac 1节点
RAC 1:
grid@rac1:~> crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.
grid@rac1:~> crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager
grid@rac1:~> ps -ef | grep asm
grid 4596 4508 0 11:20 pts/0 00:00:00 grep asm
1
2
3
4
5
6
7
8
9
10
grid@rac1:~>crs_stat-t
CRS-0184:CannotcommunicatewiththeCRSdaemon.
grid@rac1:~>crsctlcheckcrs
CRS-4638:OracleHighAvailabilityServicesisonline
CRS-4535:CannotcommunicatewithClusterReadyServices
CRS-4530:CommunicationsfailurecontactingClusterSynchronizationServicesdaemon
CRS-4534:CannotcommunicatewithEventManager
grid@rac1:~>ps-ef|grepasm
grid45964508011:20pts/000:00:00grepasm
发现rac 1节点的crs还是不能启动,此时安装后没有修改过任何东西,为撒rac 1就启动不来了呢?查看rac 1的实例
grid@rac1:~> echo $ORACLE_SID
+ASM1
1
2
grid@rac1:~>echo$ORACLE_SID
+ASM1
实例确实是+ASM1,但刚才看见RAC 2上注册了这个实例,怀疑2个节点实例混乱了,临时修改一下rac 1的实例为+ASM2
grid@rac1:~> export ORACLE_SID=+ASM2
grid@rac1:~> ps -ef | grep asm
grid 4732 1 0 11:21 ? 00:00:00 asm_pmon_+ASM2
grid 4737 1 0 11:21 ? 00:00:00 asm_psp0_+ASM2
grid 4742 1 2 11:21 ? 00:00:02 asm_vktm_+ASM2
grid 4749 1 0 11:21 ? 00:00:00 asm_gen0_+ASM2
grid 4754 1 0 11:21 ? 00:00:00 asm_diag_+ASM2
grid 4759 1 0 11:21 ? 00:00:00 asm_ping_+ASM2
grid 4764 1 0 11:21 ? 00:00:00 asm_dia0_+ASM2
grid 4769 1 0 11:21 ? 00:00:00 asm_lmon_+ASM2
grid 4774 1 0 11:21 ? 00:00:00 asm_lmd0_+ASM2
grid 4779 1 0 11:21 ? 00:00:00 asm_lms0_+ASM2
grid 4786 1 0 11:21 ? 00:00:00 asm_lmhb_+ASM2
grid 4791 1 0 11:21 ? 00:00:00 asm_mman_+ASM2
grid 4796 1 0 11:21 ? 00:00:00 asm_dbw0_+ASM2
grid 4801 1 0 11:21 ? 00:00:00 asm_lgwr_+ASM2
grid 4806 1 0 11:21 ? 00:00:00 asm_ckpt_+ASM2
grid 4811 1 0 11:21 ? 00:00:00 asm_smon_+ASM2
grid 4816 1 0 11:21 ? 00:00:00 asm_rbal_+ASM2
grid 4821 1 0 11:21 ? 00:00:00 asm_gmon_+ASM2
grid 4826 1 0 11:21 ? 00:00:00 asm_mmon_+ASM2
grid 4831 1 0 11:21 ? 00:00:00 asm_mmnl_+ASM2
grid 4836 1 0 11:21 ? 00:00:00 asm_lck0_+ASM2
grid 4878 1 0 11:22 ? 00:00:00 asm_asmb_+ASM2
grid 4883 1 0 11:22 ? 00:00:00 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 4888 1 0 11:22 ? 00:00:00 asm_o000_+ASM2
grid 4893 1 0 11:22 ? 00:00:00 oracle+ASM2_o000_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 5360 4508 0 11:23 pts/0 00:00:00 grep asm
grid@rac1:~> crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
grid@rac1:~> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.up.type ONLINE ONLINE rac1
ora.asm pe ONLINE ONLINE rac1
ora.cvu pe ONLINE ONLINE rac1
ora.gsd pe OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
s application ONLINE ONLINE rac1
ora.rac2.1.type ONLINE ONLINE rac1
ora.scan1.ip.type ONLINE ONLINE rac1
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
grid@rac1:~>exportORACLE_SID=+ASM2
grid@rac1:~>ps-ef|grepasm
grid47321011:21?00:00:00asm_pmon_+ASM2
grid47371011:21?00:00:00asm_psp0_+ASM2
grid47421211:21?00:00:02asm_vktm_+ASM2
grid47491011:21?00:00:00asm_gen0_+ASM2
grid47541011:21?00:00:00asm_diag_+ASM2
grid47591011:21?00:00:00asm_ping_+ASM2
grid47641011:21?00:00:00asm_dia0_+ASM2
grid47691011:21?00:00:00asm_lmon_+ASM2
grid47741011:21?00:00:00asm_lmd0_+ASM2
grid47791011:21?00:00:00asm_lms0_+ASM2
grid47861011:21?00:00:00asm_lmhb_+ASM2
grid47911011:21?00:00:00asm_mman_+ASM2
grid47961011:21?00:00:00asm_dbw0_+ASM2
grid48011011:21?00:00:00asm_lgwr_+ASM2
grid48061011:21?00:00:00asm_ckpt_+ASM2
grid48111011:21?00:00:00asm_smon_+ASM2
grid48161011:21?00:00:00asm_rbal_+ASM2
grid48211011:21?00:00:00asm_gmon_+ASM2
grid48261011:21?00:00:00asm_mmon_+ASM2
grid48311011:21?00:00:00asm_mmnl_+ASM2
grid48361011:21?00:00:00asm_lck0_+ASM2
grid48781011:22?00:00:00asm_asmb_+ASM2
grid48831011:22?00:00:00oracle+ASM2_asmb_+asm2(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid48881011:22?00:00:00asm_o000_+ASM2
grid48931011:22?00:00:00oracle+ASM2_o000_+asm2(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid53604508011:23pts/000:00:00grepasm
grid@rac1:~>crsctlcheckcrs
CRS-4638:OracleHighAvailabilityServicesisonline
CRS-4537:ClusterReadyServicesisonline
CRS-4529:ClusterSynchronizationServicesisonline
CRS-4533:EventManagerisonline
grid@rac1:~>crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora.up.typeONLINEONLINErac1
ora.peONLINEONLINErac1
ora.peONLINEONLINErac1
ora.peOFFLINEOFFLINE
ora.rac1.gsdapplicationOFFLINEOFFLINE
sapplicationONLINEONLINErac1
ora.1.typeONLINEONLINErac1
ora.ip.typeONLINEONLINErac1
然后发现rac 1的crs自动拉起来了,执行数据库软件安装,可以看见所有的节点了。
转载请注明: 版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
最后编辑:2013-09-17作者:Jerry
一个积极向上的小青年,热衷于分享--Focus on DB,BI,ETL
本文发布于:2024-01-28 14:43:54,感谢您对本站的认可!
本文链接:https://www.4u4v.net/it/17064242378167.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
留言与评论(共有 0 条评论) |