oracle 4535,CRS

阅读: 评论:0

oracle 4535,CRS

oracle 4535,CRS

问题描述:在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

<4j.type ONLINE ONLINE rac2

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

<4j.type ONLINE ONLINE rac2

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

<4j.type ONLINE ONLINE rac1

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小时内删除。

标签:oracle   CRS
留言与评论(共有 0 条评论)
   
验证码:

Copyright ©2019-2022 Comsenz Inc.Powered by ©

网站地图1 网站地图2 网站地图3 网站地图4 网站地图5 网站地图6 网站地图7 网站地图8 网站地图9 网站地图10 网站地图11 网站地图12 网站地图13 网站地图14 网站地图15 网站地图16 网站地图17 网站地图18 网站地图19 网站地图20 网站地图21 网站地图22/a> 网站地图23