Database Reference
In-Depth Information
Execute the steps explained in the document “Using Oracle 11g Release 2 Real Application Clusters and
Automatic Storage Management with Oracle E-Business Suite Release 12.2 (Doc ID 1453213.1)” to convert the
database to RAC and migrate to ASM. Listing 11-19 shows the XML file that I prepared as input into those steps.
Listing 11-19.
Example Contents of an rconfig XML Input File
[oracle@s1 ~]$
cat PRODtoRAC.xml
<?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>
<n:Convert verify="YES">
<n:SourceDBHome>/u01/app/oracle/product/11.2.0.3/dbhome_3</n:SourceDBHome>
<n:TargetDBHome>/u01/app/oracle/product/11.2.0.3/dbhome_3</n:TargetDBHome>
<n:SourceDBInfo SID="PROD">
<n:Credentials>
<n:User>sys</n:User>
<n:Password>password</n:Password>
<n:Role>sysdba</n:Role>
</n:Credentials>
</n:SourceDBInfo>
<n:NodeList>
<n:Node name="s1"/>
<n:Node name="s2"/>
</n:NodeList>
<n:InstancePrefix>PROD</n:InstancePrefix>
<n:SharedStorage type="ASM">
<n:TargetDatabaseArea>+DATA</n:TargetDatabaseArea>
<n:TargetFlashRecoveryArea>+RECO</n:TargetFlashRecoveryArea>
</n:SharedStorage>
</n:Convert>
</n:ConvertToRAC>
</n:RConfig>
The process will take a while to complete, because the data files need to be copied to ASM. Once completed, the
database will be started and the required CRS resources will be registered.
The e-Business Suite configuration for RAC is still missing at this time, so it has to be prepared. The steps are
outlined in the same document (1453213.1), but I find the document hard to follow because it tries to explain multiple
options on how e-Business Suite can be configured on RAC at the same time. You need a configuration that uses
srvctl
to manage the database and the custom user-created listener, and the e-Business Suite needs to be aware of
the SCAN listener. Following are the verified steps for this particular configuration.
Create a new
appsutil.zip
package on the applications server
oevm1
:
1.
[oracle@oevm1 ~]$
. /cloudfs/PROD/fs1/EBSapps/appl/APPSPROD_oevm1.env
[oracle@oevm1 ~]$
. $RUN_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
[oracle@oevm1 scripts]$
$AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /cloudfs/prod/fs1/inst/apps/PROD_oevm1/admin/log/MakeAppsUtil_10221301.log
output located at /cloudfs/prod/fs1/inst/apps/PROD_oevm1/admin/out/appsutil.zip
MakeAppsUtil completed successfully.