[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,安装11g和19C都有这个要求,可以直接忽略。但是如果内存和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选择了Private,12c开始要选ASM&Private
选ASM&Private
问题六:执行root.sh到Executing 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.sh到step 17 of 19: 'StartCluster'.时启动ORAROOTAGENT超时,最终导致执行root.sh失败。
解决方案:停掉笔记本上其他应用,释放内存,例如关闭浏览器,QQ,WPS,微信等,又多次失败反复执行root.sh后root.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/