
环境说明:
DB:Oracle 11.2.0.4.0 RACOS:Redhat7.6
操作:
Redhat7.6系统上安装Oracle11gRAC
问题现象:
当在第一个节点执行root.sh时,报错如下:
Disk Group XXX_CJCDB_OCR creation failed with the following message:ORA-15018:diskgroup cannot be createdORA-15020:discoverd duplicate ASM disk "XXX_CJCDB_OCR_0002"
问题分析:
OCR磁盘组创建失败,需要查看ASM日志:
Reconfiguration completeMon Apr 19 17:44:28 2021LCK0 started with pid=22, OS id=7558ORACLE_BASE from environment = oracle/gridMon Apr 19 17:44:29 2021SQL> ALTER DISKGROUP ALL MOUNTDiskgroup used for OCR is:XXX_CJCDB_OCRNOTE: cache registered group XXX_CJCDB_OCR number=1 incarn=0x588274a5NOTE: cache began mount (first) of group XXX_CJCDB_OCR number=1 incarn=0x588274a5ERROR: no read quorum in group: required 2, found 0 disksNOTE: cache dismounting (clean) group 1/0x588274A5 (XXX_CJCDB_OCR)NOTE: messaging CKPT to quiesce pins Unix process pid: 7561, image: oracle@xxx-cjcdb01 (TNS V1-V3)NOTE: dbwr not being msg'd to dismountNOTE: lgwr not being msg'd to dismountNOTE: cache dismounted group 1/0x588274A5 (XXX_CJCDB_OCR)NOTE: cache ending mount (fail) of group XXX_CJCDB_OCR number=1 incarn=0x588274a5NOTE: cache deleting context for group XXX_CJCDB_OCR 1/0x588274a5GMON dismounting group 1 at 2 for pid 23, osid 7561ERROR: diskgroup XXX_CJCDB_OCR was not mountedWARNING: Disk Group XXX_CJCDB_OCR containing configured OCR is not mountedORA-15032: not all alterations performedORA-15017: diskgroup "XXX_CJCDB_OCR" cannot be mountedORA-15063: ASM discovered an insufficient number of disks for diskgroup "XXX_CJCDB_OCR"ERROR: ALTER DISKGROUP ALL MOUNTMon Apr 19 17:44:29 2021NOTE: No asm libraries found in the systemMon Apr 19 17:44:29 2021ALTER SYSTEM SET asm_diskstring='/dev/' SCOPE=MEMORY SID='*';ASM Health Checker found 1 new failuresSQL> CREATE DISKGROUP XXX_CJCDB_OCR NORMAL REDUNDANCY DISK '/dev/asm-ocr1','/dev/asm-ocr2','/dev/asm-ocr3' ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='1M' /* ASMCA */NOTE: Assigning number (1,0) to disk (/dev/asm-ocr1)NOTE: Assigning number (1,1) to disk (/dev/asm-ocr2)NOTE: Assigning number (1,2) to disk (/dev/asm-ocr3)NOTE: initializing header on grp 1 disk XXX_CJCDB_OCR_0000NOTE: initializing header on grp 1 disk XXX_CJCDB_OCR_0001NOTE: initializing header on grp 1 disk XXX_CJCDB_OCR_0002WARNING: detected duplicate paths to the same disk:'/dev/asm-ocr3' and'/dev/sdd'More trace information dumped to '/oracle/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_7592.trc'WARNING: detected duplicate paths to the same disk:'/dev/asm-ocr1' and'/dev/sdb'More trace information dumped to '/oracle/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_7592.trc'WARNING: detected duplicate paths to the same disk:'/dev/asm-ocr2' and'/dev/sdc'More trace information dumped to '/oracle/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_7592.trc'NOTE: erasing header on grp 1 disk XXX_CJCDB_OCR_0000NOTE: erasing header on grp 1 disk XXX_CJCDB_OCR_0001NOTE: erasing header on grp 1 disk XXX_CJCDB_OCR_0002GMON dismounting group 1 at 3 for pid 23, osid 7592NOTE: Disk XXX_CJCDB_OCR_0000 in mode 0x7e marked for de-assignmentNOTE: Disk XXX_CJCDB_OCR_0001 in mode 0x7e marked for de-assignmentNOTE: Disk XXX_CJCDB_OCR_0002 in mode 0x7e marked for de-assignmentERROR: diskgroup XXX_CJCDB_OCR was not createdORA-15018: diskgroup cannot be createdORA-15020: discovered duplicate ASM disk "XXX_CJCDB_OCR_0002"ERROR: CREATE DISKGROUP XXX_CJCDB_OCR NORMAL REDUNDANCY DISK '/dev/asm-ocr1','/dev/asm-ocr2','/dev/asm-ocr3' ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='1M' /* ASMCA */
可以看到多个路径指向同一块磁盘,例如/dev/asm-ocr1和/dev/sdb指向了同一块磁盘。确实是指向的同一块物理磁盘,因为/dev/asm-ocr1是通过udev绑定sdb得来的。但在创建磁盘组时,oracle应该只识别到/dev/asm-ocr1才对,为什么识别到了两个?WARNING: detected duplicate paths to the same disk:因为在安装grid时,选择磁盘组路径时,本应选择/dev/asm-*,却错误的选择了/dev,导致了上面的错误。
[grid@xxx-cjcdb01 ~]$ export ORACLE_SID=+ASM1[grid@xxx-cjcdb01 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 19 18:07:17 2021Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> show parameter asm_diskstringNAME TYPE VALUE------------------------------------ ----------- ------------------------------asm_diskstring string /dev/
解决方案:
1 清空CRS配置perl $GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig –force2 删除对应目录和文件重新安装grid
###2021-04-24 17:00 chenjuchao###

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




