DBCA & DBUA Does not Identify Disk Groups When DIAG_ADR_ENABLED=OFF In sqlnet.ora
(Doc ID 1969684.1)
Last updated on FEBRUARY 14, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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=<Grid Home Directory>
[Thread-101] [ 2015-02-08 10:50:05.784 CET ] [HAUtils.getConfiguredGridHome:1345] Configured Grid Infrastructure home: <Grid Home Directory>
[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] <Grid Home Directory>/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
[Thread-101] [ 2015-02-08 10:50:05.784 CET ] [HAUtils.getConfiguredGridHome:1345] Configured Grid Infrastructure home: <Grid Home Directory>
[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] <Grid Home Directory>/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.
[ora@test ~]$ <Grid Home Directory>/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
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |