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的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!


原文地址:https://blog.csdn.net/weixin_32525457/article/details/116317134
本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.chinasem.cn/article/620971

相关文章

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

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

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

《PostgreSQL序列(Sequence)与Oracle序列对比差异分析》PostgreSQL和Oracle都提供了序列(Sequence)功能,但在实现细节和使用方式上存在一些重要差异,... 目录PostgreSQL 序列(Sequence) 与 oracle 序列对比一 基本语法对比1.1 创建序

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

《Oracle数据库常见字段类型大全以及超详细解析》在Oracle数据库中查询特定表的字段个数通常需要使用SQL语句来完成,:本文主要介绍Oracle数据库常见字段类型大全以及超详细解析,文中通过... 目录前言一、字符类型(Character)1、CHAR:定长字符数据类型2、VARCHAR2:变长字符数

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表空间使用情况的4种方法:DBA_TABLESPACES和DBA_DATA_FILES提供基本信息,V$... 目录1. 通过 DBjavascriptA_TABLESPACES 和 DBA_DATA_FILES

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

《Pycharm安装报错:Cannotdetectalaunchconfiguration解决办法》本文主要介绍了Pycharm安装报错:Cannotdetectalaunchconfigur... 本文主要介绍了Pycharm安装报错:Cannot detect a launch configuratio

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

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

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账号