Bookshelf v7.5: Upgrading the Siebel Database Schema

Upgrading the Siebel Database Schema

The Siebel Upgrade Wizard is restartable at most stages within the upgrade process. For information about restartability, see Restarting the Upgrade.

To configure the Siebel Database Schema on supported UNIX platforms

Verify that all servers are stopped:

Stop all Siebel Servers by typing: stop_server all
Stop the Siebel Gateway by typing: stop_ns

Depending on your shell, source environment variables from $SIEBSRVR_ROOT by typing:

Korn shell

. siebenv.sh

C shell

source siebenv.csh

Set the following environment variables from the SIEBSRVR_ROOT directory:

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

Navigate to $SIEBSRVR_ROOT/bin and enter:

dbsrvr_config.ksh

This launches the Database Server Configuration Wizard.

Review the values of the following environment variables and confirm whether the settings are correct by entering either Y or N.

SIEBEL_ROOT
LANGUAGE
NOTE: If either the SIEBEL_ROOT or LANGUAGE value is not set or is incorrect, you must correct them before proceeding.

At the Siebel Server Directory prompt, enter the path of your Siebel Server root directory, or accept the default by pressing Enter.

At the Siebel Database Server Directory prompt, enter the path of your database server root directory, or accept the default by pressing Enter.

At the RDBMS Platform prompt, enter the number that corresponds to the database platform that you are upgrading.

1 - IBM DB2 UDB for Unix and Windows.

2 - Oracle.

At the Siebel Database Operation prompt, choose Upgrade Database (2).

At the Upgrade Options prompt, choose Upgrade Siebel Database Schema (1).

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.

If you are upgrading a Siebel Industry Application or Siebel Financial Services Application, enter the number that corresponds to 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 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.
Siebel Application. Choose this if you are upgrading from Release 7.5 of Siebel eBusiness Applications to Release 7.5 of a Siebel Industry Application.

At the Current Siebel Version prompt, enter the number that corresponds to the version of Siebel you are upgrading from.

At the Language Selection prompt, enter the number that corresponds to the appropriate language.

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

NOTE: 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.

At the Database User Name prompt, enter the database user name and password for your database:

Database User Name. User name of the Siebel administrator, for example, sadmin.
Database Password. Password for the Siebel administrator, for example, db2.

At the Database Table Owner 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.

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

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

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 previous steps.

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.ucffor example, srvrupgwiz /m master_upgrep_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.