This discussion is archived
4 Replies Latest reply: Oct 17, 2012 6:21 AM by Pek RSS

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

Pek Newbie
Currently Being Moderated
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

Legend

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