Siebel Database Upgrade Guide > Upgrading the Siebel Database >

Running the Siebel Database Configuration Wizard Under UNIX


Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

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. You then run the Upgrade Wizard to upgrade the Siebel Database.

Prior to running the Database Configuration Wizard you must install the new release's languages packs for each language that you deploy.

Prerequisites:

NOTE:  There are two procedures listed in this topic. All users should run the first procedure, and, depending on the outcome, 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 UNIX. 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 UNIX 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 UNIX

  1. Verify that all servers are stopped:
    • Stop all Siebel Servers.
    • Stop the Siebel Gateway Name Server.
  2. Make $SIEBEL_ROOT the current directory.
  3. Source the environment variables from the siebsrvr root directory: <install location>/siebsrvr

    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/sba80/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:

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

  6. Enter the information requested in each screen and click Next.

    After you have entered all the requested information, the wizard displays a screen that lists the values you entered.

  7. If you need to make changes, click Back.
  8. If you are performing a development upgrep or combined production upgrep and upgphys, do not start the Upgrade Wizard. Instead, return to the upgrep process checklist and perform the next steps.
  9. If you are performing any of the following, enter the command to start the Upgrade Wizard:
    • Development environment upgphys.
    • Additive Schema Changes. The Upgrade Wizard creates the schema.additive.sql script.
    • Prepare for Production.
  10. The Database Configuration Wizard will now exit and prompt you to launch the Upgrade Wizard (srvrupgwiz).

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

  1. Verify that all servers are stopped:
    • Stop all Siebel Servers.
    • Stop the Siebel Gateway Name Server.
  2. Make $SIEBEL_ROOT the current directory.
  3. Source the environment variables from the siebsrvr root directory: <install location>/siebsrvr

    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/sba80/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. Back up the dbsrvr.scm file, from the following location: $SIEBEL_ROOT/admin. Then rename the file dbsrvr_orig.scm.
  6. In the same location, rename dbsrvr_lang.scm to dbsrvr.scm.
  7. Start the Database Configuration Wizard:

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

  8. Enter the information requested in each screen and click Next.

    After you have entered all the requested information, the wizard displays a screen that lists the values you entered.

  9. If you need to make changes, click Back.
  10. If you are performing a development upgrep or combined production upgrep and upgphys, do not start the Upgrade Wizard. Instead, return to the upgrep process checklist and perform the next steps.
  11. If you are performing any of the following, enter the command to start the Upgrade Wizard:
    • Development environment upgphys.
    • Additive Schema Changes. The Upgrade Wizard creates the schema.additive.sql script.
    • Prepare for Production.
  12. The Database Configuration Wizard will now exit and prompt you to launch the Upgrade Wizard (srvrupgwiz).

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