暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle 19C RAC实施方案详细说明-常见问题07

IT小Chen 2021-04-14
6472

[grid@rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose > /home/grid/pre.log

[grid@rac1 grid]$ vim /home/grid/pre.log

问题一:数据库服务器内存要求最少8G

由于本人笔记本电脑内存只有8G,每台虚拟机只分配了2.5G内存,在安装GI执行root.sh时,速度非常慢,期间出现了各种由于内存不足导致的错误。卸载安装多次,勉强将GI安装成功了,电脑内存已接近100%,后面只好重新安装11gRAC,内存占用比19C小很多。

问题二:swap要求至少2.23G,安装11g19C都有这个要求,可以直接忽略。但是如果内存和swap空间同时不足了,可能会导致安装失败。

问题三:Verifying Daemon "avahi-daemon" not configured and running ...FAILED

错误日志如下:

Verifying Daemon "avahi-daemon" not configured and running ...FAILED

rac2: PRVG-1359 : Daemon process "avahi-daemon" is configured on node "rac2"

rac2: PRVG-1360 : Daemon process "avahi-daemon" is running on node "rac2"

解决:avahi-daemon服务问题较多,可以直接关闭,安装GI时错误可以先跳过。

[root@rac1 ~]# systemctl stop avahi-daemon.socket

[root@rac2 ~]# systemctl stop avahi-daemon.socket

问题四:Verifying /dev/shm mounted as temporary file system ...FAILED

/dev/shm提示检查失败,值过小,后面启动实例时可能会失败

Verifying /dev/shm mounted as temporary file system ...FAILED

rac2: PRVE-0426 : The size of in-memory file system mounted as /dev/shm is

      "871" megabytes which is less than the required size of "2048" megabytes

      on node "rac2"

解决方案:增加操作系统内存,增大shm

[root@rac2 ~]# mount -o remount,size=2100M /dev/shm

问题五:[INS-41208] None of the available network subnets is marked for use by Oracle Automatic Storage Management(ASM)

Cause - At least one of the available network subnets should be configured for use by Oracle Automatic Storage Management (ASM).  

Action - Configure one of the available network subnets for Oracle Automatic Storage Management (ASM) use if you intend to configure Near Oracle ASM or Client Oracle ASM

问题原因:Use for选择了Private12c开始要选ASM&Private

ASM&Private

问题六:执行root.shExecuting installation step 16 of 19: 'InitConfig'时报错

[main] [ 2020-04-27 23:19:12.679 CST ] [UsmcaLogger.logInfo:156]  ORA-39511: Start of CRS resource for instance '215' failed with error:[CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'

问题现象:

[root@rac1 ~]# /u01/app/19c/grid/root.sh

ASM failed to start. Check /u01/app/grid/cfgtoollogs/asmca/asmca-200427PM111510.log for details.

2020/04/27 23:19:14 CLSRSC-184: Configuration of ASM failed

2020/04/27 23:19:26 CLSRSC-258: Failed to configure and start ASM

Died at /u01/app/19c/grid/crs/install/crsinstall.pm line 2484.

查看日志:

[root@rac1 ~]# vim /u01/app/grid/cfgtoollogs/asmca/asmca-200427PM111510.log

......

[main] [ 2020-04-27 23:15:11.923 CST ] [ASMImpl.<init>:292]  Got CRSException: PRCR-1070 : Failed to check if resource ora.asm is registered

CRS-0184 : Cannot communicate with the CRS daemon.

[main] [ 2020-04-27 23:15:11.923 CST ] [Usmca.execute:258]  PRCR-1070 : Failed to check if resource ora.asm is registered

CRS-0184 : Cannot communicate with the CRS daemon.

 

[main] [ 2020-04-27 23:18:57.938 CST ] [USMInstance.configureLocalASM:3413]  ORA-39511: Start of CRS resource for instance '215' failed with error:[CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'

 

[main] [ 2020-04-27 23:19:12.679 CST ] [UsmcaLogger.logInfo:156]  ORA-39511: Start of CRS resource for instance '215' failed with error:[CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1'

问题原因:

报错和ora.cluster_interconnect.haip有关,之前在操作系统做了网卡绑定,主备模式,怀疑操作系统级别做的网卡绑定和oracle haip冲突,导致ora.cluster_interconnect.haip启动失败,crs启动失败,最终root.sh执行失败。

解决方案:

操作系统先去掉网卡绑定。

问题七:执行root.sh时, step 17 of 19: 'StartCluster'报错。

错误日志如下:

2020/05/01 14:59:34 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

CRS-5014: Agent "ORAROOTAGENT" timed out starting process "/u01/app/19c/grid/bin/acfsload" for action "check": details at "(:CLSN00009:)" in "/u01/app/grid/diag/crs/rac1/crs/trace/ohasd_orarootagent_root.trc"

CRS-5014: Agent "ORAROOTAGENT" timed out starting process "/u01/app/19c/grid/bin/acfsload" for action "check": details at "(:CLSN00009:)" in "/u01/app/grid/diag/crs/rac1/crs/trace/ohasd_orarootagent_root.trc"

CRS-2674: Start of 'ora.asm' on 'rac1' failed

CRS-2672: Attempting to start 'ora.storage' on 'rac1'

ORA-15077: could not locate ASM instance serving a required diskgroup

CRS-5055: unable to connect to an ASM instance because no ASM instance is running in the cluster

CRS-2883: Resource 'ora.storage' failed during Clusterware stack start.

CRS-4406: Oracle High Availability Services synchronous start failed.

问题原因:笔记本电脑内存不足了,使用率接近100%,导致执行root.shstep 17 of 19: 'StartCluster'.时启动ORAROOTAGENT超时,最终导致执行root.sh失败。

解决方案:停掉笔记本上其他应用,释放内存,例如关闭浏览器,QQWPS,微信等,又多次失败反复执行root.shroot.sh终于执行成功了。

2020/05/01 16:03:45 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/05/01 16:25:17 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/05/01 16:26:24 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/05/01 16:48:14 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2020/05/01 16:59:38 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

此时笔记本内存几乎耗尽,不能在继续安装数据库软件创建实例了。

问题八:VBOX创建完共享存储后,两个节点服务器不能同时开机,后开机的会报如下错误。

不能为虚拟电脑rac1打开一个新任务。

问题原因:新加6块磁盘,5块属性改成可共享,检查发现第6块磁盘属性是普通模式,导致不能同时被两个节点打开。

解决方案:修改第6块磁盘属性可共享。

更多数据库相关学习资料,可以查看我的ITPUB博客,网名chenoracle

http://blog.itpub.net/29785807/

文章转载自IT小Chen,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论