About Upgrading Your RDBMS in the Siebel Environment

Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

Databases: All databases.

If your currently installed RDBMS version is not supported in the new release, you must upgrade your RDBMS before performing the Siebel Database upgrade. For information on supported RDBMS versions, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

If your currently installed RDBMS version is supported in the new release, and you plan to upgrade your RDBMS, you can do so before or after upgrading your Siebel Database.

The following guidelines and requirements are for planning your RDBMS upgrade.

NOTE: When you upgrade the RDBMS, also be sure to upgrade your client database connectivity software. See Siebel System Requirements and Supported Platforms on Oracle Technology Network.

Oracle Database

See Alert 477966.1 on OracleMetalink 3 (previously published as Siebel Alert 1053) for planning information on upgrading an Oracle RDBMS. If you upgrade the Siebel Database and then upgrade the Oracle RDBMS, you must validate the Siebel Database schema after the upgrade. See Verifying an Upgraded Oracle RDBMS After a Siebel Upgrade.

Development, production test, and production upgrades on Oracle 10g can be run in CBO mode.

If you plan to upgrade your RDBMS to Oracle Database 10g, see 478028.1 (Doc ID) on OracleMetalink 3. This document was previously published as Siebel Technical Note 582. This document provides information on setting up Oracle Database 10g for use with Oracle Cost-based optimizer (CBO). Briefly, when using Oracle's Cost Based Optimization with a Siebel Database, there are some requirements for database parameter configuration and for the Optimizer's statistics generation on tables, columns and indexes.

Upgrades on Oracle8i and Oracle9i must be run in Rule-Based Optimizer (RBO) mode. If you are running in Cost-Based Optimizer (CBO) mode, you must change to RBO mode before upgrading. For Oracle9i, you must return to CBO mode after the upgrade.

Upgrades on Oracle Database 10g must be run in CBO mode.

IBM DB2

After upgrading your IBM DB2 RDBMS, you must upgrade the database instance.

The DB2 database must have 4-KB, 16-KB, and 32-KB tablespaces defined on it. Otherwise, your upgrade will not complete successfully.