6 Replies Latest reply: Feb 28, 2013 8:26 AM by 895680 RSS

    PRCR-1079 : Failed to start resource ora.bluedb.db

    492296
      I have successfully configured RAC till but unfortunately while installing the Clustered DB using dbca, i got the error as shown below. Im using Oracle 11g Release 2.

      PRCR-1079 : Failed to start resource ora.bluedb.db
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux Error: 2: No such file or directory
      Process ID: 0
      Session ID: 0 Serial number: 0

      ORA-01078: failure in processing system parameters
      CRS-2674: Start of 'ora.bluedb.db' on 'rac2' failed
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux Error: 2: No such file or directory
      Process ID: 0
      Session ID: 0 Serial number: 0

      CRS-2632: There are no more servers to try to place resource 'ora.bluedb.db' on that would satisfy its placement policy
        • 1. Re: PRCR-1079 : Failed to start resource ora.bluedb.db
          fjfranken
          It kind of looks like the same problem we've had. I've written a blog entry about it at http://managingoracle.blogspot.com/2010/06/create-rac-database-results-in-prkp.html

          But then again, to be sure, please post more info, like spfile contents, alert_log, output of crs_stat -t etc..etc..


          Success,
          FJFranken
          My Blog: http://managingoracle.blogspot.coml
          • 2. Re: PRCR-1079 : Failed to start resource ora.bluedb.db
            CowTown_dba
            I apologize for answering your question with a question, but...

            How many nodes do you have in your cluster? And is the database running successfully on the other node(s)?
            • 3. Re: PRCR-1079 : Failed to start resource ora.bluedb.db
              895680
              Hi,

              Was your issue resolved? If yes could you pl provide the steps here as I am also facing the exactly same error. I am doing 11.2.0.1 rac installtion on RHEL 5.3 64 bit system.

              REgards,
              Purnima Johari
              • 4. Re: PRCR-1079 : Failed to start resource ora.bluedb.db
                986120
                Hi,

                Can you post output of
                crsctl stat res -t
                from both node..

                --
                Bala:)
                • 5. Re: PRCR-1079 : Failed to start resource ora.bluedb.db
                  895680
                  [oracle@rac1 bin]$ ./crsctl stat res -t
                  --------------------------------------------------------------------------------
                  NAME TARGET STATE SERVER STATE_DETAILS
                  --------------------------------------------------------------------------------
                  Local Resources
                  --------------------------------------------------------------------------------
                  ora.DATA.dg
                  ONLINE ONLINE rac1
                  ONLINE ONLINE rac2
                  ora.LISTENER.lsnr
                  ONLINE ONLINE rac1
                  ONLINE ONLINE rac2
                  ora.asm
                  ONLINE ONLINE rac1 Started
                  ONLINE ONLINE rac2 Started
                  ora.eons
                  ONLINE ONLINE rac1
                  ONLINE ONLINE rac2
                  ora.gsd
                  OFFLINE OFFLINE rac1
                  OFFLINE OFFLINE rac2
                  ora.net1.network
                  ONLINE ONLINE rac1
                  ONLINE ONLINE rac2
                  ora.ons
                  ONLINE ONLINE rac1
                  ONLINE ONLINE rac2
                  ora.registry.acfs
                  ONLINE ONLINE rac1
                  ONLINE ONLINE rac2
                  --------------------------------------------------------------------------------
                  Cluster Resources
                  --------------------------------------------------------------------------------
                  ora.LISTENER_SCAN1.lsnr
                  1 ONLINE ONLINE rac2
                  ora.oc4j
                  1 OFFLINE OFFLINE
                  ora.prod.db
                  1 ONLINE OFFLINE Instance Shutdown
                  2 ONLINE OFFLINE
                  ora.rac1.vip
                  1 ONLINE ONLINE rac1
                  ora.rac2.vip
                  1 ONLINE ONLINE rac2
                  ora.scan1.vip
                  1 ONLINE ONLINE rac2
                  [oracle@rac1 bin]$

                  ********************************************************************************************************************************************

                  I brought down both RAC nodes and changed directory permission for oracle_home loc to 775 somewhere I read that its due to permission issue if cluster and db has been installed using different users. So after granting permission I tried bring up db and here is the o/p :

                  [oracle@rac1 bin]$ ./srvctl start database -d prod
                  PRCR-1079 : Failed to start resource ora.prod.db
                  ORA-01034: ORACLE not available
                  ORA-27101: shared memory realm does not exist
                  Linux-x86_64 Error: 2: No such file or directory
                  Process ID: 0
                  Session ID: 0 Serial number: 0

                  ORA-01078: failure in processing system parameters
                  CRS-2674: Start of 'ora.prod.db' on 'rac2' failed
                  ORA-01034: ORACLE not available
                  ORA-27101: shared memory realm does not exist
                  Linux-x86_64 Error: 2: No such file or directory
                  Process ID: 0
                  Session ID: 0 Serial number: 0

                  CRS-2632: There are no more servers to try to place resource 'ora.prod.db' on that would satisfy its placement policy
                  ORA-01078: failure in processing system parameters
                  CRS-2674: Start of 'ora.prod.db' on 'rac1' failed
                  [oracle@rac1 bin]$
                  *********************************************************************************************************************************************
                  Cluster was installed as Grid user and db as Oracle user.

                  [oracle@rac1 bin]$ id
                  uid=1000(oracle) gid=601(oinstall) groups=501(vboxsf),601(oinstall),602(dba),603(asmadmin)

                  [grid@rac1 ~]$ id
                  uid=500(grid) gid=601(oinstall) groups=501(vboxsf),601(oinstall),602(dba),603(asmadmin)


                  Regards,
                  Purnima Johari
                  • 6. Re: PRCR-1079 : Failed to start resource ora.bluedb.db
                    895680
                    O/p from other node:

                    [oracle@rac2 bin]$ ./crsctl stat res -t
                    --------------------------------------------------------------------------------
                    NAME TARGET STATE SERVER STATE_DETAILS
                    --------------------------------------------------------------------------------
                    Local Resources
                    --------------------------------------------------------------------------------
                    ora.DATA.dg
                    ONLINE ONLINE rac1
                    ONLINE ONLINE rac2
                    ora.LISTENER.lsnr
                    ONLINE ONLINE rac1
                    ONLINE ONLINE rac2
                    ora.asm
                    ONLINE ONLINE rac1 Started
                    ONLINE ONLINE rac2 Started
                    ora.eons
                    ONLINE ONLINE rac1
                    ONLINE ONLINE rac2
                    ora.gsd
                    OFFLINE OFFLINE rac1
                    OFFLINE OFFLINE rac2
                    ora.net1.network
                    ONLINE ONLINE rac1
                    ONLINE ONLINE rac2
                    ora.ons
                    ONLINE ONLINE rac1
                    ONLINE ONLINE rac2
                    ora.registry.acfs
                    ONLINE ONLINE rac1
                    ONLINE ONLINE rac2
                    --------------------------------------------------------------------------------
                    Cluster Resources
                    --------------------------------------------------------------------------------
                    ora.LISTENER_SCAN1.lsnr
                    1 ONLINE ONLINE rac2
                    ora.oc4j
                    1 OFFLINE OFFLINE
                    ora.prod.db
                    1 ONLINE OFFLINE Instance Shutdown
                    2 ONLINE OFFLINE
                    ora.rac1.vip
                    1 ONLINE ONLINE rac1
                    ora.rac2.vip
                    1 ONLINE ONLINE rac2
                    ora.scan1.vip
                    1 ONLINE ONLINE rac2
                    [oracle@rac2 bin]$