Upgrade Guide for UNIX > Upgrading the Siebel eBusiness Application >

Upgrading the Custom Database Schema

The configuration utility that you ran in Upgrading the Siebel Database Schema updated the Siebel Database Schema. You must now use the Database Server Configuration Wizard to apply these changes to the custom database schema to upgrade it to the new version.

If you are upgrading a development environment, the repository on which you run the Custom Database Schema upgrade must be the same repository that you prepared for the merge in Generating EIM Temporary Columns.

Before upgrading the custom database schema, take a backup of your Siebel database.

NOTE:  The custom database schema upgrade may complete in less than one hour.

To upgrade the custom database schema on supported UNIX platforms

  1. Verify that all servers are stopped:
    • Stop all Siebel Servers by typing: stop_server all
    • Stop the Siebel Gateway by typing: stop_ns
  2. Depending on your shell, source environment variables from $SIEBSRVR_ROOT/bin by typing:

    Korn shell

    . siebenv.sh

    C shell

    source siebenv.csh

  3. Set the following environment variables:
    • SIEBEL_ROOT should be the path of your Siebel eBusiness Application installation directory.
    • LANGUAGE should be set to the language in which the Configuration Wizard prompts appear; for example, enu for U.S. English.

      If either of these values is incorrect or empty, reset them using one of the following commands for the shell you are using:

      C shell

      • setenv LANGUAGE enu (where enu represents your display language)
      • setenv SIEBEL_ENTERPRISE Enterprise Name

        Korn shell

      • LANGUAGE=enu ; export LANGUAGE
      • SIEBEL_ENTERPRISE=Enterprise Name ; export SIEBEL_ENTERPRISE
  4. Navigate to $SIEBSRVR_ROOT/bin and enter:

    dbsrvr_config.ksh

    This launches the Database Server Configuration Wizard.

  5. Review the values of the following environment variables and confirm whether the settings are correct by entering either Y or N.
  1. At the Siebel Server Directory prompt, enter the path of your Siebel Server root directory, or accept the default by pressing Enter.
  2. At the Siebel Database Server Directory prompt, enter the path of your database server root directory, or accept the default by pressing Enter.
  3. At the RDBMS Platform prompt, enter the number that corresponds to your database platform.

    1 - IBM DB2 UDB for Unix and Windows.

    2 - Oracle.

  4. At the Siebel Database Operation prompt, choose Upgrade Database (2).
  5. At the Upgrade Options prompt, choose Upgrade Custom Database Schema (2).
  6. At the Environment Type prompt, enter the number that corresponds to the environment that you are upgrading:

    1 - Development.

    2 - Production.

    Which prompt appears next depends on the application that you are upgrading:

    • Siebel eBusiness Applications. The Current Siebel Version prompt appears. Skip Step 12 and continue to Step 13.
    • Siebel Industry Applications or Siebel Financial Services Applications. The Siebel Industry Vertical prompt appears. Continue with Step 12.
  7. If you are upgrading a Siebel Industry Application or Siebel Financial Services Application, choose the application from which you are upgrading. Carefully read the descriptions of the available applications. The choices available to you are constrained by the database platform you selected. The following applications may appear:

    NOTE:  Before choosing your application, see Siebel System Requirements and Supported Platforms to verify the supported upgrade paths for your deployment.

    • Siebel Automotive. Choose this if you are upgrading from Release 6.x of Siebel Automotive.
    • Siebel Communication Media Energy. Choose this if you are upgrading from Release 6.x of Siebel Communications, Media, and Energy.
    • Siebel Consumer Sector. Choose this if you are upgrading from Release 6.x of Siebel Consumer Sector.
    • Siebel Life Sciences. Choose this if you are upgrading from Release 6.x of Siebel Life Sciences.
    • Siebel Industry Solutions. Choose this if you are upgrading from Release 7.0.3 or 7.0.4 of any of the following applications: Siebel Consumer Sector, Siebel Life Sciences, Siebel Communications, Media, and Energy, Siebel Automotive.
    • Siebel Financial Services. Choose this if you are upgrading from Release 6.x or 7.x of Siebel Financial Services.
  8. At the Current Siebel Version prompt, select the version of Siebel you are upgrading from.
  9. At the Language Selection prompt, enter the number that corresponds to the appropriate language.

    NOTE:  The language selection screen will not appear if you have only one language installed, because that language is automatically defined as the primary language. Therefore, you will skip the next step and continue with Step 15.

  10. At the ODBC Data Source Name prompt, enter the ODBC datasource name; for example, siebsrvr_siebel.

    The data source is created automatically by the Siebel Server installation, using the format $SIEBSRVR_EnterpriseName. To find the name of your ODBC data source, type: vi $ODBCINI

  11. At the Database User Name prompt, enter the database user name and password for your database:
    1. Database User Name. User name of the Siebel administrator, for example, sadmin.
    2. Database Password. Password for the Siebel administrator, for example, db2.
  12. At the Database Table Owner Name prompt, enter the database tableowner name (this is the account that will own the Siebel objects):

    Database Tableowner. User name of the tableowner, for example, siebel.

    Database Tableowner Password. Password for the tableowner, for example, db2.

  13. At the Database Server OS prompt, enter the number that corresponds to the platform of your database server operating system:

    1- Windows

    2- Solaris

    3- AIX

    4- HP-UX

  14. The prompts that appear next may vary, depending on which database platform you use. See the following table for the prompts that you may receive next. Enter the values that you recorded on your Upgrade Planning Worksheet.

    NOTE:  Use underscores rather than spaces; these values are case-sensitive.

    Field
    Value
    Index Space
    • DB2 UDB: The name you give to your 4-KB index space for tables
    • Oracle: The name you gave to your index area
    4KB Table Space
    (DB2 UDB only)
    • DB2 UDB: The name you give to your 4-KB table space

      Note that you must use underscores rather than spaces.
    16KB Table Space
    (DB2 UDB only)
    • DB2 UDB: 16 KB Table space name
    32KB Table Space
    (DB2 UDB only)
    • DB2 UDB: 32 KB Table space name
    Table Space Name
    • Oracle: The name you gave to your data area
  15. At the Log Output Directory prompt, enter the directory within $SIEBEL_ROOT/siebsrvr/log where you want the log files to be generated.

    The default value for the log output directory is UPGRADEOPTION_ENVIRONMENT_VERSION; for example, the default log output directory for a development environment upgrade of the Siebel database schema from Release 6.0.1 would be $SIEBEL_ROOT/siebsrvr/log/upgrep_dev_601.

    NOTE:  If you are upgrading to a Release prior to 7.5.3, you will not see the Log Output Directory prompt. Your log files are located under $SIEBEL_ROOT/siebsrvr/log.

    The utility displays the values that you entered in the preceeding steps.

  16. Review the values for accuracy against the values that you recorded in your copy of Upgrade Planning Worksheet.
    • If the values are correct, launch the Siebel Upgrade Wizard (srvrupgwiz) by entering Y. The Siebel Upgrade Wizard is explained in Reviewing the Upgrade Log Files.

      NOTE:  If a program or system error occurs and you need to rerun the Siebel Upgrade Wizard, you can do so, starting at the point at which the wizard failed, by navigating to $SIEBEL_ROOT/siebsrvr/bin and typing:

      srvrupgwiz /m       master_UPGRADEOPTION_ENVIRONMENT_VERSION.ucf

      For example, to restart a development environment upgrade from Release 6.0.1 to Release 7.x, type:

      srvrupgwiz /m master_upgphys_dev_601.ucf

    • If you need to change the values you previously entered, rerun the Configuration Wizard by entering dbsrvr_config.ksh. Rerunning the Configuration Wizard will allow you to reconfigure with different values.

      The Siebel Upgrade Wizard displays a message when the upgrade is complete.

CAUTION:  The upgrade process executes in a UNIX shell. Do not click inside this shell while the upgrade is running. If you accidentally click inside the UNIX shell, the process will stop executing and you will need to restart the upgrade.


 Upgrade Guide for UNIX
 Published: 20 October 2003