4 Replies Latest reply: Oct 17, 2012 8:21 AM by Pek RSS

    Convert 11g Database to Oracle RAC fail with rconfig when rman started

    Pek
      Hi Team!!
      I'm using this note:      
           Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 11i (Doc ID 823586.1)

      I have 1 single instance and I need migrate to RAC.

      This step finish ok:
      3.1 Install Oracle Clusterware 11g Release 2
      3.2 Install Oracle Database Software 11g Release 2 and Upgrade Applications Database to 11g Release 2
      3.3 Configure Listener
      3.4 Configure Shared Storage

      but... in this step... I have an error.
      3.5.9 Convert Database 11g Release 2 to Oracle RAC

      I'm using rconfig._
      This's my xml:_
      <n:Convert verify="ONLY">
      <n:SourceDBHome>/pu07_tmp/u01/app/oracle/product/11.2.0/dbhome_1</n:SourceDBHome>
      <n:TargetDBHome>/pu05/u01/app/oracle/product/11.2.0/dbhome_1</n:TargetDBHome>
      <n:SourceDBInfo SID="TEST">
      <n:Credentials>
      <n:User>sys</n:User>
      <n:Password>oracle</n:Password>
      <n:Role>sysdba</n:Role>
      </n:Credentials>
      </n:SourceDBInfo>
      <n:NodeList>
      <n:Node name="durazno"/>
      <n:Node name="nispero"/>
      </n:NodeList>
      <n:InstancePrefix>TEST</n:InstancePrefix>
      <n:TargetDatabaseArea>+DATA</n:TargetDatabaseArea>
      <n:TargetFlashRecoveryArea>+FRA</n:TargetFlashRecoveryArea>

      Next Step:
      $ ./rconfig /pu05/u01/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs/ConvertToRAC.xml
      <?xml version="1.0" ?>
      <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>


      I change to <n:Convert verify="YES">, and run rconfig.....I see that Rman copy all datafiles to ASM, but file with this error:
      <ErrorDetails>
      oracle.sysman.assistants.rconfig.engine.StorageCreationException: oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-25152: TEMPFILE cannot be dropped at this time

      Error on sqlLog
      alter database tempfile '/pu07_tmp/d0/oradata/TEMP13.DBF' drop
      *
      ERROR at line 1:
      ORA-25152: TEMPFILE cannot be dropped at this time



      any suggestions?..
      thanks
      Cristian

      Edited by: Pek on 31/05/2012 07:33