DBCA & DBUA Does not Identify Disk Groups When DIAG_ADR_ENABLED=OFF In sqlnet.ora (Doc ID 1969684.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

While running DBUA (12.1.0.2) for database upgrade getting the below error

[Thread-101] [ 2015-02-08 10:50:05.784 CET ] [UnixSystem.getCRSHome:2930]  crs_home=/oracle/GRD_12C/12.1.0
[Thread-101] [ 2015-02-08 10:50:05.784 CET ] [HAUtils.getConfiguredGridHome:1345]  Configured Grid Infrastructure home: /oracle/GRD_12C/12.1.0
[Thread-101] [ 2015-02-08 10:50:05.784 CET ] [ASMUtils.initialize:247]  ASMHome: /oracle/GRD_12C/12.1.0
[Thread-101] [ 2015-02-08 10:50:05.815 CET ] [KfodUtil.kfodOutput:361]  /oracle/GRD_12C/12.1.0/bin/kfod
[Thread-101] [ 2015-02-08 10:50:05.815 CET ] [KfodUtil.kfodOutput:361]  nohdr=TRUE
[Thread-101] [ 2015-02-08 10:50:05.815 CET ] [KfodUtil.kfodOutput:361]  OP=GROUPS
[Thread-101] [ 2015-02-08 10:50:05.815 CET ] [KfodUtil.kfodOutput:361]  status=true
[Thread-101] [ 2015-02-08 10:50:05.815 CET ] [KfodUtil.kfodOutput:361]  asmcompatibility=true dbcompatibility=true
[Thread-101] [ 2015-02-08 10:50:12.628 CET ] [KfodUtil.kfodOutput:372]  Kfod result
kgfnInitDiag: diagctx=0xb94e30
kgfn_get_beqinfo: publen=84, vlen=16
KGFCHECK kgfnStmtExecute01c: ret == OCI_SUCCESS: FAILED at kgfn.c:3413
KFOD returned no data
[Thread-101] [ 2015-02-08 10:50:12.628 CET ] [ASMUtils.loadDiskGroups:1044]  Loading  the diskgroups. exception using kfod
kgfnInitDiag: diagctx=0xb94e30
kgfn_get_beqinfo: publen=84, vlen=16
KGFCHECK kgfnStmtExecute01c: ret == OCI_SUCCESS: FAILED at kgfn.c:3413
KFOD returned no data

 When run this command manually,it's working fine.

[oraplin1@muc-ora-04 ~]$ /oracle/GRD_12C/12.1.0/bin/kfod nohdr=true op=groups status=true asmcompatibility=true dbcompatibility=true verbose=true 
kgfnInitDiag: diagctx=0x13aae40
kgfn_get_beqinfo: publen=84, vlen=16
     2045        192 NORMAL FRA 11.2.0.3.0 11.2.0.3.0 
    20478       6309 NORMAL DATA 11.2.0.3.0 11.2.0.3.0 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms