4 Replies Latest reply: May 27, 2014 8:22 AM by Syed Rafi Ahmed RSS

    ORA-01565: error in identifying file '+fin_data/spfilefinprd.ora' ORA-17503: ksfdopn:2 Failed to open file +fin_data/spfilefinprd.ora

    Syed Rafi Ahmed

      Hi guys,

       

      We have configured ORacle RAC clusterware 11gR2 and we have upgraded our 10gR2 database to 11gR2 on the first node.

       

      Now we want to start the second instance on second RAC  node.

       

      While starting the same we are facing the following error:

       

      SQL> startup nomount pfile='/oraclehome/app/oracle/product/11.2.0/db_1/dbs/initfinprd2.ora';

      ORA-01565: error in identifying file '+fin_data/spfilefinprd.ora'

      ORA-17503: ksfdopn:2 Failed to open file +fin_data/spfilefinprd.ora

      ORA-29701: unable to connect to Cluster Synchronization Service

       

      It shows that it doesnt identifies the spfile.. but the instance on first node is already workign fine with spfile in ASM.

       

      Please help on ASAP basis.

       

      Help is appreciated.

       

      Regards,

      Rafi.

        • 1. Re: ORA-01565: error in identifying file '+fin_data/spfilefinprd.ora' ORA-17503: ksfdopn:2 Failed to open file +fin_data/spfilefinprd.ora
          Hemant K Chitale

          >It shows that it doesnt identifies the spfile

          It shows

          ORA-29701: unable to connect to Cluster Synchronization Service

           

          Are the Grid Services and ASM running on the second node ?

          What does "crs_stat -t"  report ?

           

           

          Hemant K Chitale

          • 2. Re: ORA-01565: error in identifying file '+fin_data/spfilefinprd.ora' ORA-17503: ksfdopn:2 Failed to open file +fin_data/spfilefinprd.ora
            Syed Rafi Ahmed

            Hi Hemant

             

            yes services are running, below is the output

             

            uid=130(grid) gid=540(oinstall)

            bash-3.2$ crs_stat -t

            Name           Type           Target    State     Host       

            ------------------------------------------------------------

            ora.DATA1.dg   ora....up.type ONLINE    ONLINE    findb01    

            ora....ARCH.dg ora....up.type ONLINE    ONLINE    findb01    

            ora....DATA.dg ora....up.type ONLINE    ONLINE    findb01    

            ora....EDO1.dg ora....up.type ONLINE    ONLINE    findb01    

            ora....EDO2.dg ora....up.type ONLINE    ONLINE    findb01    

            ora....ER.lsnr ora....er.type ONLINE    ONLINE    findb01    

            ora....N1.lsnr ora....er.type ONLINE    ONLINE    findb02    

            ora....N2.lsnr ora....er.type ONLINE    ONLINE    findb01    

            ora....N3.lsnr ora....er.type ONLINE    ONLINE    findb01    

            ora.asm        ora.asm.type   ONLINE    ONLINE    findb01    

            ora.cvu        ora.cvu.type   ONLINE    ONLINE    findb01    

            ora....SM1.asm application    ONLINE    ONLINE    findb01    

            ora....01.lsnr application    ONLINE    ONLINE    findb01    

            ora....b01.gsd application    OFFLINE   OFFLINE              

            ora....b01.ons application    ONLINE    ONLINE    findb01    

            ora....b01.vip ora....t1.type ONLINE    ONLINE    findb01    

            ora....SM2.asm application    ONLINE    ONLINE    findb02    

            ora....02.lsnr application    ONLINE    ONLINE    findb02    

            ora....b02.gsd application    OFFLINE   OFFLINE              

            ora....b02.ons application    ONLINE    ONLINE    findb02    

            ora....b02.vip ora....t1.type ONLINE    ONLINE    findb02    

            ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              

            ora....network ora....rk.type ONLINE    ONLINE    findb01    

            ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    findb01    

            ora.ons        ora.ons.type   ONLINE    ONLINE    findb01    

            ora....ry.acfs ora....fs.type ONLINE    ONLINE    findb01    

            ora.scan1.vip  ora....ip.type ONLINE    ONLINE    findb02    

            ora.scan2.vip  ora....ip.type ONLINE    ONLINE    findb01    

            ora.scan3.vip  ora....ip.type ONLINE    ONLINE    findb01    

            bash-3.2$

            • 3. Re: ORA-01565: error in identifying file '+fin_data/spfilefinprd.ora' ORA-17503: ksfdopn:2 Failed to open file +fin_data/spfilefinprd.ora
              Hemant K Chitale

              It seems that the ASM DiskGroups are mounted only on node 1 (findb01) and not on node 2.  Check the ASM log on on node 2

               

              ora.DATA1.dg   ora....up.type ONLINE    ONLINE    findb01    

              ora....ARCH.dg ora....up.type ONLINE    ONLINE    findb01    

              ora....DATA.dg ora....up.type ONLINE    ONLINE    findb01    

              ora....EDO1.dg ora....up.type ONLINE    ONLINE    findb01    

              ora....EDO2.dg ora....up.type ONLINE    ONLINE    findb01  

               

              Hemant K Chitale