DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Saturday, March 11, 2017

ORA-15040: diskgroup is incomplete


ASM is running but diskgroup is not mounted and its in incomplete state.

[oracle@primary bin]$ps -ef|grep asm

oracle    4222     1  0 02:19 ?        00:00:00 asm_pmon_+ASM
oracle    4224     1  0 02:19 ?        00:00:01 asm_psp0_+ASM
oracle    4226     1  2 02:19 ?        00:01:43 asm_vktm_+ASM
oracle    4230     1  0 02:19 ?        00:00:12 asm_gen0_+ASM
oracle    4232     1  0 02:19 ?        00:00:00 asm_mman_+ASM
oracle    4236     1  0 02:19 ?        00:00:00 asm_diag_+ASM
oracle    4238     1  0 02:19 ?        00:00:02 asm_dia0_+ASM
oracle    4240     1  0 02:19 ?        00:00:00 asm_dbw0_+ASM
oracle    4242     1  0 02:19 ?        00:00:00 asm_lgwr_+ASM
oracle    4244     1  0 02:19 ?        00:00:00 asm_ckpt_+ASM
oracle    4246     1  0 02:19 ?        00:00:00 asm_smon_+ASM
oracle    4248     1  0 02:19 ?        00:00:00 asm_lreg_+ASM
oracle    4250     1  0 02:19 ?        00:00:00 asm_pxmn_+ASM
oracle    4252     1  0 02:19 ?        00:00:00 asm_rbal_+ASM
oracle    4254     1  0 02:19 ?        00:00:01 asm_gmon_+ASM
oracle    4256     1  0 02:19 ?        00:00:00 asm_mmon_+ASM
oracle    4258     1  0 02:19 ?        00:00:00 asm_mmnl_+ASM
oracle    4739     1  0 02:32 ?        00:00:00 ora_asmb_prod
oracle    4743     1  0 02:32 ?        00:00:00 oracle+ASM_asmb_prod (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle    6901  3508  0 03:36 pts/0    00:00:00 grep asm

Issue:

[oracle@primary bin]$asmcmd

asmcmd> lsdg


No diskgroups as shown.

When I tried to start asm, ora.asm resource was found in intermediate state.

SQL> alter diskgroup DATA mount;
alter diskgroup data mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15040: diskgroup is incomplete

Workaround:

When I listed ASM disks on node primary,VOLSTB was not listed

[root@primary bin]# oracleasm listdisks


[root@primary bin]# oracleasm init

Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Configuring "oracleasm" to use device physical block size 
Mounting ASMlib driver filesystem: /dev/oracleasm

[root@primary bin]# oracleasm scandisks

Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "VOLSTB"

[root@primary bin]# oracleasm listdisks

VOLSTB

Now I could mount VOLSTB disk successfully

Now can I mount DATA diskgroup successfully,

SQL> alter diskgroup DATA mount;

Diskgroup altered.

asmcmd> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576     15358    15264                0           15264              0             N  DATA/

2 comments:

Anonymous said...

Your blog helped me to resolve the issue. thanks.

CIIT Noida said...

Hadoop Training Institute in Noida, The Hadoop

certification has considerable advantages in addition to the great demand for trained professionals. A certified Hadoop professional gets the

advantage in terms of payment package compared to other professionals working in the field without certification. When it comes to IJP, Hadoop

certification is compatible to advance the ladder and accelerate your career. big data hadoop training in Noida, big data hadoop Training institutes

in Noida, sector 2, oracle big data training,Oracle Training

in Noida
, big data boot camp, nosql database training, big data appliance training, exalytics training, exadata course, big data introduction,

oracle course, oracle training, big data training in Noida, ibm big data hadoop training institutes noida
Hadoop Training Institute in Noida

CONTAC CIITN:

B-12, Sector - 2, Noida, U.P
State - Uttar Pradesh U.P
Country - India
Pin Code - 201301

Phone - +917290926565
Mon - Sun: 10am - 6pm