1. Database Upgrade Guide
  2. Production Database Upgrade Guidelines

Production Database Upgrade Guidelines

Both the Prepare for Production step and the upgrade tuning process modify the SQL scripts used to perform the upgrade in the test environment. In addition, it is common to further modify these scripts to meet local requirements.

The recommended way to perform the production upgrade is to use the SQL scripts that you have generated and modified for the test upgrade. The steps in the production environment upgrade process are as follows:

  1. Run the Database Configuration Utilities in the production environment.

  2. In the utilities, enter the information for the production environment instead of the test environment. For example, you enter the ODBC connection for the production environment.

    This configures the driver file to run against the production database rather than the test database. The utilities also configure the driver file to use the upgrade SQL files you generated for the test upgrade.

  3. Run the Upgrade Wizard. The Upgrade Wizard uses the SQL files in the test environment to upgrade the database in the production environment.

This approach has several advantages:

  • You do not have to generate upgrade SQL files in the production environment and then manually transfer customizations to them from the test environment.

  • You do not lose any changes to the SQL files that were made by Siebel Upgrade Tuner in the test environment.

  • You do not have to run the Database Configuration Utilities in Prepare for Production mode again.

  • With some exceptions, you do not have to perform database-related configuration tasks required Articles or Siebel Release Notes on My Oracle Support.

If your network configuration prevents creating an ODBC connection to your production database from inside your test environment, and you cannot complete your production upgrade, then 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.