Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

Managing templates for Oracle RAC databases on Linux and UNIX

When working with the template for creating a Real Applications Cluster (RAC) database, you can customize the default template, as follows:

Adding custom initialization parameters

If you want to add custom initialization parameters into the template for creating a RAC database, insert the following content in the CDATA section of the template:

<custom_init_parameters>
        <![CDATA[
                <initParam name="db_create_online_log_dest_1" value="+REDO1"/>
                <initParam name="db_create_online_log_dest_2" value="+REDO2"/>
                <initParam name="db_create_file_dest" value="+DATA"/>
                <initParam name="log_archive_dest_1"
value="location=USE_DB_RECOVERY_FILE_DEST mandatory"/>
                <initParam name="nls_date_format" value="YYYY-MON-DD HH:MI:SS
PM"/>
                        ]]>
               </custom_init_parameters>

Adding redo log member directory names

If you want to add the directory names for Redo Log Member Directories into the template for creating a RAC database, use the following structure:

<templates>
 <template>/oradata/1/{DB_UNIQUE_NAME}/</template>
 <template>/oradata/2/{DB_UNIQUE_NAME}/</template>
</templates>
<redo_log_member_file name_template>%t%g%.log</redo_log_member_file name_template>
<num_of_redo_log_groups>2</num_of_redo_log_groups>
<num_of_redo_log_members>2</num_of_redo_log_members

Creating a separate disk group for GIMR data

New in 8.9.02(Applies to 12.2.0.1 only) If you want to create a separate disk group for the Grid Infrastructure Management Repository (GIMR) data to segregate it from the Cluster Ready Services (CRS) data, insert the following content in the template:

<gimr_configure>TRUE</gimr_configure>
<gimr_diskgroup_name>DGIMRG</gimr_diskgroup_name>                              
<gimr_disks>
<gimr_disk>/dev/oracle/post11gR2/GRID6</gimr_disk>  
</gimr_disks>
<gimr_au_size>4</gimr_au_size>
<gimr_redundancy>EXTERNAL</gimr_redundancy>


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*