ASMCA DOES NOT SHOW DISKGROUP INFO
(Doc ID 2311278.1)
Last updated on MARCH 16, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
ASMCA does not show existing DISKGROUP info.
This problem happens when size of DISKGROUP is large than 2048TB (2PB).
And when this problem happens, you are able to see following messages in asmca log under $ORACLE_BASE/cfgtoollogs/asmca.
[Thread-66] [ 2017-07-19 14:22:16.169 JST ] [USMDiskGroupManagerRac.fetchDiskGroups:1135] DISKGROUP STATE FETCHED: 0 DG_DATA|MOUNTED
[Thread-66] [ 2017-07-19 14:22:16.169 JST ] [UsmcaLogger.logInfo:156] select gv$asm_diskgroup.GROUP_NUMBER||'|'||gv$instance.INSTANCE_NAME||'|'||gv$asm_diskgroup.NAME||'|'||round(gv$asm_diskgroup.TOTAL_MB)||'|'||round(gv$asm_diskgroup.FREE_MB)||'|'||round(gv$asm_diskgroup.USABLE_FILE_MB)||'|'||nvl(gv$asm_diskgroup.TYPE, 'DBCA_NULL')||'|'||gv$asm_diskgroup.STATE||'|'||nvl(gv$asm_diskgroup.COMPATIBILITY, 'DBCA_NULL')||'|'||nvl(gv$asm_diskgroup.DATABASE_COMPATIBILITY, 'DBCA_NULL')||'|'||ALLOCATION_UNIT_SIZE from gv$instance,gv$asm_diskgroup where gv$instance.INST_ID=gv$asm_diskgroup.INST_ID order by NAME
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] /opt/app/12.2.0/grid/bin/kfod
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] nohdr=TRUE
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] OP=GROUPS
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] status=true
[Thread-66] [ 2017-07-19 14:22:16.435 JST ] [KfodUtil.kfodOutput:386] Kfod result
[Thread-66] [ 2017-07-19 14:22:16.435 JST ] [USMDiskGroupManagerRac.fetchDiskGroups:1166] DISKGROUP FETCHED: 0 1|+ASM1|DG_DATA|3774873120|3768352908|3768352908|EXTERN|MOUNTED|12.2.0.1.0|12.1.0.0.0|4194304
[Thread-66] [ 2017-07-19 14:22:16.468 JST ] [UsmcaLogger.logException:186] SEVERE:method oracle.sysman.assistants.usmca.backend.USMDiskGroupManagerRac:fetchDiskGroups
[Thread-66] [ 2017-07-19 14:22:16.468 JST ] [UsmcaLogger.logException:187] For input string: "3774873120"
[Thread-66] [ 2017-07-19 14:22:16.468 JST ] [UsmcaLogger.logException:188] java.lang.NumberFormatException: For input string: "3774873120"
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
java.lang.Integer.parseInt(Integer.java:583)
java.lang.Integer.<init>(Integer.java:867)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManagerRac.fetchDiskGroups(USMDiskGroupManagerRac.java:1181)
[Thread-66] [ 2017-07-19 14:22:16.169 JST ] [UsmcaLogger.logInfo:156] select gv$asm_diskgroup.GROUP_NUMBER||'|'||gv$instance.INSTANCE_NAME||'|'||gv$asm_diskgroup.NAME||'|'||round(gv$asm_diskgroup.TOTAL_MB)||'|'||round(gv$asm_diskgroup.FREE_MB)||'|'||round(gv$asm_diskgroup.USABLE_FILE_MB)||'|'||nvl(gv$asm_diskgroup.TYPE, 'DBCA_NULL')||'|'||gv$asm_diskgroup.STATE||'|'||nvl(gv$asm_diskgroup.COMPATIBILITY, 'DBCA_NULL')||'|'||nvl(gv$asm_diskgroup.DATABASE_COMPATIBILITY, 'DBCA_NULL')||'|'||ALLOCATION_UNIT_SIZE from gv$instance,gv$asm_diskgroup where gv$instance.INST_ID=gv$asm_diskgroup.INST_ID order by NAME
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] /opt/app/12.2.0/grid/bin/kfod
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] nohdr=TRUE
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] OP=GROUPS
[Thread-66] [ 2017-07-19 14:22:16.245 JST ] [KfodUtil.kfodOutput:375] status=true
[Thread-66] [ 2017-07-19 14:22:16.435 JST ] [KfodUtil.kfodOutput:386] Kfod result
[Thread-66] [ 2017-07-19 14:22:16.435 JST ] [USMDiskGroupManagerRac.fetchDiskGroups:1166] DISKGROUP FETCHED: 0 1|+ASM1|DG_DATA|3774873120|3768352908|3768352908|EXTERN|MOUNTED|12.2.0.1.0|12.1.0.0.0|4194304
[Thread-66] [ 2017-07-19 14:22:16.468 JST ] [UsmcaLogger.logException:186] SEVERE:method oracle.sysman.assistants.usmca.backend.USMDiskGroupManagerRac:fetchDiskGroups
[Thread-66] [ 2017-07-19 14:22:16.468 JST ] [UsmcaLogger.logException:187] For input string: "3774873120"
[Thread-66] [ 2017-07-19 14:22:16.468 JST ] [UsmcaLogger.logException:188] java.lang.NumberFormatException: For input string: "3774873120"
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
java.lang.Integer.parseInt(Integer.java:583)
java.lang.Integer.<init>(Integer.java:867)
oracle.sysman.assistants.usmca.backend.USMDiskGroupManagerRac.fetchDiskGroups(USMDiskGroupManagerRac.java:1181)
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 |