7 Replies Latest reply: Mar 27, 2012 11:56 AM by user8860348 RSS

    Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully

    user8860348
      Folks,

      Hello. I am installing Oracle 11gR2 RAC using 2 VMs (main VM rac1 and slave VM rac2) with Oracle Linux 5.6 according to the website http://appsdbaworkshop.blogspot.com/2011/10/11gr2-rac-on-linux-56-using-vmware.html

      Grid and RAC database have been installed successfully for both VMs rac1 and rac2.
      I am using the slave VM rac2 to test Grid and RAC database because rac1 disk is full.
      The problem is that OCR file is not available or currupted in the slave VM rac2.


      I have created a pfile and add entry in the file sqlnet.ora in the slave VM rac2. By now, I still cannot startup Grid as below:

      [ora11g@rac2 /]$ cd u01/app/grid/bin/

      [ora11g@rac2 bin]$ crsctl status resource
      CRS-4535: Cannot communicate with Cluster Ready Services
      CRS-4000: Command Status failed, or completed with errors.

      [ora11g@rac2 bin]$ cd /u02/11g_db/ora11g/racdb/bin

      [ora11g@rac2 bin]$ srvctl config database -d racdb
      PRCD-1027 : Failed to retrieve database racdb
      PRCR-1070 : Failed to check if resource ora.racdb.db is registered
      Cannot communicate with crsd
      [ora11g@rac2 bin]$


      [ora11g@rac2 ~]$ cd /u01/app/grid/bin

      [ora11g@rac2 bin]$ export ORACLE_SID=+ASM2

      [ora11g@rac2 bin]$ ./sqlplus / as sysdba

      SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 26 12:40:35 2012

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

      Connected to an idle instance.

      SQL> startup
      ORA-01078: failure in processing system parameters
      LRM-00109: could not open parameter file '/u02/11g_db/ora11g/racdb/dbs/init+ASM2.ora'
      SQL>

      I have checked that there is no the file init+ASM2.ora in the directory '/u02/11g_db/ora11g/dbs'.

      As we see the outputs above, my question is:

      Can any folk help to solve the issue to start up Grid ?


      Thanks.
        • 1. Re: Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully
          NikolayIvankin
          user8860348 wrote:
          [ora11g@rac2 ~]$ cd /u01/app/grid/bin

          [ora11g@rac2 bin]$ export ORACLE_SID=+ASM2

          [ora11g@rac2 bin]$ ./sqlplus / as sysdba

          SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 26 12:40:35 2012

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

          Connected to an idle instance.

          SQL> startup
          ORA-01078: failure in processing system parameters
          LRM-00109: could not open parameter file '/u02/11g_db/ora11g/racdb/dbs/init+ASM2.ora'
          SQL>

          I have checked that there is no the file init+ASM2.ora in the directory '/u02/11g_db/ora11g/dbs'.
          Here you are trying to startup ASM instance with name ASM2. What is its name?
          Show the result of
          ls -l /u02/11g_db/ora11g/dbs
          • 2. Re: Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully
            user8860348
            Folks,

            Hello. Thanks a lot for replying. The output is below:

            [ora11g@rac2 bin]$ cd /u02/11g_db/ora11g/racdb/dbs

            [ora11g@rac2 dbs]$ ls -1
            hc_racdb2.dat
            init.ora
            initracdb2.ora
            orapwracdb2
            [ora11g@rac2 dbs]$

            As we see, there is no the file init+ASM2.ora. I also run startup using pfile as follows:

            [ora11g@rac2 ~]$ cd /u01/app/grid/bin
            [ora11g@rac2 bin]$ export ORACLE_SID=+ASM2
            [ora11g@rac2 bin]$ ./sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 26 14:30:22 2012

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

            Connected to an idle instance.

            SQL> startup pfile='/u01/app/grid/dbs/pfile'
            ORA-01031: insufficient privileges
            SQL>


            Both ways above cannot startup Grid. My question is:

            How to solve the above issue to start up Grid ?

            Thanks.
            • 3. Re: Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully
              912595
              user8860348 wrote:
              Folks,

              Hello. Thanks a lot for replying. The output is below:

              [ora11g@rac2 bin]$ cd /u02/11g_db/ora11g/racdb/dbs

              [ora11g@rac2 dbs]$ ls -1
              hc_racdb2.dat
              init.ora
              initracdb2.ora
              orapwracdb2
              [ora11g@rac2 dbs]$

              As we see, there is no the file init+ASM2.ora. I also run startup using pfile as follows:

              [ora11g@rac2 ~]$ cd /u01/app/grid/bin
              [ora11g@rac2 bin]$ export ORACLE_SID=+ASM2
              [ora11g@rac2 bin]$ ./sqlplus / as sysdba

              SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 26 14:30:22 2012

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

              Connected to an idle instance.

              SQL> startup pfile='/u01/app/grid/dbs/pfile'
              ORA-01031: insufficient privileges
              SQL>


              Both ways above cannot startup Grid. My question is:

              How to solve the above issue to start up Grid ?

              Thanks.
              Please make sure that you use same OS user which owns then GRID_HOME
              You might have installed Cluster with 'grid' user,so use grid user to start asm.
              • 4. Re: Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully
                NikolayIvankin
                Agree to Ranjit.

                Check if there is any other ORACLE_HOME
                • 5. Re: Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully
                  user8860348
                  Folks,

                  Hello. Thanks a lot for replying.

                  My OS user is ora11g that is the same with Grid user. I use ora11g user to install Grid. I don't use 'grid' user install Grid.

                  ORACLE_HOME is the same with GRID_HOME: /u01/app/grid
                  GRID_BASE: /u01/11g_grid
                  RAC Database Home: /u02/11g_db/ora11g/racdb

                  There is no other ORACLE_HOME. The issues are the below:

                  SQL> startup pfile='/u01/app/grid/dbs/pfile'
                  ORA-01031: insufficient privileges
                  SQL>


                  SQL> startup
                  ORA-01078: failure in processing system parameters
                  LRM-00109: could not open parameter file '/u02/11g_db/ora11g/racdb/dbs/init+ASM2.ora'
                  SQL>


                  My question is:

                  Can any folk help to solve the above issues to startup Grid ?


                  Thanks.
                  • 6. Re: Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully
                    NikolayIvankin
                    If you don't use ASM, then why have you set ORACLE_SID to +ASM2?

                    set it to racdb2 and startup.
                    • 7. Re: Cannot Startup Grid in 11gR2 RAC after Install Grid Successfully
                      user8860348
                      Folks,

                      Hello. Thanks a lot for replying. Let's analyze 3 cases as follows:

                      Case 1:

                      If don't export ORACLE_SID=+ASM2, the output is below:

                      [ora11g@rac2 /]$ cd u01/app/grid/bin

                      [ora11g@rac2 bin]$ ./sqlplus / as sysdba

                      SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 27 12:31:35 2012

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

                      Connected to an idle instance.

                      SQL> startup
                      ORA-01078: failure in processing system parameters
                      ORA-01565: error in identifying file '+DATA/racdb/spfileracdb.ora'
                      ORA-17503: ksfdopn:2 Failed to open file +DATA/racdb/spfileracdb.ora
                      ORA-15077: could not locate ASM instance serving a required diskgroup

                      SQL> startup pfile='/u01/app/grid/dbs/pfile'
                      ORA-01031: insufficient privileges
                      SQL>


                      Case 2:

                      If export ORACLE_SID=+ASM2, the output is below:

                      [ora11g@rac2 bin]$ export ORACLE_SID=+ASM2

                      [ora11g@rac2 bin]$ ./sqlplus / as sysdba

                      SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 27 12:41:33 2012

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

                      Connected to an idle instance.

                      SQL> startup
                      ORA-01078: failure in processing system parameters
                      LRM-00109: could not open parameter file '/u02/11g_db/ora11g/racdb/dbs/init+ASM2.ora'

                      SQL> startup pfile='/u01/app/grid/dbs/pfile'
                      ORA-01031: insufficient privileges
                      SQL>


                      Case 3:

                      Now, as you indicated, I export ORACLE_SID=racdb2, the output is below:

                      [ora11g@rac2 bin]$ pwd
                      /u01/app/grid/bin

                      [ora11g@rac2 bin]$ export ORACLE_SID=racdb2

                      [ora11g@rac2 bin]$ ./sqlplus / as sysdba

                      SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 27 12:33:48 2012

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

                      Connected to an idle instance.

                      SQL> startup
                      ORA-01078: failure in processing system parameters
                      ORA-01565: error in identifying file '+DATA/racdb/spfileracdb.ora'
                      ORA-17503: ksfdopn:2 Failed to open file +DATA/racdb/spfileracdb.ora
                      ORA-15077: could not locate ASM instance serving a required diskgroup

                      SQL> startup pfile='/u01/app/grid/dbs/pfile'
                      ORA-01031: insufficient privileges
                      SQL>


                      As we see the ouputs above, export ORACLE_SID=racdb2 doesn't have any effect. My question is:

                      Can any folk help to solve the above 3 issues to start up Grid ?


                      Thanks.