Siebel Database Upgrade Guide for DB2 UDB for z/OS > Running the Database Configuration Wizard to Perform Upgrade Tasks >

About Running the Database Configuration Wizard Under UNIX

Upgrades: All upgrades.

Environments: All environments.

Platforms: UNIX 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 Siebel Upgrade Wizard then uses the configuration file and SQL commands to generate upgrade files that are applied on the mainframe, and to make upgrade changes to the Siebel database.

For more information on the Database Configuration Wizard, see About the Database Configuration Wizard.

Requirements:

• Collect the information that the Database Configuration Wizard requires. See Information Required By the Database Configuration Wizard.
• Install the new release's languages packs for all deployed languages. For further information on multilingual upgrades, see the topic on upgrade planning for multilingual Siebel deployments in the Siebel Database Upgrade Guide. For information on multilingual upgrades from Release 6.2.1, also see About Multilingual Deployments.

This topic describes two different procedures for starting the Database Configuration Wizard: one is the standard method of running the utility, the other method is used if you deploy languages that were not shipped by Oracle. The procedures are explained as follows:

• Running the Database Configuration Wizard Under UNIX

  This is the standard method of running the Database Configuration Wizard.

  If you have deployed languages that are not shipped with the Siebel product, or have languages within your system that need to be removed, this procedure will not complete successfully. You receive an error message stating that your present installation is incomplete, and a list of the languages that caused the error is displayed. If this error occurs, you must run the Database Configuration Wizard using the dbsrvr_lang.scm model file, as described in Running the Database Configuration Wizard With Unshipped Languages (UNIX).

  For a list of languages shipped by Oracle, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

  NOTE:  If your system only contains shipped languages, and you still receive an installer warning, review the records in the S_LST_OF_VAL database table using Siebel Tools. For more information, see the topic on preparing for a multilingual upgrade in the Siebel Database Upgrade Guide.

• Running the Database Configuration Wizard With Unshipped Languages (UNIX)

  Use this procedure only if your configuration operation fails because there are unshipped languages deployed within your system. This procedure allows you to run the Database Configuration Wizard, which will validate all data in shipped languages only. You can manually verify the data in unshipped languages following the successful completion of the Database Configuration Wizard.

Running the Database Configuration Wizard Under UNIX

This topic describes the standard procedure to follow to run the Database Configuration Wizard under UNIX.

To run the Database Configuration Wizard under UNIX

1. Verify that the Siebel Server is stopped.

   NOTE:  The Database Configuration Wizard runs in live mode only so you must be connected to the Gateway Name Server to run it. For further information on Siebel Configuration Wizard running modes, see Siebel Installation Guide for the operating system you are using.

2. Make $SIEBEL_ROOT the current directory.
3. Source environment variables from the $SIEBEL_ROOT directory:

   Korn: . siebenv.sh

   C shell: source siebenv.csh

4. Review the values of the following environment variables and confirm the settings are correct:
   • SIEBEL_ROOT. This path must end in siebsrvr. For example, /usr/siebel/siebsrvr.
   • LANGUAGE. This is the language in which the Database Configuration Wizard runs. The value of this variable is a language identifier string. For example, enu is the identifier string for English.

     If either $SIEBEL_ROOT or $LANGUAGE is not set or is incorrect, you must correct them before proceeding.

5. Start the Database Configuration Wizard by running the following command:

   $SIEBEL_ROOT/bin/ssincfgw -args MODEL_FILE=$SIEBELROOT/admin/dbsrvr.scm MODE=LIVE

   The first Database Configuration Wizard screen appears. Enter the information you are prompted for in this screen, and click next to continue.

6. Enter the information you are prompted for in all subsequent screens. Use the Next and Back buttons to navigate between screens.
7. After you have entered all the requested information, the wizard displays the following message:

   Configuration is complete: configuration parameters will be saved to <$Masterfile> file when the wizard completes. Please run the following command line after you exit from this configuration wizard. This command will deploy the process you configured to the database.

   $SiebelRoot/siebsrvr/bin/srvrupgwiz /m $SiebelRoot/siebsrvr/bin/$Masterfile>

8. Click Next to continue. The utility displays the Parameter Review screen listing all the values you have entered.
9. To amend any of the configuration values, click Back to return to the appropriate screen and make changes. Otherwise, click Next.
10. You are prompted as to whether or not you want to execute the configuration:
    • Click Yes, and the configuration information is saved in a master file located in $SIEBEL_ROOT/bin but the Upgrade Wizard is not launched. To start the Upgrade Wizard, see Starting the Siebel Upgrade Wizard.
    • Click No, and the configuration information you entered is not saved.

Running the Database Configuration Wizard With Unshipped Languages (UNIX)

This topic describes the procedure to follow to run the Database Configuration Wizard under UNIX if your system deploys languages that were not shipped by Oracle.

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

1. Verify that no server tasks are running in the background.
2. Make $SIEBEL_ROOT the current directory.
3. Source the environment variables from the $SIEBEL_ROOT directory:

   Korn shell: siebenv.sh

   C shell: source siebenv.csh

4. Review the values of the following environment variables and confirm the settings are correct:
   • SIEBEL_ROOT. This path must end in /siebsrvr. For example, /usr/siebel/siebsrvr.
   • LANGUAGE. This is the language in which the Database Configuration Wizard runs. The value of this variable is a language identifier string. For example, enu is the identifier string for English.
5. Navigate to the SIEBEL_ROOT/admin directory and do the following:
   1. Back up the dbsrvr.scm file, then rename the file to dbsrvr_orig.scm.
   2. Rename dbsrvr_lang.scm to dbsrvr.scm.
6. Start the Database Configuration Wizard by running the following command:

   $SIEBEL_ROOT/bin/ssincfgw -args MODE=LIVE MODEL_FILE=$SIEBEL_ROOT/admin/dbsrvr.scm

7. You can now use the Database Configuration Wizard as described in Step 6 through Step 10.