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 DBMS_SQL.PARSE的使用方法和示例

《oracleDBMS_SQL.PARSE的使用方法和示例》DBMS_SQL是Oracle数据库中的一个强大包,用于动态构建和执行SQL语句,DBMS_SQL.PARSE过程解析SQL语句或PL/S... 目录语法示例注意事项DBMS_SQL 是 oracle 数据库中的一个强大包,它允许动态地构建和执行

PLsql Oracle 下载安装图文过程详解

《PLsqlOracle下载安装图文过程详解》PL/SQLDeveloper是一款用于开发Oracle数据库的集成开发环境,可以通过官网下载安装配置,并通过配置tnsnames.ora文件及环境变... 目录一、PL/SQL Developer 简介二、PL/SQL Developer 安装及配置详解1.下

oracle如何连接登陆SYS账号

《oracle如何连接登陆SYS账号》在Navicat12中连接Oracle11g的SYS用户时,如果设置了新密码但连接失败,可能是因为需要以SYSDBA或SYSOPER角色连接,解决方法是确保在连接... 目录oracle连接登陆NmOtMSYS账号工具问题解决SYS用户总结oracle连接登陆SYS账号

Oracle数据库如何切换登录用户(system和sys)

《Oracle数据库如何切换登录用户(system和sys)》文章介绍了如何使用SQL*Plus工具登录Oracle数据库的system用户,包括打开登录入口、输入用户名和口令、以及切换到sys用户的... 目录打开登录入口登录system用户总结打开登录入口win+R打开运行对话框,输php入:sqlp

查询Oracle数据库表是否被锁的实现方式

《查询Oracle数据库表是否被锁的实现方式》本文介绍了查询Oracle数据库表是否被锁的方法,包括查询锁表的会话、人员信息,根据object_id查询表名,以及根据会话ID查询和停止本地进程,同时,... 目录查询oracle数据库表是否被锁1、查询锁表的会话、人员等信息2、根据 object_id查询被

Oracle查询优化之高效实现仅查询前10条记录的方法与实践

《Oracle查询优化之高效实现仅查询前10条记录的方法与实践》:本文主要介绍Oracle查询优化之高效实现仅查询前10条记录的相关资料,包括使用ROWNUM、ROW_NUMBER()函数、FET... 目录1. 使用 ROWNUM 查询2. 使用 ROW_NUMBER() 函数3. 使用 FETCH FI

数据库oracle用户密码过期查询及解决方案

《数据库oracle用户密码过期查询及解决方案》:本文主要介绍如何处理ORACLE数据库用户密码过期和修改密码期限的问题,包括创建用户、赋予权限、修改密码、解锁用户和设置密码期限,文中通过代码介绍... 目录前言一、创建用户、赋予权限、修改密码、解锁用户和设置期限二、查询用户密码期限和过期后的修改1.查询用

Oracle数据库使用 listagg去重删除重复数据的方法汇总

《Oracle数据库使用listagg去重删除重复数据的方法汇总》文章介绍了在Oracle数据库中使用LISTAGG和XMLAGG函数进行字符串聚合并去重的方法,包括去重聚合、使用XML解析和CLO... 目录案例表第一种:使用wm_concat() + distinct去重聚合第二种:使用listagg,

oracle中exists和not exists用法举例详解

《oracle中exists和notexists用法举例详解》:本文主要介绍oracle中exists和notexists用法的相关资料,EXISTS用于检测子查询是否返回任何行,而NOTE... 目录基本概念:举例语法pub_name总结 exists (sql 返回结果集为真)not exists (s

Oracle的to_date()函数详解

《Oracle的to_date()函数详解》Oracle的to_date()函数用于日期格式转换,需要注意Oracle中不区分大小写的MM和mm格式代码,应使用mi代替分钟,此外,Oracle还支持毫... 目录oracle的to_date()函数一.在使用Oracle的to_date函数来做日期转换二.日