Convert Single Instance to RAC [message #625932] |
Thu, 16 October 2014 06:03  |
 |
juniordbanewbie
Messages: 250 Registered: April 2014
|
Senior Member |
|
|
Hi,
I'm trying to convert a single instance DB to a RAC DB
my ORACLE_SID=ORCLEE
the oracle owner is oracle3 in my case
my ORACLE_HOME is /u01/app/oracle3/product/11.2.0.3/dbhome_1
from http://docs.oracle.com/cd/E11882_01/install.112/e24660/cvrt2rac.htm#RILIN1159
I follow the following
Quote:
Converting Oracle Database 11g Installations to Oracle RAC Using DBCA
Back Up the Original Single-Instance Database
Complete Oracle Clusterware Installation
Validate the Cluster
Copy the Preconfigured Database Image
Install Oracle Database 11g Software with Oracle RAC
next I created /u01/app/oracle3/product/11.2.0.3/dbhome_1/sampleXMLs/orclee.xml from /u01/app/oracle3/product/11.2.0.3/dbhome_1/sampleXMLs/ConvertToRAC_AdminManaged.xml
the contents of orclee.xml is as follow
<?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 rconfig.xsd">
<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="ONLY">
<!--Specify current OracleHome of non-rac database for SourceDBHome -->
<n:SourceDBHome>/u01/app/oracle3/product/11.2.0.3/dbhome_1</n:SourceDBHome>
<!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->
<n:TargetDBHome>/u01/app/oracle3/product/11.2.0.3/dbhome_2</n:TargetDBHome>
<!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion -->
<n:SourceDBInfo SID="ORCLEE">
<n:Credentials>
<n:User>sys</n:User>
<n:Password>T0mkyt3</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="orac01"/>
<n:Node name="orac02"/>
</n:NodeList>
<!--Specify RacOneNode along with servicename to convert database to RACOne Node -->
<!--n:RacOneNode servicename="salesrac1service"/-->
<!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.-->
<n:InstancePrefix>ORCLEE</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>+DATA</n:TargetDatabaseArea>
<!--Specify Fast 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>
when I run rconfig i encounter the following error:
oracle3@ORAC01:/u01/app/oracle3/product/11.2.0.3/dbhome_1/bin> ./rconfig orclee.xml
<?xml version="1.0" ?>
<RConfig>
<Response>
<Result code="1" >
Got Exception
</Result>
<ErrorDetails>
oracle.sysman.assistants.rconfig.parser.ParserException:File Not Found
</ErrorDetails>
</Response>
</RConfig>
oracle3@ORAC01:/u01/app/oracle3/product/11.2.0.3/dbhome_1/bin>
What should I do to avoid the above error?
It seems that there's something wrong with my procedures but I could not figure out what is wrong.
Really appreciate any help rendered.
thanks a lot in advance!
|
|
|
|
|