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
I changed the file permission for Grid home with the Oracle_home.
chmod 6751
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.
Thanks alot, I met same problem, and you 've helped me to pass the trouble. You are so helpful.
ReplyDeleteYour website is really cool and this is a great inspiring article. Thank you so much.
ReplyDeleteSEO
thanks dost(friend) really it's good article.
ReplyDeleteit resolve my error in oracle 12c. HMJ