2 Replies Latest reply on Sep 20, 2013 1:47 PM by HarryRonis

    DBCA Does Not Display ASM Disk Groups In 11.2.0.4

    HarryRonis

      DBCA trying to create a database with a different user oracle  than grid user. 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. This is all under Oracle 11.2.0.4.


      what to check .. all appears ok .... at a loss at this point


      1.  asm up online   .... ok

      crs_stat -t

      Name           Type           Target    State     Host       

      ------------------------------------------------------------

      ora.DATA.dg    ora....up.type ONLINE    ONLINE    sqls...r-pc

      ora.FRA.dg     ora....up.type ONLINE    ONLINE    sqls...r-pc

      ora....ER.lsnr ora....er.type ONLINE    ONLINE    sqls...r-pc

      ora.asm        ora.asm.type   ONLINE    ONLINE    sqls...r-pc

      ora.cssd       ora.cssd.type  ONLINE    ONLINE    sqls...r-pc

      ora.diskmon    ora....on.type OFFLINE   OFFLINE              

      ora.evmd       ora.evm.type   ONLINE    ONLINE    sqls...r-pc

      ora.ons        ora.ons.type   OFFLINE   OFFLINE              

      [grid@sqlservrer-PC ~]$

       

      2.

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

      $ cat /etc/fstab

      UUID=f7fcc326-7c70-43ac-ba86-fe0805e1c57f /boot                   ext4    defaults        1 2

      /dev/mapper/VolGroup-loradata /oradata                ext4    defaults        1 2

      /dev/mapper/VolGroup-lorainist /orainst               ext4    defaults        1 2

      UUID=39c84d4c-6be8-4d4c-8d27-5762d2d1f7df swap                    swap    defaults        0 0

      tmpfs   

       

       

      3. ids  ok


      proc                   proc    defaults        0 0

      [grid@sqlservrer-PC ~]$ id oracle

      uid=500(oracle) gid=501(oinstall) groups=501(oinstall),500(dba),503(asmadmin),504(asmdba),505(asmoper)


      rid@sqlservrer-PC ~]$ id grid

      uid=501(grid) gid=501(oinstall) groups=501(oinstall),500(dba),503(asmadmin),504(asmdba),505(asmoper)

       

       

      4.

      4. Check  if file permissions in <Grid_home>/bin/oracle executable are set properly, it should be 6751.ok

      $ ls -l $ORACLE_HOME/bin/oracle
      -rwsr-s–x 1 grid oinstall 200678430 Jun 16 12:44 /app/11.2.0/grid/bin/oracle

       

      5.  ile or directory

      [grid@sqlservrer-PC ~]$ ls -alt $ORACLE_HOME/bin/oracle

      -rwsr-s--x 1 grid oinstall 209914513 Sep 17 20:02 /ora

       

      6. Check asm disk permissions, with two users it should be : grid — asmadmin

      $ ls -ltr /dev/oracleasm/disks/

      6.

      [grid@sqlservrer-PC ~]$ ls -altR /dev/oracleasm/disks

      /dev/oracleasm/disks:

      total 0

      brw-rw---- 1 grid asmadmin 8, 5 Sep 19 14:48 DATA1

      brw-rw---- 1 grid asmadmin 8, 6 Sep 19 14:48 FRA1

      brw-rw---- 1 grid asmadmin 8, 8 Sep 19 12:43 FRA2

      brw-rw---- 1 grid asmadmin 8, 7 Sep 19 12:42 DATA2

      drwxr-xr-x 1 root root        0 Sep 19 10:11 .

      drwxr-xr-x 4 root root        0 Sep 19 10:11 ..

      [grid@sqlservrer-PC ~]$

       

      5.