how to restore OCR after complete loss of single OCR diskgroup

crs daemon was not able to start as my ocr diskgroup was not mounted. I logged in to asm instance.

But i was able to mount my other diskgroups

also checked using asmcmd lsdg –discovery command

came to know after checking alertlog CRS diskgroup had corrupted block.

 

referring doc id 1062983.1 i was able to restore ocr to a new disk with same diskgroup name

please feel free to ask me at sunil@sunilthetechfreak.com

 

Upgrade non asm oracle database 11.2.0.1 to 11.2.0.4 using dbua

Step by step guide to upgrade non asm database 11.2.0.1 to 11.2.0.4 using dbua Download

ORA-28000 account locked error while creating database using dbca on Grid Infrastructure with ASM on Standalone Server

My environment details
OS : OEL 6.5 64bit
Database version : 11.2.0.4
grid infrastructure with asm on Standalone Server

I had two issues while creating database using dbca

1) I was not able to see the diskgroup at step 6 after selecting Automatic storage management, i selected use oracle-managed files
and at database area after clicking the browse button no diskgroup was shown in that area it was blank

Cause of problem :
oracle user was not part of asmdba group

Solution :
I added oracle user to asmdba group as i missed to add oracle user to asmdba group

usermod -G asmdba oracle

after that i could see the diskgroup after selecting browse button

2) ORA-28000 account locked error after it completes 43% while creating database

Cause of problem :
oracle user was not part of dba group

as you can see from the output

[oracle@oralab1 cfgtoollogs]$ id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54324(asmdba)

[oracle@oralab1 cfgtoollogs]$ id grid

uid=54322(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(asmadmin),54324(asmdba),54325(asmoper)

Solution :
usermod -a -G dba oracle

after adding oracle user to dba group database creation was successful