1.1 Create Schema from Shipment Media

This topic describes the steps to create the schema from the Shipment Media.

Source input for Installer for DB Setup

Database installation includes the provision of details of the schema to connect and the location of the source objects. The objects of the selected modules are compiled as explained below.

1. Copy the shipment media to a folder in the local system.
   Eg: C:\Installer\12.3.0.0.0_Exec\
2. Ensure that the folder containing the sources from shipment media has access rights for that user after copying the sources in the local system.
   It is not mandatory to copy the sources to local system. You may also directly refer the Installer to the shipment media.
3. Identify the list of schemas that needs to be deployed based on the installation type.
   The installation types include:

   • Installation without PENSION module
   • Installation includes PENSION module
   • PENSION Standalone module Setup
4. List the schema types to be included in the Installation without PENSION module.
   The below list of schema types needs to be executed:

   • SMS
   • SP
   • LOB
   • REPORTS
5. List the schema types to be included in the Installation includes PENSION module.
   The below list of schema types needs to be executed:

   • SMS
   • SP
   • LOB
   • PENSION
   • REPORTS
6. List the schema types to be included in the PENSION Standalone module Setup.
   The below list of schema types needs to be executed:

   • SMS
   • SP
   • PENSION
7. Run the Cross Schema Scripts Utility post the DB Setup.
   Refer the topic Cross Schema Scripts for more details on running scripts.
8. Close the Installer and relaunch each DB operation for a schema.