DBCA Does Not Display ASM Disk Groups

 

DBCA Does Not Display ASM Disk Groups

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.

I get this problem when trying to create a database with a different user than grid user ie oracle

I’ve installed Grid infrastructure with user grid, and I was trying to create a database with user oracle (who’s the owner of oracle rdbms). But during this installation I wasn’t able to see any of my ASM disk.

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.

Oracle Notes 

ASM Diskgroup Can Not Be Shown When Creating Database With DBCA (Doc ID 1269734.1)

DBCA Does Not Display ASM Disk Groups In 11.2 (Doc ID 1177483.1)

Dbca Does Not Show ASM Diskgroup Information (Doc ID 1286434.1)