DBCA Does not Display ASM Disk Groups in 11.2

DBCA Does not Display ASM Disk Groups in?11.2

https://oraclehowto.wordpress.com/2011/08/15/dbca-does-not-display-asm-disk-groups-in-11-2/

Posted by Cloeffel on August 15, 2011

I get this problem if trying to create a database with a different user than grid user.

I ' ve installed grid infrastructure with user Grid, and I am trying to create a database with user Oracle (who's the owner of Oracle RDBMS). But during the installation I wasn ' t able to see any of my ASM disk. There is lots of reasons not to being able to see the disks, but mine is not in Oracle support.

In fact my problem is that, the mount point of Oracle binary filesystem had option? Nosuid. So if you ' re in trouble first check, the May is it ' ll save you some times.

Otherwise take a look at these Oracle notes:

ASM DiskGroup Can 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)

Here's a summary of what to check in the This case:

1. Check If your ASM is OK

With grid User:

$./crsctl Status Res-t
.......
Ora.asm
Online online Cluster1
Online online Cluster2
.......

2. Check your Oracle binary mount point (option nosuid disable)

$ cat/etc/fstab

3. Check users and groups, it should is like this:

$ id-a Grid
uid=961 (GRID) gid=310 (Oinstall) groups=310 (Oinstall), (asmadmin), 332 (ASMDBA)
$ id-a Oracle
uid=960 (Oracle) gid=310 (oinstall) groups=310 (Oinstall), (DBA), (Oper), 332 (ASMDBA)
$ cat/etc/group
Dba:x:300:applq,oracle
Oinstall:x:310:oracle,grid
Oper:x:320:oracle
Asmadmin:x:330:grid
asmoper:x:331:
Asmdba:x:332:oracle,grid

4. Check? If file permissions in <grid_home>/bin/oracle executable is set properly, it should be 6751.

$ ls-l $ORACLE _home/bin/oracle
-rwsr-s–x 1 grid oinstall 200678430 June 12:44/app/11.2.0/grid/bin/oracle

To correct:

$ chmod 6751/app/11.2.0/grid/bin/oracle

5. Check ASM Disk permissions, with the users it should be:grid-asmadmin

$ ls-ltr/dev/oracleasm/disks/
Total 0
brw-rw--1 Grid asmadmin 8, June 14:05 Asmdata
brw-rw--1 Grid asmadmin 8, June 14:05 Asmredo
brw-rw--1 Grid asmadmin 8, June 14:05 Asmfra
brw-rw--1 grid asmadmin 8, Notoginseng June 16:10 Asmrac

I hope this could help you if you ' re in trouble.

Regards

DBCA Does not Display ASM Disk Groups in 11.2