DBCA Does Not Display ASM Disk Groups In 11.2

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.

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: