Dbca Does Not Show ASM Diskgroup Information (Doc ID 1286434.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
Checked for relevance on *** 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




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



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