Siebel Database Upgrade Guide > Siebel Database Upgrade Planning >

About Upgrading Your RDBMS in the Siebel Environment

Environments: Development, production test, production.

If your currently installed RDBMS version is not supported in the new release, then 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.

NOTE:  For Siebel CRM product releases 8.1.1.9 and later and for 8.2.2.2 and later, the system requirements and supported platform certifications are available from the Certification tab on My Oracle Support. For information about the Certification application, see article 1492194.1 (Article ID) on My Oracle Support.

If your currently installed RDBMS version is supported in the new release, and you plan to upgrade your RDBMS, then 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. For Siebel CRM product releases 8.1.1.9 and later and for 8.2.2.2 and later, the system requirements and supported platform certifications are available from the Certification tab on My Oracle Support. For information about the Certification application, see article 1492194.1 (Article ID) on My Oracle Support.

Oracle Database

The following guidelines and requirements are for planning your upgrade on Oracle Database.

• See Article ID 477966.1 on My Oracle Support (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, then 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 Database 11g, can be run in CBO mode.
• If you plan to upgrade your RDBMS to Oracle Database 10g, then see 781927.1 (Article ID) on My Oracle Support. 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.

IBM DB2

The following guidelines and requirements are for planning your upgrade on 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.