This discussion is archived
4 Replies Latest reply: Aug 30, 2013 7:49 AM by gohappy RSS

ASM Diskgroup doesn't reflect on 2nd ASM instance

gohappy Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    [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 Journeyer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    Hi

     

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

     

    Thanks,

    Gohappy

Legend

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