11.4.5.1 Execute the Schema Creator Utility only for the New Pack

To execute the schema creator utility, follow these steps:

Note:

While defining the schema details for the applications, provide the same schema details given in the previous installation. The output file (OFS_LRS_SCHEMA_OUTPUT.xml) is generated as a result of the schema creation process.

1. Edit the OFS_LRS_PACK/schema_creator/conf/OFS_LRS_SCHEMA_IN.xml file in a text editor. See the Configure the OFS_LRS_SCHEMA_IN.xml File file for values to modify in the XML file.
2. Execute the utility with -s option. For example: ./osc.sh -s

   Note:

   Ignore the below error for the view "BUS_PROF_NAMES" when osc.sh is executed while upgrading from LRS version 8.1.0.0.0 to 8.1.2.0.0.

   "ORA-00942: table or view does not exist".

3. Follow the steps given in the If the Schema Creator Output file (OFS_LRS_SCHEMA_OUTPUT.xml) EXISTS section.
4. Configuring the OFSAAI_InstallConfig.xml file is not required.