13 Replies Latest reply on Apr 12, 2013 9:21 PM by TSharma-Oracle

    Cannot start ASM

    1002434
      Hello,

      as the title sais, I cannot start ASM on my Oracle Database Appliance.

      crsctl status resource -t says:
      ora.asm
      ONLINE ONLINE node1 Started
      ONLINE ONLINE node2 Started

      however, if I try to access the ASMCMD it says:
      [grid@node1 ~]$ asmcmd
      Connected to an idle instance.
      ASMCMD> startup
      ORA-00304: requested INSTANCE_NUMBER is busy
      Connected to an idle instance.

      thank you in advance,
      christoph
        • 1. Re: Cannot start ASM
          Mihael
          check ORACLE_HOME and ORACLE_SID before starting ASMCMD
          • 2. Re: Cannot start ASM
            1002434
            hi Mihael,

            [grid@node1~]$ echo $ORACLE_HOME
            /u01/app/11.2.0/grid

            [grid@node2~]$ echo $ORACLE_SID
            +ASM1                                                                                                                                                                                                                               
            • 3. Re: Cannot start ASM
              Mihael
              999431 wrote:
              hi Mihael,

              [grid@node1~]$ echo $ORACLE_HOME
              /u01/app/11.2.0/grid

              [grid@node2~]$ echo $ORACLE_SID
              +ASM1
              if you are on node2, set ORACLE_SID to +ASM2                                                                                                                                                                                                                                                                                                                                                                                                                                           
              • 4. Re: Cannot start ASM
                1002434
                ORACLE_SID on node 2 was set to +ASM2

                [grid@node2 ~]$ echo $ORACLE_SID
                +ASM2                                                                                                                                                                               
                • 5. Re: Cannot start ASM
                  Jaroslaw Bicz
                  what ps axu |grep pmon shows ?
                  • 6. Re: Cannot start ASM
                    1002434
                    node1:
                    grid 14833 0.0 0.0 1269264 24544 ? Ss 11:54 0:05 asm_pmon_+ASM1


                    node2:
                    grid 14499 0.0 0.0 1269264 24564 ? Ss 11:52 0:06 asm_pmon_+ASM2                                                                                                                                                                                                                                                                                                                                                                       
                    • 7. Re: Cannot start ASM
                      D Tej
                      here is the stuff from metalink.....
                      Subject:
                      OERR: ORA 304 requested
                      INSTANCE_NUMBER is busy
                      Error: ORA 304
                      Text: requested INSTANCE_NUMBER is busy
                      -------------------------------------------------------------------------------
                      Cause: An instance tried to start by using a value of the initialization
                      parameter INSTANCE_NUMBER that is already in use.
                      Action: Specify another value for INSTANCE_NUMBER in the initialization
                      parameter file or wait for recovery to finish for that instance number.
                      Then restart the instance.
                      • 8. Re: Cannot start ASM
                        Jaroslaw Bicz
                        Hi
                        try to set ORACLE_HOME for you grid instalation with and without "/" on the end ie export ORACLE_HOME=/u01/grid or export $ORACLE_HOME=/u01/grid/ in my case / on the end of $ORACLE_HOME was the issue try to connect with sqlplus / as sysdba

                        Edited by: Jaroslaw Bicz on Apr 11, 2013 8:34 AM
                        • 9. Re: Cannot start ASM
                          1002434
                          I tried both. No change.
                          • 10. Re: Cannot start ASM
                            Levi Pereira
                            post here:

                            cat /etc/oratab
                            • 11. Re: Cannot start ASM
                              Mihael
                              here is the stuff from metalink.....
                              Subject:
                              OERR: ORA 304 requested
                              INSTANCE_NUMBER is busy
                              Error: ORA 304
                              Text: requested INSTANCE_NUMBER is busy
                              -------------------------------------------------------------------------------
                              Cause: An instance tried to start by using a value of the initialization
                              parameter INSTANCE_NUMBER that is already in use.
                              Action: Specify another value for INSTANCE_NUMBER in the initialization
                              parameter file or wait for recovery to finish for that instance number.
                              Then restart the instance.
                              This is true for RDBMS instance. For ASM, only one instance is supported on server.
                              • 12. Re: Cannot start ASM
                                TSharma-Oracle
                                Check if you have missing your spfile OR there is some wrong entry in the spfile.
                                • 13. Re: Cannot start ASM
                                  TSharma-Oracle
                                  Check this bug also:
                                  Bug 10283167 - ASM instance cannot startup due to existence of VMBX process when using HP Openview [ID 10283167.8]