0 Replies Latest reply: Sep 29, 2013 8:51 AM by User374733 RSS

    rconfig fail

    User374733

      DB: 11.2

      ASM: 11.2

      OS: RHEL 4u5

      Node-1: Linux1

      Node-2: Linux2

      Single Instance Oracle_Home (On Linux1) : /u01/app/oracle/product/11.2.0/db_1

      Grid Oracle_Home: /u01/ora/11.2.0/grid

      RAC Oracle_Home:  /u01/app/ora/product/11.2.0/db_1

       

      Using "rconfig" to convert single instance database to RAC. With Line

      ...

      "<n:Convert verify="ONLY">"

      ...

      in ConvertToRAC.xml file we get result:

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

      <RConfig version="1.1" >

      <ConvertToRAC>

          <Convert>

            <Response>

              <Result code="0" >

                Operation Succeeded

              </Result>

            </Response>

            <ReturnValue type="object">

      There is no return value for this step     </ReturnValue>

          </Convert>

        </ConvertToRAC></RConfig>

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

       

      while changing line as

      ...

      "<n:Convert verify="YES">"

      ...

      getting error:

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

      ...

      oracle.sysman.assistants.rconfig.engine.CRSStartupException: PRCR-1079 : Failed to start resource ora.orcl.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.orcl.db' on 'linux2' 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.orcl.db' on that would satisfy its placement policy

      Operation Failed. Refer logs at /u01/app/ora/cfgtoollogs/rconfig/rconfig_09_29_13_13_19_49.log for more details.

             </ErrorDetails>

            </Response>

          </Convert>

        </ConvertToRAC></RConfig>

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

      However, first instance ORCL1 has been started successfully at the end of rconfig utility but ORCL2 is not getting up. The issue must be on Node-2.

       

      Please have a look into the contents of the "ConvertToRAC.xml" file and suggest something to resolve the issue. Thanks in advance.

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

      <?xml version="1.0" encoding="UTF-8"?>

      <n:RConfig xmlns:n="http://www.oracle.com/rconfig"

                 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                 xsi:schemaLocation="http://www.oracle.com/rconfig">

          <n:ConvertToRAC>

      <!-- Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY -->

              <n:Convert verify="YES">

      <!--Specify current OracleHome of non-rac database for SourceDBHome -->

                    <n:SourceDBHome>/u01/app/oracle/product/11.2.0/db_1</n:SourceDBHome>

      <!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->

                    <n:TargetDBHome>/u01/app/ora/product/11.2.0/db_1</n:TargetDBHome>

      <!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion -->

                    <n:SourceDBInfo SID="ORCL">

                      <n:Credentials>

                        <n:User>sys</n:User>

                        <n:Password>*******</n:Password>

                        <n:Role>sysdba</n:Role>

                      </n:Credentials>

                    </n:SourceDBInfo>

      <!--Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist. -->

                    <n:NodeList>

                      <n:Node name="linux1"/>

                      <n:Node name="linux2"/>

                    </n:NodeList>

      <!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.-->

                    <n:InstancePrefix>ORCL</n:InstancePrefix>

      <!-- Listener details are no longer needed starting 11.2. Database is registered with default listener and SCAN listener running from Oracle Grid Infrastructure home. -->

      <!--Specify the type of storage to be used by rac database. Allowable values are CFS|ASM. The non-rac database should have same storage type. ASM credentials are no needed for conversion. -->

                    <n:SharedStorage type="ASM">

      <!--Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be used for rac database. For CFS, this field will have directory path. -->

                      <n:TargetDatabaseArea>+DATA1</n:TargetDatabaseArea>

      <!--Specify Flash Recovery Area to be configured for rac database. If this field is left empty, current recovery area of non-rac database will be configured for rac database. If current database is not using recovery Area, the resulting rac database will not have a recovery area. -->

                      <n:TargetFlashRecoveryArea>+FRA</n:TargetFlashRecoveryArea>

                    </n:SharedStorage>

              </n:Convert>

          </n:ConvertToRAC>

      </n:RConfig>

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