Siebel Database Upgrade Guide > Upgrading the Siebel Database >

Running the Siebel Database Configuration Wizard Under Windows

Environments: Development, production test, production.

Platforms: Windows only.

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

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.

CAUTION:  If you have unshipped languages deployed within your database system, then you must remove them before successfully running the Database Configuration Wizard. Perform the first step within this task, To run the Database Configuration Wizard under Windows if you are unsure whether you have undeployed languages in your system. If you do have unshipped languages deployed, then you will receive an error message. You then must perform the following topics in order to successfully run the Database Configuration Wizard: To back up the S_LST_OF_VAL table under Windows, To deactivate records for unshipped or unwanted languages under Windows, and To import newly created records from the data file under Windows.

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.

NOTE:  There are two procedures listed in this topic. All users must 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 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 Siebel System Requirements and Supported Platforms on Oracle Technology Network.

  NOTE:  For Siebel CRM product releases 8.1.1.9 and later and for 8.2.2.2 and later, the system requirements and supported platform certifications are available from the Certification tab on My Oracle Support. For information about the Certification application, see article 1492194.1 (Article ID) on My Oracle Support. 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 an installer warning, 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.

• Process of Deleting Unshipped Languages from the S_LST_OF_VAL Table Under Windows.

  CAUTION:  Use this three step 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 can 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, 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.