1. Database Upgrade Guide
  2. Postpone Running Post Installation Database Update

Postpone Running Post Installation Database Update

In some implementations, all database changes are managed by a DBA team that is distinct from the Siebel CRM team member who is installing the monthly update. This prevents the Siebel CRM installer from successfully running Post Installation Database Update (PostInstallDBSetup utility), since only the DBA team has the required Table Owner credentials.

In this scenario, the strategy is to let Post Installation Database Update generate the required Data Definition Language (DDL) scripts to make schema changes, which can then be edited and applied by the DBA team later. After this has occurred, the Siebel CRM installer can manually run Post Installation Database Update to create the required seed and manifest data (it will not need to make any schema changes).

If you want to postpone running the PostInstallDBSetup utility during a monthly update release, then complete the steps in the following procedure.

To postpone Post Installation Database Update

  1. In the Siebel Enterprise Server installer for your monthly update release, select the Defer-Generate DDL files only option to postpone running the PostInstalDBSetup utility.

    The installer collects the database details you provide and generates an SQL file containing Data Definition Language scripts for manually running the PostInstallDBSetup utility later (see step 3), after completing the update installation.

  2. To apply the schema changes to the database, the DBA must execute generate_schema.dll, which is located in the following folder:

    Note: The DBA can modify the generate_schema.dll file to specify environment-specific parameters, such as table or index spaces.
    ses\siebsrvr\log\PostInstallDBSetup_<time_stamp>\Common

  3. Manually run the PostInstallDBSetup utility to create the remaining artifacts in the database. That is, the required seed and manifest data; there are no schema changes since you manually applied the schema changes in step 2.

    Before running PostInstallDBSetup manually, modify the setup.ini file (located in the ..\ses\siebsrvr\bin folder) to indicate that the schema has already been installed by setting the following parameter:

    generate_schema=A

    For more information, see Rerunning Post Installation Database Update.