This discussion is archived
6 Replies Latest reply: Feb 28, 2013 6:26 AM by 895680 RSS

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

492296 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    [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 Newbie
    Currently Being Moderated
    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]$

Legend

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