0 Replies Latest reply: Aug 30, 2013 11:31 PM by Endeca RSS

    Rconfig failing with error in 11gR2

    Endeca

      HI,

       

      We are under process of migrating EBS R12 database 11.2.0.3 to cluster servers,so far migration went fine, however rconfig migration is failing with node2 database creation error.

       

      Tried to start manually.

      ======================

      [oracle@ebsracn2 ~]$ . oracle.env

      [oracle@ebsracn2 ~]$ srvctl start database -d DEVN2

      PRCD-1120 : The resource for database DEVN2 could not be found.

      PRCR-1001 : Resource ora.devn2.db does not exist

      [oracle@ebsracn2 ~]$ srvctl status database -d DEVN

      Instance DEVN1 is running on node ebsracn1

      Instance DEVN2 is not running on node ebsracn2

      [oracle@ebsracn2 ~]$

       

      ======================================

      [oracle@ebsracn1 ~]$ /u01/app/11.2.0/grid/bin/crsctl stat res -t

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

      NAME           TARGET  STATE        SERVER                   STATE_DETAILS

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

      Local Resources

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

      ora.DATA.dg

                     ONLINE  ONLINE       ebsracn1

                     ONLINE  ONLINE       ebsracn2

      ora.LISTENER.lsnr

                     ONLINE  ONLINE       ebsracn1

                     ONLINE  ONLINE       ebsracn2

      ora.asm

                     ONLINE  ONLINE       ebsracn1                 Started

                     ONLINE  ONLINE       ebsracn2                 Started

      ora.gsd

                     OFFLINE OFFLINE      ebsracn1

                     OFFLINE OFFLINE      ebsracn2

      ora.net1.network

                     ONLINE  ONLINE       ebsracn1

                     ONLINE  ONLINE       ebsracn2

      o

       

      Rconfig information.

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

      Converting Database "DEVN" to Cluster Database. Target Oracle Home: /u01/app/oracle/product/11.2.0/db_1. Database Role: PRIMARY.

      Setting Data Files and Control Files

      Adding Database Instances

      Adding Redo Logs

      Enabling threads for all Database Instances

      Setting TEMP tablespace

      Adding UNDO tablespaces

      Adding Trace files

      Setting Fast Recovery Area

      Updating Oratab

      Creating Password file(s)

      Configuring Listeners

      Configuring related CRS resources

      Starting Cluster Database

      <?xml version="1.0" ?>

      <RConfig version="1.1" >

      <ConvertToRAC>

          <Convert>

            <Response>

              <Result code="1" >

                Got Exception

              </Result>

             <ErrorDetails>

                   oracle.sysman.assistants.rconfig.engine.CRSStartupException: PRCR-1079 : Failed to start resource ora.devn.db

      CRS-2674: Start of 'ora.devn.db' on 'ebsracn2' failed

      CRS-2632: There are no more servers to try to place resource 'ora.devn.db' on that would satisfy its placement policy

      Operation Failed. Refer logs at /u01/app/oracle/cfgtoollogs/rconfig/rconfig_08_30_13_21_19_33.log for more details.

       

       

             </ErrorDetails>

            </Response>

          </Convert>

       

       

       

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

       

      Rconfig error log informaion.

      -=================================

      [main] [ 2013-08-31 09:26:42.552 IST ] [CRSNativeResult.addComp:162]  add comp: name ora.devn.db, rc 0, msg Success

      [main] [ 2013-08-31 09:26:42.553 IST ] [CRSNativeResult.addComp:162]  add comp: name ora.devn.db, rc 223, msg CRS-0223: Resource 'ora.devn.d                            b 2 1' has placement error.

      [main] [ 2013-08-31 09:26:42.553 IST ] [CRSNative.internalStartResource:389]  Failed to start resource: Name: ora.devn.db, node: null, filte                            r: null, msg CRS-2674: Start of 'ora.devn.db' on 'ebsracn2' failed

      CRS-2632: There are no more servers to try to place resource 'ora.devn.db' on that would satisfy its placement policy

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

      CRS-2674: Start of 'ora.devn.db' on 'ebsracn2' failed

      CRS-2632: There are no more servers to try to place resource 'ora.devn.db' on that would satisfy its placement policy

              at oracle.cluster.impl.common.SoftwareModuleImpl.start(SoftwareModuleImpl.java:472)

              at oracle.sysman.assistants.util.hasi.HADatabaseUtils.start(HADatabaseUtils.java:896)

              at oracle.sysman.assistants.rconfig.engine.CRSConfig.startRAC(CRSConfig.java:334)

              at oracle.sysman.assistants.rconfig.engine.Convert.runStep(Convert.java:399)

              at oracle.sysman.assistants.rconfig.engine.RACConvertStep.execute(RACConvertStep.java:191)

              at oracle.sysman.assistants.rconfig.engine.Request.execute(Request.java:79)

              at oracle.sysman.assistants.rconfig.engine.RConfigEngine.execute(RConfigEngine.java:66)

              at oracle.sysman.assistants.rconfig.RConfig.<init>(RConfig.java:97)

              at oracle.sysman.assistants.rconfig.RConfig.<init>(RConfig.java:62)

              at oracle.sysman.assistants.rconfig.RConfig.main(RConfig.java:145)

      Caused by: PRCR-1079 : Failed to start resource ora.devn.db

      CRS-2674: Start of 'ora.devn.db' on 'ebsracn2' failed

      CRS-2632: There are no more servers to try to place resource 'ora.devn.db' on that would satisfy its placement policy

              at oracle.cluster.impl.crs.CRSNative.internalStartResource(CRSNative.java:393)

              at oracle.cluster.impl.crs.CRSNative.startResource(CRSNative.java:281)

              at oracle.cluster.impl.crs.CRSResourceImpl.start(CRSResourceImpl.java:600)

              at oracle.cluster.impl.crs.CRSResourceImpl.start(CRSResourceImpl.java:575)

              at oracle.cluster.impl.crs.CRSResourceImpl.start(CRSResourceImpl.java:563)

              at oracle.cluster.impl.common.SoftwareModuleImpl.start(SoftwareModuleImpl.java:463)

              ... 9 more

      Caused by: CRS-2674: Start of 'ora.devn.db' on 'ebsracn2' failed

      CRS-2632: There are no more servers to try to place resource 'ora.devn.db' on that would satisfy its placement policy

              at oracle.cluster.impl.crs.CRSNativeResult.addLine(CRSNativeResult.java:113)

              at oracle.cluster.impl.crs.CRSNative.doStartResource(Native Method)

              at oracle.cluster.impl.crs.CRSNative.internalStartResource(CRSNative.java:387)

              ... 14 more

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

      CRS-2674: Start of 'ora.devn.db' on 'ebsracn2' failed

      CRS-2632: There are no more servers to try to place resource 'ora.devn.db' on that would satisfy its placement policy

              at oracle.cluster.impl.common.SoftwareModuleImpl.start(SoftwareModuleImpl.java:472)

              at oracle.sysman.assistants.util.hasi.HADatabaseUtils.start(HADatabaseUtils.java:896)

              at oracle.sysman.assistants.rconfig.engine.CRSConfig.startRAC(CRSConfig.java:334)

              at oracle.sysman.assistants.rconfig.engine.Convert.runStep(Convert.java:399)

              at oracle.sysman.assistants.rconfig.engine.RACConvertStep.execute(RACConvertStep.java:191)

              at oracle.sysman.assistants.rconfig.engine.Request.execute(Request.java:79)

              at oracle.sysman.assistants.rconfig.engine.RConfigEngine.execute(RConfigEngine.java:66)

              at oracle.sysman.assistants.rconfig.RConfig.<init>(RConfig.java:97)

              at oracle.sysman.assistants.rconfig.RConfig.<init>(RConfig.java:62)

              at oracle.sysman.assistants.rconfig.RConfig.main(RConfig.java:145)