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

Leave a Reply

Your email address will not be published. Required fields are marked *