1 2 Previous Next 15 Replies Latest reply: Jul 15, 2013 10:23 AM by baddabingtim RSS

    Cannot see ASM disk groups in DBCA from oracle account

    Pat Minnis
      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
          Ronny Egner
          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
            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
              Pat Minnis
              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
                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
                  Pat Minnis
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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