Applies to:
Oracle Database Configuration Assistant – Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.
Symptoms
When DBCA is launched by the oracle user OS account, the process gets to the screen to select the ASM disk groups but no Disk Groups are available.
If we launch DBCA from Grid user account , the disk groups are available.
Cause
File permissions in <Grid_home>/bin/oracle executable not set properly.
Solution
As root, change the file permissions of the oracle executable under Grid_Home/bin to 6751:
# cd <Grid_Home>/bin
# chmod 6751 oracle
# ls -l oracle
-rwsr-s–x 1 grid oinstall 173515905 May 21 17:04 oracle
This is the setuid bit, and this must be set in order for users, other than “Grid” user to have it work.