1. Database Upgrade Guide
  2. Test Additive Schema Changes

Test Additive Schema Changes

If you do not plan to run additive schema changes on the production database in the production environment, then you do not need to perform the steps in this topic.

Perform these steps on the target database.

  1. Review About Siebel Additive Schema Changes Mode.

  2. (Optional) Changing the Siebel Database Configuration Utilities Language.

  3. In the test environment, run the Database Configuration Wizard:

  4. Choose Apply Additive Schema Changes mode.

    The Apply Additive Schema Changes mode identifies changes that can be made to the target database without taking it offline.

    Windows. You will not be prompted whether you want to run the Upgrade Wizard. Instead, the Upgrade Wizard starts automatically, and creates the schema.additive.sql script. The Upgrade Wizard does not run the script against the target database.

  5. UNIX. Run the Siebel Upgrade Wizard.

    See Starting the Siebel Upgrade Wizard.

    Specify master_additive_gen.ucf as the input file.

    The Upgrade Wizard generates the schema.additive.sql script. It does not run the script against the target database.

  6. Run the SQL script against the target database.

    See Applying Siebel Additive Schema Changes.

  7. Thoroughly review the operation of all applications. Verify that applying the additive schema changes has not adversely affected the operation of all applications.

  8. If applying additive schema changes adversely affects the operation of the applications, then do the following:

    1. For help diagnosing the cause of the problem and help in taking corrective action create a service request (SR) on My Oracle Support. Alternatively, you can phone Global Customer Support directly to create a service request or get a status update on your current SR. Support phone numbers remain the same and are listed on My Oracle Support.

    2. Restore the target database from backup before proceeding with further upgrade tuning.

    3. Do not use the additive schema changes feature during your production upgrade.

  9. If applications function normally, then continue with upgrade tuning. Consider using the additive schema changes feature during your production upgrade.