问题概述
DBCA建库时，在选择datafile存放路径时，已经创建好的磁盘组不显示
问题分析
1. 查看DBCA trace日志
DBCA trace日志显示在执行kfod时报错。kfod是ASM自带的工具，kfod主要用于在操作系统级别查看ASM磁盘信息。
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.374 CST ] [RuntimeExec.runCommand:307] runCommand: process returns 0
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [RuntimeExec.runCommand:334] RunTimeExec: error>
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [RuntimeExec.runCommand:360] Returning from RunTimeExec.runCommand
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [CmdToolUtil.doexecuteLocally:1507] retval = 0
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [CmdToolUtil.doexecuteLocally:1508] exitval = 0
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [CmdToolUtil.doexecuteLocally:1509] rtErrLength = 0
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [KfodUtil.kfodOutput:382] /u01/app/19c/grid/bin/kfod
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [KfodUtil.kfodOutput:382] nohdr=TRUE
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [KfodUtil.kfodOutput:382] OP=GROUPS
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [KfodUtil.kfodOutput:382] status=true
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [KfodUtil.kfodOutput:382] asmcompatibility=true dbcompatibility=true
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.375 CST ] [OsUtilsBase.execProgInheritAddEnvNReturnOutput:2262] API execProgInheritAddEnvReturnOutput invoked
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.394 CST ] [OsUtilsBase.execProgInheritAddEnvNReturnOutput:2268] Exec prog return code: 1
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.394 CST ] [KfodUtil.kfodOutput:393] Kfod result
Error 49802 initializing ADR at /u01/app/grid
ERROR!!! could not initialize the diag context
[AWT-EventQueue-0] [ 2023-07-10 19:27:45.394 CST ] [KfodUtil.getDiskgroupsWithCompatibilityValues:609] diskgroup details using kfod ADR Error 49802 initializing /u01/app/grid at
INFO: Jul 10, 2023 7:27:45 PM oracle.assistants.common.lib.asm.ASMInfo load
INFO: Loading the diskgroups. exception using kfodError retrieving diskgroup using kfod utility, For input string: "Error"
INFO: Jul 10, 2023 7:27:45 PM oracle.assistants.common.view.DiskGroupTableModel setDiskGroups
INFO: Empty diskGroup list is specified
2. 验证kfod
手工执行kfod，grid用户下正常
[grid@zdb001 ~]$ kfod status=TRUE asm_diskstring='/dev/mapper/ZDATA*' disks=all dscvgroup=TRUE OP=all
--------------------------------------------------------------------------------
Disk Size Header Path Disk Group User Group
================================================================================
1: 51200 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_001 OCRDG grid asmadmin
2: 51200 MB CANDIDATE /dev/mapper/ZDATA_FDISK_CELL01_002 # grid asmadmin
3: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_003 DATA grid asmadmin
4: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_004 DATA grid asmadmin
5: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_005 DATA grid asmadmin
6: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_006 DATA grid asmadmin
7: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_007 DATA grid asmadmin
8: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_008 DATA grid asmadmin
9: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_009 DATA grid asmadmin
10: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_010 DATA grid asmadmin
11: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_011 DATA grid asmadmin
12: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_012 DATA grid asmadmin
13: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_013 DATA grid asmadmin
14: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_014 DATA grid asmadmin
15: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_015 DATA grid asmadmin
16: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_016 DATA grid asmadmin
17: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_017 DATA grid asmadmin
18: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_018 DATA grid asmadmin
19: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_019 DATA grid asmadmin
20: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_020 DATA grid asmadmin
21: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_021 FRA grid asmadmin
22: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL01_022 FRA grid asmadmin
23: 51200 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_001 OCRDG grid asmadmin
24: 51200 MB CANDIDATE /dev/mapper/ZDATA_FDISK_CELL02_002 # grid asmadmin
25: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_003 DATA grid asmadmin
26: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_004 DATA grid asmadmin
27: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_005 DATA grid asmadmin
28: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_006 DATA grid asmadmin
29: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_007 DATA grid asmadmin
30: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_008 DATA grid asmadmin
31: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_009 DATA grid asmadmin
32: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_010 DATA grid asmadmin
33: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_011 DATA grid asmadmin
34: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_012 DATA grid asmadmin
35: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_013 DATA grid asmadmin
36: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_014 DATA grid asmadmin
37: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_015 DATA grid asmadmin
38: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_016 DATA grid asmadmin
39: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_017 DATA grid asmadmin
40: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_018 DATA grid asmadmin
41: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_019 DATA grid asmadmin
42: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_020 DATA grid asmadmin
43: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_021 FRA grid asmadmin
44: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL02_022 FRA grid asmadmin
45: 51200 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_001 OCRDG grid asmadmin
46: 51200 MB CANDIDATE /dev/mapper/ZDATA_FDISK_CELL03_002 # grid asmadmin
47: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_003 DATA grid asmadmin
48: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_004 DATA grid asmadmin
49: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_005 DATA grid asmadmin
50: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_006 DATA grid asmadmin
51: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_007 DATA grid asmadmin
52: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_008 DATA grid asmadmin
53: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_009 DATA grid asmadmin
54: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_010 DATA grid asmadmin
55: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_011 DATA grid asmadmin
56: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_012 DATA grid asmadmin
57: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_013 DATA grid asmadmin
58: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_014 DATA grid asmadmin
59: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_015 DATA grid asmadmin
60: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_016 DATA grid asmadmin
61: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_017 DATA grid asmadmin
62: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_018 DATA grid asmadmin
63: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_019 DATA grid asmadmin
64: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_020 DATA grid asmadmin
65: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_021 FRA grid asmadmin
66: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL03_022 FRA grid asmadmin
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
================================================================================
因为DBCA是在oracle用户下执行，所以还需要在oracle用户下确认
用oracle执行的时候，报DBCA trace中一样的错误
[oracle@zdb001 ~]$ /u01/app/19c/grid/bin/kfod status=true disks=all
Error 49802 initializing ADR at /u01/app/grid
ERROR!!! could not initialize the diag context
换一套正常的RAC在oracle用户下执行，可以正常显示
[oracle@zdb011 ~]$ /u01/app/19c/grid/bin/kfod status=true disks=all
--------------------------------------------------------------------------------
Disk Size Header Path User Group
================================================================================
1: 51200 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_001 grid asmadmin
2: 51200 MB CANDIDATE /dev/mapper/ZDATA_FDISK_CELL11_002 grid asmadmin
3: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_003 grid asmadmin
4: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_004 grid asmadmin
5: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_005 grid asmadmin
6: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_006 grid asmadmin
7: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_007 grid asmadmin
8: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_008 grid asmadmin
9: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_009 grid asmadmin
10: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_010 grid asmadmin
11: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_011 grid asmadmin
12: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_012 grid asmadmin
13: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_013 grid asmadmin
14: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_014 grid asmadmin
15: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_015 grid asmadmin
16: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_016 grid asmadmin
17: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_017 grid asmadmin
18: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_018 grid asmadmin
19: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_019 grid asmadmin
20: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_020 grid asmadmin
21: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_021 grid asmadmin
22: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL11_022 grid asmadmin
23: 51200 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_001 grid asmadmin
24: 51200 MB CANDIDATE /dev/mapper/ZDATA_FDISK_CELL12_002 grid asmadmin
25: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_003 grid asmadmin
26: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_004 grid asmadmin
27: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_005 grid asmadmin
28: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_006 grid asmadmin
29: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_007 grid asmadmin
30: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_008 grid asmadmin
31: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_009 grid asmadmin
32: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_010 grid asmadmin
33: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_011 grid asmadmin
34: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_012 grid asmadmin
35: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_013 grid asmadmin
36: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_014 grid asmadmin
37: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_015 grid asmadmin
38: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_016 grid asmadmin
39: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_017 grid asmadmin
40: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_018 grid asmadmin
41: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_019 grid asmadmin
42: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_020 grid asmadmin
43: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_021 grid asmadmin
44: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL12_022 grid asmadmin
45: 51200 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_001 grid asmadmin
46: 51200 MB CANDIDATE /dev/mapper/ZDATA_FDISK_CELL13_002 grid asmadmin
47: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_003 grid asmadmin
48: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_004 grid asmadmin
49: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_005 grid asmadmin
50: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_006 grid asmadmin
51: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_007 grid asmadmin
52: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_008 grid asmadmin
53: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_009 grid asmadmin
54: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_010 grid asmadmin
55: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_011 grid asmadmin
56: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_012 grid asmadmin
57: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_013 grid asmadmin
58: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_014 grid asmadmin
59: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_015 grid asmadmin
60: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_016 grid asmadmin
61: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_017 grid asmadmin
62: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_018 grid asmadmin
63: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_019 grid asmadmin
64: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_020 grid asmadmin
65: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_021 grid asmadmin
66: 1817600 MB MEMBER /dev/mapper/ZDATA_FDISK_CELL13_022 grid asmadmin
--------------------------------------------------------------------------------
ORACLE_SID ORACLE_HOME
从上面的分析结果来看，问题肯定是由于kfod在oracle用户下无法执行导致。
3.对比kfod权限
对比kfod文件的权限，未发现异常。
[oracle@zdb001 ~]$ ls -l /u01/app/19c/grid/bin/kfod
-rwxr-xr-x 1 root oinstall 11541 Jul 9 16:07 /u01/app/19c/grid/bin/kfod
[oracle@zdb011 ~]$ ls -l /u01/app/19c/grid/bin/kfod
-rwxr-xr-x 1 root oinstall 11541 Jul 9 17:01 /u01/app/19c/grid/bin/kfod
4.strace跟踪kfod
[oracle@zdb001 ~]$ strace -o /tmp/kfod.trc /u01/app/19c/grid/bin/kfod status=true disks=all
跟踪结果来看，最终也是报Error 49802的错误，但是最终是哪里导致的，仅从trace中仍不容易看出来。
open("/u01/app/19c/grid/rdbms/mesg/diaus.msb", O_RDONLY) = 5
fcntl(5, F_SETFD, FD_CLOEXEC) = 0
lseek(5, 0, SEEK_SET) = 0
read(5, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 280) = 280
lseek(5, 512, SEEK_SET) = 512
read(5, ":\275\371\311\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(5, 1024, SEEK_SET) = 1024
read(5, "\357^\375^\n_\30_\"_*_4_?_J_T___i_r_|_\207_\240_"..., 512) = 512
lseek(5, 1536, SEEK_SET) = 1536
read(5, "D\275L\275W\275a\275i\275t\275~\275\341\275<\276q\276{\276\250\276\16\277\30\277#\277+\277"..., 156) = 156
brk(NULL) = 0x662000
brk(0x684000) = 0x684000
stat("/etc/sysconfig/64bit_strstr_via_64bit_strstr_sse2_unaligned", {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
stat("/u01/app/grid/diag/kfod/zdb001/kfod/log", {st_mode=S_IFDIR|0755, st_size=48, ...}) = 0
geteuid() = 54321
getegid() = 54421
geteuid() = 54321
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 6
connect(6, {sa_family=AF_UNIX, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(6) = 0
socket(AF_UNIX, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 6
connect(6, {sa_family=AF_UNIX, sun_path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(6) = 0
open("/etc/nsswitch.conf", O_RDONLY|O_CLOEXEC) = 6
fstat(6, {st_mode=S_IFREG|0644, st_size=1949, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ffff7ff4000
read(6, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1949
read(6, "", 4096) = 0
close(6) = 0
munmap(0x7ffff7ff4000, 4096) = 0
open("/u01/app/19c/grid/lib/libnss_files.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open("/u01/app/19c/grid/lib/libnss_files.so.2", O_RDONLY|O_CLOEXEC) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY|O_CLOEXEC) = 6
fstat(6, {st_mode=S_IFREG|0644, st_size=50421, ...}) = 0
mmap(NULL, 50421, PROT_READ, MAP_PRIVATE, 6, 0) = 0x7ffff7fe8000
close(6) = 0
open("/lib64/libnss_files.so.2", O_RDONLY|O_CLOEXEC) = 6
read(6, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260!\0\0\0\0\0\0"..., 832) = 832
fstat(6, {st_mode=S_IFREG|0755, st_size=61568, ...}) = 0
mmap(NULL, 2173048, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 6, 0) = 0x7fffef70a000
mprotect(0x7fffef716000, 2093056, PROT_NONE) = 0
mmap(0x7fffef915000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 6, 0xb000) = 0x7fffef915000
mmap(0x7fffef917000, 22648, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fffef917000
close(6) = 0
mprotect(0x7fffef915000, 4096, PROT_READ) = 0
munmap(0x7ffff7fe8000, 50421) = 0
open("/etc/passwd", O_RDONLY|O_CLOEXEC) = 6
fstat(6, {st_mode=S_IFREG|0644, st_size=1449, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ffff7ff4000
read(6, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1449
close(6) = 0
munmap(0x7ffff7ff4000, 4096) = 0
brk(NULL) = 0x684000
brk(0x6ac000) = 0x6ac000
fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7ffff7ff4000
write(1, "Error 49802 initializing ADR at "..., 46) = 46
write(1, "ERROR!!! could not initialize th"..., 47) = 47
close(5) = 0
munmap(0x7ffff7f90000, 143360) = 0
exit_group(1) = ?
+++ exited with 1 +++
这时候使用对比工具是比较有效的方法。
将正常的kfod执行过程也跟踪出来，通过工具对比差异，从下图的结果我们可以很直观的看出来，/u01/app/grid/diag/kfod/zdb001/kfod/log的权限存在差异。
通过权限对比，确认问题出在log目录的权限上。
[oracle@zdb001 ~]$ ls -l /u01/app/grid/diag/kfod/zdb001/kfod/log
total 0
drwxr-xr-x 2 grid oinstall 6 Jul 9 16:03 attention
drwxr-xr-x 2 grid oinstall 6 Jul 9 16:03 debug
drwxr-xr-x 2 grid oinstall 6 Jul 9 16:03 test
[oracle@zdb011 ~]$ ls -l /u01/app/grid/diag/kfod/zdb011/kfod/log
total 0
drwxrwxr-x 2 grid oinstall 6 Jul 9 16:59 attention
drwxrwxr-x 2 grid oinstall 6 Jul 9 16:59 debug
drwxrwxr-x 2 grid oinstall 6 Jul 9 16:59 test
问题原因
原因是$ORACLE_BASE/diag/kfod/zdb001/kfod/log的权限不对导致。
解决方案
1. 修改权限
[grid@zdb001 ~]$ chmod -R 775 $ORACLE_BASE/diag/kfod
[grid@zdb001 ~]$ ls -l /u01/app/grid/diag/kfod/zdb001/kfod/log
total 0
drwxrwxr-x 2 grid oinstall 6 Jul 9 16:03 attention
drwxrwxr-x 2 grid oinstall 6 Jul 9 16:03 debug
drwxrwxr-x 2 grid oinstall 6 Jul 9 16:03 test
2. 重新安装
修改后磁盘组能正常显示
参考文档
Kfod Failed With "Error 49802 Initializing ADR" and DBCA failed to list asm diskgroups (Doc ID 2457752.1)
类似问题的文档
（1）ASM Diskgroup Can Not Be Shown When Creating Database With DBCA (Doc ID 1269734.1)
Cause :
1. Incorrect permission setting for oracle user
2. ASM instance was not started or diskgroups are not mounted or asm parameter asm_diskstring was not set(or incorrect)
3. The diskgroup resources are not online.
4. The permission setting for the asm devices are incorrect.
5. The oracle executable under <Grid Infrastructure Home>/bin has incorrect permission settings.
6. the file system for grid home was mounted with option 'nosuid'.
7. incorrect crs_home setting in file olr.loc.
8. "DIAG_ADR_ENABLED" is set to OFF (non-default) but environment variable "ORA_CLIENTTRACE_DIR" is not set in the sqlnet.ora in rdbms home. This only apply to version 12c.
（2）12c DBCA could not see ASM disk groups in ‘Select Disk Group’ Tab. (Doc ID 1952685.1)
Cause 1: Due to wrong configuration in sqlnet.ora
Cause 2: DIAG folder under GRID_BASE location do not have correct ownership/permission
（3）ASM Diskgroup is not Showing Up in the DBCA (Doc ID 2557164.1)
CAUSE 1: This issue is caused by the incorrect setting of NLS_LANG.
CAUSE 2: SOLUTION： Add the group asmdba to the owner of the DB home.
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
