This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Jul 15, 2013 8:23 AM by baddabingtim RSS

Cannot see ASM disk groups in DBCA from oracle account

735839 Newbie
Currently Being Moderated
I have a 2-node 11.2 grid infrastructure installed as a grid linux account. Per the document I was following, I was trying to run the grid infrastructure as grid and the database as an oracle account. When logged in as the grid account, my iscsi disks are visible through asmlib and asmca. However, if I run dbca there are no available ASM disks to pick from. In trouble-shooting, I even went so far as to give the oracle account secondary group membership in the asmadmin group, which is the primary group on the directories and files from the grid install.

It has been suggested to me that perhaps I need a tnsnames.ora entry in my new 11.2 database home to see my grid listener. My grid inf is listening on port 1521. I think dynamic service registration should have taken care of this.

If I run asmca as the grid user, the disk groups show up. If I run asmca as the oracle user, the disk groups are blank.

Any ideas? This job role separation thing isn't working out too well for me.
  • 1. Re: Cannot see ASM disk groups in DBCA from oracle account
    314801 Journeyer
    Currently Being Moderated
    If I run asmca as the grid user, the disk groups show up. If I run asmca as the oracle user, the disk groups are blank.
    Yes, thats the way it is supposed to be. Why do you want to run asmca as "oracle" ? Databases are installed as user "oracle" and use ASM. You do not configure disk groups.

    --
    Ronny Egner
    My Blog: http://blog.ronnyegner-consulting.de
  • 2. Re: Cannot see ASM disk groups in DBCA from oracle account
    g777 Journeyer
    Currently Being Moderated
    hi

    this question was not answered properly as it stated fristly:
    When logged in as the grid account, my iscsi disks are visible through asmlib and asmca. However, if I run dbca there are no available ASM disks to pick from.

    So is my problem, though asmca run by grid sees all diskgroups mounted, the dbca run by oracle user, cannot.
  • 3. Re: Cannot see ASM disk groups in DBCA from oracle account
    735839 Newbie
    Currently Being Moderated
    Exactly. I knew that asmca wasn't meant to be run from the Oracle account. I was mainly interested in why the ASM disks didn't show up under my "oracle" account. It seems I have the problem solved now, but I don't really like my solution for a production system. Here were my experiments that led to this.

    1. Installed an RDBMS 11.2 Oracle Home as the grid user (grid). Ran dbca and was able to see the ASM disks just fine. This told me it had to be a permission problem.
    2. Logged in as the oracle user (oracle). Set the environment to the Grid Infra Home. asmcmd was able to see the ASM disks without any problem. This told me it wasn't a problem with the disks being presented to the oracle user.
    3. Logged in as the grid user (grid). Ran "find /u01/app/11.2.0/grid -group oinstall -exec chmod g+rx {} \;". After doing this, the oracle user had no problems seeing the ASM disks in dbca.

    So, the questions are:
    Why did I need to do this?
    Why didn't the installations set all the permissions as needed for a multi-user, job-role-separation environment? (The Grid Infra Install doc clearly recommends this.)
    Most important, is there a better way?
  • 4. Re: Cannot see ASM disk groups in DBCA from oracle account
    Keyur_makwana Newbie
    Currently Being Moderated
    Hi Pat,
    Before following the solution you mentioned, did you check disk permissions at OS level? I mean disks should be accessible and oracle user should have read-write access to that to make asm recognize them while logging as oracle.

    Thanks,
    keyur
  • 5. Re: Cannot see ASM disk groups in DBCA from oracle account
    735839 Newbie
    Currently Being Moderated
    Thank you for your reply. Yes, I checked device permissions, but since I am using asmlib and not raw device mappings, asmlib should be taking care of it.

    [grid@rac1 dev]$ ls -l /dev/oracleasm/disks
    total 0
    brw-rw---- 1 grid asmadmin 8, 1 Jun 28 04:46 CRSVOL1
    brw-rw---- 1 grid asmadmin 8, 17 Jun 28 04:46 DATAVOL1
    brw-rw---- 1 grid asmadmin 8, 49 Jun 28 04:46 DATAVOL2
    brw-rw---- 1 grid asmadmin 8, 33 Jun 28 04:46 FRAVOL1

    Here, you can see that asmadmin group has full permissions. I made my oracle user a member of asmadmin group during my troubleshooting.
  • 6. Re: Cannot see ASM disk groups in DBCA from oracle account
    755353 Newbie
    Currently Being Moderated
    im having the same issues any ideas? it worked initially, i managed to create the db ) which worked only on local node) but failed to start on second node, now its failing on both nodes
  • 7. Re: Cannot see ASM disk groups in DBCA from oracle account
    guillermo.cervera Newbie
    Currently Being Moderated
    Hi Pat,
    I am facing the same problem as you. I'm installing a 11.2.0.2 RAC on AIX 6.1 platform.
    I agree with you that is a matter of permissions assigned to the grid's HOME directory.

    The strange thing is that Oracle recommends this setting, but offers no "official" document with the solution.

    Your solution seems valid and reasonable and that will apply in my production environment.

    Thank you very much for your input.

    Any additional information, please let us know.
  • 8. Re: Cannot see ASM disk groups in DBCA from oracle account
    870969 Newbie
    Currently Being Moderated
    Hi,

    Same problem, but find /app/11.2.0/grid -group oinstall -exec chmod g+rx {} \; didn't solve my problem.
    Any idea ?

    Regards

    Cyrille
  • 9. Re: Cannot see ASM disk groups in DBCA from oracle account
    user11189484 Newbie
    Currently Being Moderated
    Check the mount point of oracle software, it should mounted with options (remove nosuid) to allow grid to create shared memory segment

    Edited by: user11189484 on Jun 23, 2011 8:46 PM
  • 10. Re: Cannot see ASM disk groups in DBCA from oracle account
    870969 Newbie
    Currently Being Moderated
    Hi,

    Sorry for the delay.
    My mount point is :
    /dev/mapper/vgdata-lvapp on /app type ext3 (rw,nosuid,nodev)

    So, I should remove nosuid ? Anythings else to do ?
  • 11. Re: Cannot see ASM disk groups in DBCA from oracle account
    585179 Expert
    Currently Being Moderated
    Hi,

    Please post

    $> id <grid user>
    $> id <oracle user>

    and what OS are you using? How did you share the storage for ASM?


    Cheers
  • 12. Re: Cannot see ASM disk groups in DBCA from oracle account
    870969 Newbie
    Currently Being Moderated
    Hi,
    Here's a resume of all my settings (copy from my sr) :

    Os is : Red Hat Enterprise Linux Server release 5.6 (Tikanga)

    $id -a grid
    uid=961(grid) gid=310(oinstall) groups=310(oinstall),300(dba),330(asmadmin),332(asmdba) context=user_u:system_r:unconfined_t:s0

    $id oracle
    uid=502(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),506(asmdba)

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

    $ls -ltr /app/oracle/product/11.2.0.2R/dbhome_1/bin/oracle
    -rwsr-s--x 1 oracle oinstall 228886426 Jun 22 12:00 /app/oracle/product/11.2.0.2R/dbhome_1/bin/oracle

    $ ls -ltr /dev/oracleasm/disks/
    total 0
    brw-rw---- 1 grid asmadmin 8, 34 Jun 23 14:05 ASMDATA2
    brw-rw---- 1 grid asmadmin 8, 39 Jun 23 14:05 ASMREDO2
    brw-rw---- 1 grid asmadmin 8, 36 Jun 23 14:05 ASMFRA2
    brw-rw---- 1 grid asmadmin 8, 38 Jun 23 16:10 ASMREDO1
    brw-rw---- 1 grid asmadmin 8, 35 Jun 23 16:10 ASMFRA1
    brw-rw---- 1 grid asmadmin 8, 33 Jun 23 16:10 ASMDATA1
    brw-rw---- 1 grid asmadmin 8, 37 Jun 23 16:10 ASMRAC1

    crsctl status res -t
    --------------------------------------------------------------------------------
    NAME TARGET STATE SERVER STATE_DETAILS
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.DATA.dg
    ONLINE ONLINE lora503l
    ONLINE ONLINE lora505l
    ora.FRA.dg
    ONLINE ONLINE lora503l
    ONLINE ONLINE lora505l
    ora.LISTENER.lsnr
    ONLINE ONLINE lora503l
    ONLINE ONLINE lora505l
    ora.RAC.dg
    ONLINE ONLINE lora503l
    ONLINE ONLINE lora505l
    ora.REDO.dg
    ONLINE ONLINE lora503l
    ONLINE ONLINE lora505l
    ora.asm
    ONLINE ONLINE lora503l Started
    ONLINE ONLINE lora505l Started


    To be quick :
    1. Incorrect permission setting for oracle user ---> CHECKED
    2. ASM instance was not started or diskgroups are not mounted. ---> CHECKED
    3. The diskgroup resources are not online. ---> CHECKED (asm is up and I can connect with user grid, I see my disk group, if I launch dbca with grid user I can see my disk group)
    4. The permission setting for the asm devices are incorrect. ---> CHECKED
    5. The oracle executable under <Grid Infrastructure Home>/bin has incorrect permission settings. ---> CHECKED

    When I tried to connect to asm instamce with user oracle, I connect to idle instance :
    $ set | grep ORACLE
    OLD_ORACLE_BASE=/app/oracle
    ORACLE_BASE=/app/grid
    ORACLE_HOME=/app/11.2.0/grid
    ORACLE_SID=+ASM1

    $ sqlplus / as sysdba

    SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 5 09:09:51 2011

    Copyright (c) 1982, 2010, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL>

    If someone has an idea i'll test it.
    It seems that there's some missing permissions somewhere.
    I've installed it on three differents cluster, and each time I get the problem

    Regards

    Edited by: 867966 on 2011-07-05 06:26
  • 13. Re: Cannot see ASM disk groups in DBCA from oracle account
    870969 Newbie
    Currently Being Moderated
    The winner is user11189484.
    The mount point of oracle binaries with option nosuid was the problem.
    Since we've removed that option, I can see my asm diskgroups.

    Regards
  • 14. Re: Cannot see ASM disk groups in DBCA from oracle account
    Emmanuel Jackson Newbie
    Currently Being Moderated
    There are 3 symptoms causing this issue.

    ause #1) File permissions in <Grid_home>/bin/oracle executable not set properly.

    Cause #2) If the Oracle user is not a part of asmdba group; DBCA will not be able to see the diskgroups, and may not start.

    Cause #3) The OS environment variable ORA_CRS_HOME is set and set to the wrong Oracle Home. Please avoide setting this environment variable altogether.

    I just done the below For cause #1 and Issue resolved.

    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

    For More Details Ref Metalink Doc : 1177483.1

    Regards,
    Karthik
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points