Symptoms:
Error starting database with diskgroup is incomplete error.
Try to start the database.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0055E+10 bytes
Fixed Size 2261888 bytes
Variable Size 3858762880 bytes
Database Buffers 6174015488 bytes
Redo Buffers 19742720 bytes
ORA-00205: error in identifying control file, check alert log for more info
Error in alert log:
ALTER DATABASE MOUNT
This instance was first to mount
NOTE: Loaded library: System
ORA-15025: could not open disk "/dev/mapper/mpathe"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/mpathg"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
ORA-15025: could not open disk "/dev/mapper/mpathi"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
SUCCESS: diskgroup DATA was dismounted
ERROR: diskgroup DATA was not mounted
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA/ebstest/controlfile/control01.ctl'
ORA-17503: ksfdopn:2 Failed to open file +DATA/ebstest/controlfile/control01.ctl
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-205 signalled during: ALTER DATABASE MOUNT...
Cause:
The OS group in the oracle RDBMS HOME binary is not correct, it should be asmadmin instead of oinstall:
[oraebstest@ebstestdb-01 dbs]$ ls -l /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle
-rwsr-s--x 1 oraebstest oinstall 240054958 Oct 6 13:34 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle
Solution:
Correct the permissions in the RDBMS HOME:
Execute the next steps as grid OS user:
[oragrid@ebstestdb-01 ~]$ cd $ORACLE_HOME/bin
[oragrid@ebstestdb-01 bin]$ ./osdbagrp
asmdba
[oragrid@ebstestdb-01 bin]$ ./setasmgidwrap o=/u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle
[oragrid@ebstestdb-01 bin]$ ./osdbagrp
asmdba
[oragrid@ebstestdb-01 ~]$ ls -l /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle
-rwsr-s--x 1 oraebstest asmadmin 240054958 Oct 6 13:34 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle