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

2024-01-19 02:10
文章标签 oracle cluster services cannot crs ready communicate 4535

本文主要是介绍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 数据库数据操作如何精通 INSERT, UPDATE, DELETE

Oracle 数据库数据操作如何精通 INSERT, UPDATE, DELETE

《Oracle数据库数据操作如何精通INSERT,UPDATE,DELETE》在Oracle数据库中,对表内数据进行增加、修改和删除操作是通过数据操作语言来完成的,下面给大家介绍Oracle数... 目录思维导图一、插入数据 (INSERT)1.1 插入单行数据，指定所有列的值语法：1.2 插入单行数据，指
阅读更多...
Redis Cluster模式配置

Redis Cluster模式配置

《RedisCluster模式配置》：本文主要介绍RedisCluster模式配置,本文给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友参考下吧... 目录分片 一、分片的本质与核心价值二、分片实现方案对比 ‌三、分片算法详解1. ‌范围分片（顺序分片）‌2. ‌哈希分片3. ‌虚
阅读更多...
Oracle修改端口号之后无法启动的解决方案

Oracle修改端口号之后无法启动的解决方案

《Oracle修改端口号之后无法启动的解决方案》Oracle数据库更改端口后出现监听器无法启动的问题确实较为常见,但并非必然发生,这一问题通常源于​​配置错误或环境冲突​​,而非端口修改本身,以下是系... 目录一、问题根源分析​​​二、保姆级解决方案​​​​步骤1：修正监听器配置文件 (listener.
阅读更多...
Oracle 通过 ROWID 批量更新表的方法

Oracle 通过 ROWID 批量更新表的方法

《Oracle通过ROWID批量更新表的方法》在Oracle数据库中,使用ROWID进行批量更新是一种高效的更新方法,因为它直接定位到物理行位置,避免了通过索引查找的开销,下面给大家介绍Orac... 目录oracle 通过 ROWID 批量更新表ROWID 基本概念性能优化建议性能UoTrFPH优化建议注
阅读更多...
PostgreSQL 序列(Sequence) 与 Oracle 序列对比差异分析

PostgreSQL 序列(Sequence) 与 Oracle 序列对比差异分析

《PostgreSQL序列(Sequence)与Oracle序列对比差异分析》PostgreSQL和Oracle都提供了序列(Sequence)功能,但在实现细节和使用方式上存在一些重要差异,... 目录PostgreSQL 序列(Sequence) 与 oracle 序列对比一 基本语法对比1.1 创建序
阅读更多...
Oracle数据库常见字段类型大全以及超详细解析

Oracle数据库常见字段类型大全以及超详细解析

《Oracle数据库常见字段类型大全以及超详细解析》在Oracle数据库中查询特定表的字段个数通常需要使用SQL语句来完成,：本文主要介绍Oracle数据库常见字段类型大全以及超详细解析,文中通过... 目录前言一、字符类型（Character）1、CHAR：定长字符数据类型2、VARCHAR2：变长字符数
阅读更多...
Oracle存储过程里操作BLOB的字节数据的办法

Oracle存储过程里操作BLOB的字节数据的办法

《Oracle存储过程里操作BLOB的字节数据的办法》该篇文章介绍了如何在Oracle存储过程中操作BLOB的字节数据,作者研究了如何获取BLOB的字节长度、如何使用DBMS_LOB包进行BLOB操作... 目录一、缘由二、办法2.1 基本操作2.2 DBMS_LOB包2.3 字节级操作与RAW数据类型2.
阅读更多...
查看Oracle数据库中UNDO表空间的使用情况(最新推荐)

查看Oracle数据库中UNDO表空间的使用情况(最新推荐)

《查看Oracle数据库中UNDO表空间的使用情况(最新推荐)》Oracle数据库中查看UNDO表空间使用情况的4种方法：DBA_TABLESPACES和DBA_DATA_FILES提供基本信息,V$... 目录1. 通过 DBjavascriptA_TABLESPACES 和 DBA_DATA_FILES
阅读更多...
Pycharm安装报错:Cannot detect a launch configuration解决办法

Pycharm安装报错:Cannot detect a launch configuration解决办法

《Pycharm安装报错:Cannotdetectalaunchconfiguration解决办法》本文主要介绍了Pycharm安装报错:Cannotdetectalaunchconfigur... 本文主要介绍了Pycharm安装报错:Cannot detect a launch configuratio
阅读更多...
Oracle登录时忘记用户名或密码该如何解决

Oracle登录时忘记用户名或密码该如何解决

《Oracle登录时忘记用户名或密码该如何解决》：本文主要介绍如何在Oracle12c中忘记用户名和密码时找回或重置用户账户信息,文中通过代码介绍的非常详细,对同样遇到这个问题的同学具有一定的参... 目录一、忘记账户：二、忘记密码：三、详细情况情况 1：1.1. 登录到数据库1.2. 查看当前用户信息1.
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2