Bookshelf Home | Contents | Index | PDF     

Siebel Database Upgrade Guide > Upgrading the Siebel Database >

Running the Siebel Database Configuration Wizard Under Windows

Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

Platforms: Windows only.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

Run the Database Configuration Wizard to upgrade the Siebel Database. The Wizard collects information, populates a master configuration file, and calls the SQL generator to create SQL commands. The Upgrade Wizard then uses the configuration file and SQL commands to upgrade the Siebel Database.

Prerequisites:

NOTE:  There are two procedures listed in this topic. All users should run the first procedure, and, depending on the outcome of that procedure, run the second. The procedures, and the outcomes of each are explained in the following two bullet points:

  • To run the Database Configuration Wizard under Windows. All users should perform this procedure. This procedure allows you to determine whether you have deployed languages that are not shipped with the Siebel product, or have unintended languages within your system that need to be removed. For a list of shipped languages, see Siebel System Requirements and Supported Platforms on Oracle Technology Network. If this procedure fails due to the presence of unshipped languages within your system, you will receive an error message stating that your present installation was found to be incomplete. You are also displayed a list of languages which caused the error. At this point, you must run the Database Configuration Wizard using a special .scm file, which is detailed in the second task.

    If your system only contains shipped languages, and you still receive an installer warning, you should review the records in the S_LST_OF_VAL database table using Siebel Tools. For more information, see Preparing for a Multilingual Upgrade.

  • To run the Database Configuration Wizard under Windows using the dbsrvr_lang.scm model file. Use this procedure only if your Configuration operation failed due to unshipped languages being deployed within your system. This procedure allows you to run the configuration utility, validate all data in shipped languages, and pass over all data in unshipped languages. You may then manually verify the data in unshipped languages following the successful completion of the Database Configuration Wizard.

To run the Database Configuration Wizard under Windows

  1. Ensure that no server tasks except the Siebel Gateway Name Service are running in the background.

    To verify, navigate to Start > Settings > Control Panel > Services.

    NOTE:  The Siebel Gateway Name Server must be running for the Database Configuration Wizard to execute.

  2. Start the Database Configuration Wizard by selecting Start > Programs > Siebel SES Configuration > Configure DB Server.

    The first window of the Database Configuration Wizard appears.

  3. Enter the information requested in each screen and click Next.
  4. After you have entered all the requested information, the wizard displays a screen that lists the values you entered. If you need to make changes, click Back.
  5. When the window displays inquiring whether you want to start the Upgrade Wizard, do the following:
    • Development Upgrep mode: Answer No. Do not start the Upgrade Wizard. Instead, return to the upgrep process checklist and perform the next steps.
    • Development Upgphys mode: Answer Yes to start the Upgrade Wizard.
    • Combined Production Upgrep and Upgphys mode: Answer No. Do not start the Upgrade Wizard. Instead, return to the upgrep process checklist, and perform the next steps.
    • Additive Schema Changes: You will not be prompted. The Upgrade Wizard starts automatically and creates the schema.additive.sql script.
    • Prepare for Production mode: Answer Yes to start the Upgrade Wizard.

      Just before displaying the prompt, the wizard calls the SQL generator to create or populate SQL scripts.

To run the Database Configuration Wizard under Windows using the dbsrvr_lang.scm model file

  1. Verify that no server tasks are running in the background.

    If necessary, stop Siebel Servers and Siebel Gateway Name Server service by navigating to Start > Settings > Control Panel > Services.

  2. Back up the dbsrvr.scm file, from the siebsrvr\admin directory, then rename it to dbsrvr_orig.scm .
  3. In the same location, rename dbsrvr_lang.scm to dbsrvr.scm.
  4. Select Start > Programs > Siebel SES Configuration > Configure DB Server.

    The first window of the Database Configuration Wizard appears.

  5. Enter the information requested in each screen and click Next.
  6. After you have entered all the requested information, the wizard displays a screen that lists the values you entered. If you need to make changes, click Back.
  7. When the window displays inquiring whether you want to start the Upgrade Wizard, do the following:
    • Development Upgrep mode: Answer No. Do not start the Upgrade Wizard. Instead, return to the upgrep process checklist and perform the next steps.
    • Development Upgphys mode: Answer Yes to start the Upgrade Wizard.
    • Combined Production Upgrep and Upgphys mode: Answer No. Do not start the Upgrade Wizard. Instead, return to the upgrep process checklist, and perform the next steps.
    • Additive Schema Changes: You will not be prompted. The Upgrade Wizard starts automatically and creates the schema.additive.sql script.
    • Prepare for Production mode: Answer Yes to start the Upgrade Wizard.

      Just before displaying the prompt, the wizard calls the SQL generator to create or populate SQL scripts.

Related Topics

About the Siebel Database Configuration Utilities.

Starting the Siebel Upgrade Wizard.

    
Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.