Skip to content

Posts tagged ‘rconfig’

Sep 7

RCONFIG – Cannot get SQLEngine

Problem: convert to rac from single instance using rconfig gives error

$ORACLE_HOME/bin/rconfig ConvertToRAC_AdminManaged.xml

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: Cannot get SQLEngine
Operation Failed. Refer logs at /opt/oracle/app/itdoracle/12c/cfgtoollogs/rconfig/rconfig_09_07_21_15_55_33.log for more details.

Cause: ORACLE_HOME was not set properly in xml file

          <n:SourceDBHome>/opt/oracle/ora12201</n:SourceDBHome>

          <n:TargetDBHome>/opt/oracle/ora12c</n:TargetDBHome>

Solution: source and target were on the same server so set it accordingly to new server

          <n:SourceDBHome>/opt/oracle/ora12201</n:SourceDBHome>

          <n:TargetDBHome>/opt/oracle/ora12201</n:TargetDBHome>

Aug 6

The instance prefix is invalid. Give a prefix with maximum 8 characters

Problem:

converting single instance database to RAC ONE node using RCONFIG gives error

-bash-4.2$ rconfig ConvertToRAC_AdminManaged_orcl.xml output_orcl.xml
<?xml version=”1.0″ ?>
<RConfig>
<Response>
<Result code=”1″ >
Got Exception
</Result>
<ErrorDetails>
The instance prefix is invalid. Give a prefix with maximum 8 characters.It may be different from SID of existing single-instance database.
</ErrorDetails>
</Response>
</RConfig>

 

Solution:

Provide instance prefix less then 8 character in rconfig xml file

<!–Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.–>
<n:InstancePrefix>orcl</n:InstancePrefix>

and run again

rconfig ConvertToRAC_AdminManaged_orcl.xml output_orcl.xml

%d bloggers like this: