Siebel Database Upgrade Guide > Upgrading the Siebel Database >

Running the Siebel Database Configuration Wizard on Windows

Environments: Development, production test, production.

Platforms: Windows only.

For a description of information required to run the Database Configuration Wizard, see Table 22.

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.

Requirements

• Collect the information that the Database Configuration Wizard requires. See Preparing to Run the Siebel Database Configuration Wizard.
• Install the new release's languages packs for all deployed languages. See Upgrade Planning for Multilingual Siebel Deployments.
• Run the Database Configuration Wizard as described in this topic. All customers must 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 must be removed. For a list of shipped languages, see 1513102.1 (Article ID) on My Oracle Support.

  NOTE:  If this procedure fails due to the presence of unshipped languages within your system, then 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.

  If your system only contains shipped languages, and you still receive this error message, then you must review the records in the S_LST_OF_VAL database table using Siebel Tools. For more information, see Preparing for a Multilingual Upgrade.

• If applicable, perform the tasks in Process of Deleting Unshipped Languages from the S_LST_OF_VAL Table on Windows.

  CAUTION:  Perform the tasks in this process only if your configuration operation failed due to unshipped languages being deployed within your system.

  This process allows you to run the configuration utility, validate all data in shipped languages, and pass over all data in unshipped languages. You can manually verify the data in unshipped languages following the successful completion of the Database Configuration Wizard.

For more information about starting the Database Configuration Wizard, see the Siebel Installation Guide for Microsoft Windows.

To run the Database Configuration Wizard on 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, and then 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, and then 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 must make changes, then 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 until you have performed all requirements.
   • Development Upgphys mode: Answer Yes to start the Upgrade Wizard.
   • Combined Production Upgrep and Upgphys mode: Answer No. Do not start the Upgrade Wizard until you have performed all requirements.
   • 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.