This discussion is archived
4 Replies Latest reply: Feb 11, 2013 9:49 PM by KuljeetPalSingh RSS

Problem in Starting Rac databases

PrasanthkumarReddy.M Newbie
Currently Being Moderated
Hi All,

Getting Below error while starting instance.

[oracle@uidl1-oratest-01 ~]$srvctl start instance -d mda -i mda1

PRCR-1013 : Failed to start resource ora.mda.db
PRCR-1064 : Failed to start resource ora.mda.db on node uidl1-oratest-01
CRS-5017: The resource action "ora.mda.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATADG001/mda/spfilemda.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATADG001/mda/spfilemda.ora
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 1000 (oinstall), current egid = 1001 (dba)


CRS-2674: Start of 'ora.mda.db' on 'uidl1-oratest-01' failed

Thanks,
Prasanth
  • 1. Re: Problem in Starting Rac databases
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    Use SQL*Plus to logon to the ASM instance and list the devices for the DATADG00 diskgroup.

    Are all the disks and failgroups available?

    From the root error OS failure message: Operation not permitted, it seems that ASM/Oracle does not have read/write access to a specific disk in the diskgroup. The error also reports differences in current and expected group identifiers - oinstall vs. dba.

    What Oracle version do you have installed? On what o/s? Are Grid and RAC separated at o/s user level as recommended? What is the default group for the oracle o/s user? What is the group ownership of the disks/devices used by ASM for that diskgroup?
  • 2. Re: Problem in Starting Rac databases
    Raman Newbie
    Currently Being Moderated
    spfile is not accessible.. please check the permission and disk group exists?
  • 3. Re: Problem in Starting Rac databases
    ursusca Explorer
    Currently Being Moderated
    Startup Instance Failed with ORA-27140 ORA-27300 ORA-27301 ORA-27302 and ORA-27303 on skgpwinit6 [ID 1274030.1]
    Troubleshooting ORA-27300 ORA-27301 ORA-27302 errors [ID 579365.1]
  • 4. Re: Problem in Starting Rac databases
    KuljeetPalSingh Guru
    Currently Being Moderated
    ORA-17503: ksfdopn:2 Failed to open file +DATADG001/mda/spfilemda.ora
    make sure your diskgroup +DATADG001 should be mounted before starting oracle RAC instance.                                                                                                                                                                                                                                                                                                                                       

Legend

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