1. Installation and Configuration Guide
  2. Installation
  3. Configure the Schema Creator Utility
  4. Configure the Schema Creator Utility for RDBMS Installation
  5. Configure the OFS_PM_SCHEMA_IN.xml File

6.4.2.1 Configure the OFS_PM_SCHEMA_IN.xml File

This section describes how to create database schemas, objects within schemas, and assign appropriate grants.

Specify the database schemas required for the installation in the OFS_PM_SCHEMA_IN.xml. Update the required values in this file before executing the Schema Creator Utility.

To configure the OFS_PM_SCHEMA_IN.xml file, follow these steps:

  1. Log in to the system as a non-root user.
  2. Navigate to the OFS_PM_PACK/schema_creator/conf directory.
  3. Edit the OFS_PM_SCHEMA_IN.XML file using a text editor and configure the values as mentioned in the following table.

    Figure 6-2 Sample OFS_PM_SCHEMA_IN.xml File


    This illustration shows a sample of the OFS_PM_SCHEMA_IN.xml file.

  4. Save and close the file.
Example: The following snippet shows that TDE is enabled and hence the tablespace is shown with encryption ON.
<ADV_SEC_OPTIONS>
<OPTION NAME="TDE" VALUE="FALSE"/>
<OPTION NAME="DATA_REDACT" VALUE="FALSE" />
</ADV_SEC_OPTIONS>
<TABLESPACES>
<TABLESPACE NAME="OFS_AAI_TBSP_1" VALUE="TS_USERS1" DATAFILE="/
scratch/ora12c/app/oracle/oradata/OFSPQA12CDB/ts_users1.dbf" SIZE="500M" AUTOEXTEND="ON" ENCRYPT="ON" />
<TABLESPACE NAME="OFS_AAI_TBSP_2" VALUE="TS_USERS2" DATAFILE="/
scratch/ora12c/app/oracle/oradata/OFSPQA12CDB/ts_users2.dbf" SIZE="500M" AUTOEXTEND="ON" ENCRYPT="ON" />
</TABLESPACES>

<SCHEMAS>
<SCHEMA TYPE="CONFIG" NAME="ofsaaconf" PASSWORD="" APP_ID="OFS_AAI" DEFAULTTABLESPACE="##OFS_AAI_TBSP_1##" TEMPTABLESPACE="TEMP"
QUOTA="unlimited"/>
<SCHEMA TYPE="ATOMIC" NAME="ofsaaatm" PASSWORD="" APP_ID="OFS_AAAI" DEFAULTTABLESPACE="##OFS_AAI_TBSP_2##" TEMPTABLESPACE="TEMP" QUOTA="unlimited" INFODOM="OFSAAAIINFO"/>
</SCHEMAS>