Tuesday, December 18, 2012

Database installation gets fail in RAC

Once I've encountered a problem while installation of  Oracle Database 11gR2 using DBCA utility in RAC.
I was getting the alert as below:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted

























Findings:
I suspected that might be diskgroup is not mounted.
I checked by login into the "+ASM1" and "+ASM2" with the 'sysasm' user on both the node server.
ASM instances were running and 'v$asm_diskgroup' and 'v$asm_disk' dynamic views were no revealing any error at all.
I used ASMCMD too for the same and still dint find anything wrong which says that diskgroup "DATA" is not mounted.

Solution:
Checked the permission of $ORACLE_HOME and $GRID_HOME
which was not same.
It was as below
#ls -al $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle dba xxxx Dec 12 13:07 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

#ls -al /u01/app/11.2.0/grid/bin/oracle
-rwxrwxr-x 1 oracle oinstall 184286237 Dec 12 13:14 /u01/app/11.2.0/grid/bin/oracle

I changed the file permission for Grid home with the Oracle_home.
chmod 6751 /u01/app/11.2.0/grid/bin/oracle

it will change its permission to "-rwsr-s--x"

After doing this my Database installation get completed.

3 comments:

  1. Thanks alot, I met same problem, and you 've helped me to pass the trouble. You are so helpful.

    ReplyDelete
  2. Your website is really cool and this is a great inspiring article. Thank you so much.
    SEO

    ReplyDelete
  3. thanks dost(friend) really it's good article.
    it resolve my error in oracle 12c. HMJ

    ReplyDelete