4 Replies Latest reply: Aug 30, 2013 9:49 AM by gohappy RSS

    ASM Diskgroup doesn't reflect on 2nd ASM instance

    gohappy

      Hi ,

       

      I have installed OEL-5.8 (64bit) on VMWare-8 , created two virtual nodes for RAC DATABASE-10gR1 installation, Successfully installed CRS and ASM (raw disks) on these nodes. While created diskgroup (TEST_DATA), +ASM 1 is able to mount it but while trying to mount the disk group (TEST_DATA) on + ASM 2 , I am getting the following error. While I created a disk-group in +ASM2 and tried to mount on +ASM1 , I encountered the same error. The ASM listeners were up and running and showing correct status on CRS.

       

      ERROR

      =======

      Could not mount the diskgroup on remote node rac1 using connection service rac:1521:+ASM1 Ensure that listener is running on this node and the ASM instance is registered to the listener. Received the following error

       

      ORA-15032: not all alterations performed

      ORA-15130: diskgroup "TEST_DATA"  is being dismounted.

       

       

      we have successfully upgraded all the PROD instances to 11gR2,  except this old system (10g). Our intention is to upgrade this old 10gR1 two node RAC database to  11gR2 (and stuck with this error while doing a POC).

       

      Thanks,

      gohappy

        • 1. Re: ASM Diskgroup doesn't reflect on 2nd ASM instance
          gohappy

          listener status

          ==============

           

          [oracle@rac1 ~]$ ps  -ef|grep tns

          root         9     2  0 14:00 ?        00:00:00 [netns]

          oracle    7450     1  0 14:04 ?        00:00:00 /oracle/asm10g/product/10.2.0/asm/bin/tnslsnr LISTENER_RAC1 -inherit

          oracle   20879 19561  0 14:12 pts/1    00:00:00 grep tns

          [oracle@rac1 ~]$ lsnrctl status LISTENER_RAC1 |grep ASM

          Service "+ASM" has 2 instance(s).

            Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...

            Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

          Service "+ASM_XPT" has 1 instance(s).

            Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

          [oracle@rac1 ~]$ lsnrctl status LISTENER_RAC1

           

           

          LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-AUG-2013 14:16:47

           

           

          Copyright (c) 1991, 2005, Oracle.  All rights reserved.

           

           

          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

          STATUS of the LISTENER

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

          Alias                     LISTENER_RAC1

          Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

          Start Date                28-AUG-2013 14:04:07

          Uptime                    0 days 0 hr. 12 min. 40 sec

          Trace Level               off

          Security                  ON: Local OS Authentication

          SNMP                      OFF

          Listener Parameter File   /oracle/asm10g/product/10.2.0/asm/network/admin/listener.ora

          Listener Log File         /oracle/asm10g/product/10.2.0/asm/network/log/listener_rac1.log

          Listening Endpoints Summary...

            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.31)(PORT=1521)))

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.131)(PORT=1521)))

          Services Summary...

          Service "+ASM" has 2 instance(s).

            Instance "+ASM1", status UNKNOWN, has 1 handler(s) for this service...

            Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

          Service "+ASM_XPT" has 1 instance(s).

            Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...

          Service "PLSExtProc" has 1 instance(s).

            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

          The command completed successfully

           

          [oracle@rac2 ~]$ ps -ef|grep tns

          root         9     2  0 14:00 ?        00:00:00 [netns]

          oracle    7805     1  0 14:04 ?        00:00:00 /oracle/asm10g/product/10.2.0/asm/bin/tnslsnr LISTENER_RAC2 -inherit

          oracle   18782 18901  0 14:16 pts/1    00:00:00 grep tns

          [oracle@rac2 ~]$

          [oracle@rac2 ~]$ lsnrctl status LISTENER_RAC2

           

          LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 28-AUG-2013 14:16:21

           

          Copyright (c) 1991, 2005, Oracle.  All rights reserved.

           

          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

          STATUS of the LISTENER

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

          Alias                     LISTENER_RAC2

          Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production

          Start Date                28-AUG-2013 14:04:43

          Uptime                    0 days 0 hr. 11 min. 37 sec

          Trace Level               off

          Security                  ON: Local OS Authentication

          SNMP                      OFF

          Listener Parameter File   /oracle/asm10g/product/10.2.0/asm/network/admin/listener.ora

          Listener Log File         /oracle/asm10g/product/10.2.0/asm/network/log/listener_rac2.log

          Listening Endpoints Summary...

            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.32)(PORT=1521)))

            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.132)(PORT=1521)))

          Services Summary...

          Service "+ASM" has 2 instance(s).

            Instance "+ASM2", status UNKNOWN, has 1 handler(s) for this service...

            Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...

          Service "+ASM_XPT" has 1 instance(s).

            Instance "+ASM2", status BLOCKED, has 1 handler(s) for this service...

          Service "PLSExtProc" has 1 instance(s).

            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

          The command completed successfully

          • 2. Re: ASM Diskgroup doesn't reflect on 2nd ASM instance
            gohappy

            [root@rac1 ~]# crs_stat -t

            Name           Type           Target    State     Host       

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

            ora....SM1.asm application    ONLINE    ONLINE    rac1       

            ora....C1.lsnr application    ONLINE    ONLINE    rac1       

            ora.rac1.gsd   application    ONLINE    ONLINE    rac1       

            ora.rac1.ons   application    ONLINE    ONLINE    rac1       

            ora.rac1.vip   application    ONLINE    ONLINE    rac1       

            ora....SM2.asm application    ONLINE    ONLINE    rac2       

            ora....C2.lsnr application    ONLINE    ONLINE    rac2       

            ora.rac2.gsd   application    ONLINE    ONLINE    rac2       

            ora.rac2.ons   application    ONLINE    ONLINE    rac2       

            ora.rac2.vip   application    ONLINE    ONLINE    rac2

             

            [root@rac2 ~]# crs_stat -t

            Name           Type           Target    State     Host       

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

            ora....SM1.asm application    ONLINE    ONLINE    rac1       

            ora....C1.lsnr application    ONLINE    ONLINE    rac1       

            ora.rac1.gsd   application    ONLINE    ONLINE    rac1       

            ora.rac1.ons   application    ONLINE    ONLINE    rac1       

            ora.rac1.vip   application    ONLINE    ONLINE    rac1       

            ora....SM2.asm application    ONLINE    ONLINE    rac2       

            ora....C2.lsnr application    ONLINE    ONLINE    rac2       

            ora.rac2.gsd   application    ONLINE    ONLINE    rac2       

            ora.rac2.ons   application    ONLINE    ONLINE    rac2       

            ora.rac2.vip   application    ONLINE    ONLINE    rac2 

             

             

             

            [oracle@rac1 admin]$ more listener.ora

            # listener.ora.rac1 Network Configuration File: /oracle/asm10g/product/10.2.0/asm/network/admin/listener.ora.rac1

            # Generated by Oracle configuration tools.

             

             

            LISTENER_RAC1 =

              (DESCRIPTION_LIST =

                (DESCRIPTION =

                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.miracle.com)(PORT = 1521)(IP = FIRST))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.131)(PORT = 1521)(IP = FIRST))

                )

              )

             

             

            SID_LIST_LISTENER_RAC1 =

              (SID_LIST =

                (SID_DESC =

                  (SID_NAME = PLSExtProc)

                  (ORACLE_HOME = /oracle/asm10g/product/10.2.0/asm)

                  (PROGRAM = extproc)

                )

                (SID_DESC =

                  (GLOBAL_DBNAME = +ASM)

                  (SID_NAME = +ASM1)

                  (ORACLE_HOME = /oracle/asm10g/product/10.2.0/asm)

                )

             

             

            [root@rac2 admin]# more listener.ora

            # listener.ora.rac2 Network Configuration File: /oracle/asm10g/product/10.2.0/asm/network/admin/listener.ora.rac2

            # Generated by Oracle configuration tools.

             

             

            LISTENER_RAC2 =

              (DESCRIPTION_LIST =

                (DESCRIPTION =

                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.miracle.com)(PORT = 1521)(IP = FIRST))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.132)(PORT = 1521)(IP = FIRST))

                )

              )

             

             

            SID_LIST_LISTENER_RAC2 =

              (SID_LIST =

                (SID_DESC =

                  (SID_NAME = PLSExtProc)

                  (ORACLE_HOME = /oracle/asm10g/product/10.2.0/asm)

                  (PROGRAM = extproc)

                )

                (SID_DESC =

                  (GLOBAL_DBNAME = +ASM)

                  (SID_NAME = +ASM2)

                  (ORACLE_HOME = /oracle/asm10g/product/10.2.0/asm)

                )

              )

             

              )

             

            Thanks,

            gohappy

            • 3. Re: ASM Diskgroup doesn't reflect on 2nd ASM instance
              Pradeepcmst

              Hi Gohappy,

              Are you using SAN or NAS disks for ASM? Shared device is must for configuring RAC with ASM..

              • 4. Re: ASM Diskgroup doesn't reflect on 2nd ASM instance
                gohappy

                Hi

                 

                I am using RAW disks for ASM and yes, it is shared for configuring RAC with ASM.

                 

                Thanks,

                Gohappy