Dbca Does Not Show ASM Diskgroup Information
(Doc ID 1286434.1)
Last updated on AUGUST 28, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
*** 02-Sep-2014 ***
Purpose
This note will provide what needs to check when dbca doesn't show ASM diskgroup information when creating a database using dbca in 11gR2 single instance environment.
From 11gR2 onward, dbca checks ASM instance liveness by looking at the status of ora.asm resource. If ora.asm is in "OFFLINE" or "UNKNOWN" for any reason or has not been added as resource for HAS ( High-Availability Service), dbca doesn't show ASM diskgroup information even though ASM instance is up and running.
Symptoms
1. After ASM is selected for database files, ASM diskgroup is not shown in dbca screen.
2. v$asm_diskgroup shows a proper informtion using sqlplus after connecting to ASM instance.
3. The following message is seen in dbca trace file located in $ORACLE_BASE/cfgtoollogs/dbca/trace.log_Ora<Home_Name>
3-1. ASM resource ( ora.asm ) has been added to HAS resource but the status is "OFFLINE" or "UNKNOWN".
[AWT-EventQueue-0] [ 2011-01-22 22:53:51.903 PST ] [ASMUtils.initialize:184] Error initializing ASMUtils: PRCA-1019 : ASM asm is not running
PRCA-1019 : ASM asm is not running
..
..
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.162 PST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.176 PST ] [SQLEngine.initialize:354] m_bReaderStarted: false
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.177 PST ] [SQLEngine.initialize:358] Starting Reader Thread...
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.215 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.216 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.216 PST ] [ASMUtils.loadDiskGroups:713] ORA-01034: ORACLE not available
PRCA-1019 : ASM asm is not running
..
..
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.162 PST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.176 PST ] [SQLEngine.initialize:354] m_bReaderStarted: false
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.177 PST ] [SQLEngine.initialize:358] Starting Reader Thread...
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.215 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.216 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-22 22:53:54.216 PST ] [ASMUtils.loadDiskGroups:713] ORA-01034: ORACLE not available
3-2. ASM resource ( ora.asm ) has **NOT** been added to HAS resource.
[AWT-EventQueue-0] [ 2011-01-23 09:05:48.307 PST ] [ASMUtils.initialize:184] Error initializing ASMUtils: PRCR-1001 : Resource ora.asm does not exist
PRCR-1001 : Resource ora.asm does not exist
..
..
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.838 PST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.862 PST ] [SQLEngine.initialize:354] m_bReaderStarted: false
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.862 PST ] [SQLEngine.initialize:358] Starting Reader Thread...
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.888 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.889 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.889 PST ] [ASMUtils.loadDiskGroups:713] ORA-01034: ORACLE not available
PRCR-1001 : Resource ora.asm does not exist
..
..
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.838 PST ] [SQLEngine.initialize:317] Execing SQLPLUS/SVRMGR process...
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.862 PST ] [SQLEngine.initialize:354] m_bReaderStarted: false
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.862 PST ] [SQLEngine.initialize:358] Starting Reader Thread...
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.888 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.889 PST ] [SQLEngine.done:2148] Done called
[AWT-EventQueue-0] [ 2011-01-23 09:05:49.889 PST ] [ASMUtils.loadDiskGroups:713] ORA-01034: ORACLE not available
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 |