oracle 4535,CRS-4535: Cannot communicate with Cluster Ready Services

2024-01-19 02:10

本文主要是介绍oracle 4535,CRS-4535: Cannot communicate with Cluster Ready Services,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

问题描述:在vmware workstation 9上搭建oracle 11g rac环境的时候,grid安装完毕,但是在执行crs_stat -t命令验证安装的时候,只能看见自己节点的信息:

我在执行数据库软件安装的时候,发现只能看见rac1的节点,rac2节点看不见

grid@rac2:~> crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.DATA.dg ora....up.type ONLINE ONLINE rac2

ora....N1.lsnr ora....er.type ONLINE ONLINE rac2

ora.asm ora.asm.type ONLINE ONLINE rac2

ora.cvu ora.cvu.type ONLINE ONLINE rac2

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE rac2

ora.oc4j ora.oc4j.type ONLINE ONLINE rac2

ora.ons ora.ons.type ONLINE ONLINE rac2

ora....SM1.asm application ONLINE ONLINE rac2

ora.rac2.gsd application OFFLINE OFFLINE

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip ora....t1.type ONLINE ONLINE rac2

ora.scan1.vip ora....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.DATA.dgora....up.typeONLINEONLINErac2

ora....N1.lsnrora....er.typeONLINEONLINErac2

ora.asmora.asm.typeONLINEONLINErac2

ora.cvuora.cvu.typeONLINEONLINErac2

ora.gsdora.gsd.typeOFFLINEOFFLINE

ora....networkora....rk.typeONLINEONLINErac2

ora.oc4jora.oc4j.typeONLINEONLINErac2

ora.onsora.ons.typeONLINEONLINErac2

ora....SM1.asmapplicationONLINEONLINErac2

ora.rac2.gsdapplicationOFFLINEOFFLINE

ora.rac2.onsapplicationONLINEONLINErac2

ora.rac2.vipora....t1.typeONLINEONLINErac2

ora.scan1.vipora....ip.typeONLINEONLINErac2

笔者这里安装了2个节点的rac,2个节点都只能看见自身的crs信息,之前的安装步骤都是执行成功的,于是重启2个节点是系统,尝试是否会正常,但想法太单纯了,当我自动重启2个节点的时候,发现最先启动的那个节点能看见crs信息,而另一个后启动的节点则出现错误:

RAC 2 系统先被拉起:

grid@rac2:~> crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora.DATA.dg ora....up.type ONLINE ONLINE rac2

ora....N1.lsnr ora....er.type ONLINE ONLINE rac2

ora.asm ora.asm.type ONLINE ONLINE rac2

ora.cvu ora.cvu.type ONLINE ONLINE rac2

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE rac2

ora.oc4j ora.oc4j.type ONLINE ONLINE rac2

ora.ons ora.ons.type ONLINE ONLINE rac2

ora....SM1.asm application ONLINE ONLINE rac2

ora.rac2.gsd application OFFLINE OFFLINE

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip ora....t1.type ONLINE ONLINE rac2

ora.scan1.vip ora....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.DATA.dgora....up.typeONLINEONLINErac2

ora....N1.lsnrora....er.typeONLINEONLINErac2

ora.asmora.asm.typeONLINEONLINErac2

ora.cvuora.cvu.typeONLINEONLINErac2

ora.gsdora.gsd.typeOFFLINEOFFLINE

ora....networkora....rk.typeONLINEONLINErac2

ora.oc4jora.oc4j.typeONLINEONLINErac2

ora.onsora.ons.typeONLINEONLINErac2

ora....SM1.asmapplicationONLINEONLINErac2

ora.rac2.gsdapplicationOFFLINEOFFLINE

ora.rac2.onsapplicationONLINEONLINErac2

ora.rac2.vipora....t1.typeONLINEONLINErac2

ora.scan1.vipora....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.dg ora....up.type ONLINE ONLINE rac1

ora....N1.lsnr ora....er.type ONLINE ONLINE rac1

ora.asm ora.asm.type ONLINE ONLINE rac1

ora.cvu ora.cvu.type ONLINE ONLINE rac1

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE rac1

ora.oc4j ora.oc4j.type ONLINE ONLINE rac1

ora.ons ora.ons.type ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac1

ora.rac1.gsd application OFFLINE OFFLINE

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac2.vip ora....t1.type ONLINE ONLINE rac1

ora.scan1.vip ora....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.DATA.dgora....up.typeONLINEONLINErac1

ora....N1.lsnrora....er.typeONLINEONLINErac1

ora.asmora.asm.typeONLINEONLINErac1

ora.cvuora.cvu.typeONLINEONLINErac1

ora.gsdora.gsd.typeOFFLINEOFFLINE

ora....networkora....rk.typeONLINEONLINErac1

ora.oc4jora.oc4j.typeONLINEONLINErac1

ora.onsora.ons.typeONLINEONLINErac1

ora....SM2.asmapplicationONLINEONLINErac1

ora.rac1.gsdapplicationOFFLINEOFFLINE

ora.rac1.onsapplicationONLINEONLINErac1

ora.rac2.vipora....t1.typeONLINEONLINErac1

ora.scan1.vipora....ip.typeONLINEONLINErac1

然后发现rac 1的crs自动拉起来了,执行数据库软件安装,可以看见所有的节点了。

转载请注明: 版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!

最后编辑:2013-09-17作者:Jerry

61f384f23c24a3306817dc87a6906c2d.png

一个积极向上的小青年,热衷于分享--Focus on DB,BI,ETL

这篇关于oracle 4535,CRS-4535: Cannot communicate with Cluster Ready Services的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/620971

相关文章

Oracle type (自定义类型的使用)

oracle - type   type定义: oracle中自定义数据类型 oracle中有基本的数据类型,如number,varchar2,date,numeric,float....但有时候我们需要特殊的格式, 如将name定义为(firstname,lastname)的形式,我们想把这个作为一个表的一列看待,这时候就要我们自己定义一个数据类型 格式 :create or repla

ORACLE 11g 创建数据库时 Enterprise Manager配置失败的解决办法 无法打开OEM的解决办法

在win7 64位系统下安装oracle11g,在使用Database configuration Assistant创建数据库时,在创建到85%的时候报错,错误如下: 解决办法: 在listener.ora中增加对BlueAeri-PC或ip地址的侦听,具体步骤如下: 1.启动Net Manager,在“监听程序”--Listener下添加一个地址,主机名写计

Oracle Start With关键字

Oracle Start With关键字 前言 旨在记录一些Oracle使用中遇到的各种各样的问题. 同时希望能帮到和我遇到同样问题的人. Start With (树查询) 问题描述: 在数据库中, 有一种比较常见得 设计模式, 层级结构 设计模式, 具体到 Oracle table中, 字段特点如下: ID, DSC, PID; 三个字段, 分别表示 当前标识的 ID(主键), DSC 当

oracle分页和mysql分页

mysql 分页 --查前5 数据select * from table_name limit 0,5 select * from table_name limit 5 --limit关键字的用法:LIMIT [offset,] rows--offset指定要返回的第一行的偏移量,rows第二个指定返回行的最大数目。初始行的偏移量是0(不是1)。   oracle 分页 --查前1-9

ImportError: cannot import name ‘print_log‘ from ‘logging‘

mmcv升级到2.+后删除了很多 解决 查FAQ文档,找到 添加到mmcv.utils下即可

vue 父组件调用子组件的方法报错,“TypeError: Cannot read property ‘subDialogRef‘ of undefined“

vue 父组件调用子组件的方法报错,“TypeError: Cannot read property ‘subDialogRef’ of undefined” 最近用vue做的一个界面,引入了一个子组件,在父组件中调用子组件的方法时,报错提示: [Vue warn]: Error in v-on handler: “TypeError: Cannot read property ‘methods

ORACLE语法-包(package)、存储过程(procedure)、游标(cursor)以及java对Result结果集的处理

陈科肇 示例: 包规范 CREATE OR REPLACE PACKAGE PACK_WMS_YX IS-- Author : CKZ-- Created : 2015/8/28 9:52:29-- Purpose : 同步数据-- Public type declarations,游标 退休订单TYPE retCursor IS REF CURSOR;-- RETURN vi_co_co

Oracle主键和外键详解及实用技巧

在 Oracle 数据库中,主键(Primary Key)和外键(Foreign Key)用于维护数据库表之间的数据完整性。 1. 主键(Primary Key) 主键是一列或多列,能够唯一标识表中的每一行。表中只能有一个主键,并且主键列不能为空(即 NOT NULL)。 特性: 唯一性:主键中的每一个值都是唯一的,不能重复。非空性:主键列不能包含 NULL 值。索引:Oracle 自动为

Unstructured cannot write mode RGBA as JPEG 错误解决

Unstructured cannot write mode RGBA as JPEG 错误解决 0. 错误详细1. 解决方法 0. 错误详细 Image Extraction Error: Skipping the failed imageTraceback (most recent call last):File "/root/miniconda3/envs/learn-y

Cannot read property ‘length‘ of null while opening vscode terminal

同一问题地址:Cannot read property ‘length’ of null while opening vscode terminal 问题描述 One day, 我在ubuntu 18.04下用vscode打开一个项目,并想和往常一样在vscode使用终端,发现报错Cannot read property 'length' of null。 解决 打开setting.jso