Siebel Database Upgrade Guide > Siebel Database and UI Upgrade Planning >

About Upgrading Your RDBMS in the Siebel Environment

Upgrades from: All 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 System Requirements and Supported Platforms on Siebel SupportWeb.

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 System Requirements and Supported Platforms on Siebel SupportWeb.

Oracle

• See Alert 1053 on Siebel SupportWeb 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.
• If you plan to upgrade your RDBMS to Oracle 10g as part of upgrading to Siebel 7.7.2, see Technical Note 640 for instructions on how to run the Siebel Software Configuration utility. For a full discussion on how to install a Siebel Release, see Siebel Installation Guide for the operating system you are using.
• Upgrades on Oracle versions 8i and 9i 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 Oracle 9i, you must return to CBO mode after the upgrade.
• Upgrades on Oracle 10g must be run in CBO mode.
• Oracle's Siebel applications support Oracle 8i databases for Western European and Japanese languages only. For all other languages (such as Korean), Siebel applications support a Unicode character set for Oracle 9i.

  If you are using an Oracle 8i database with a language other than Western European or Japanese, you must upgrade your Oracle database software to Oracle 9i before performing the Siebel Database upgrade. After the Siebel Database upgrade, contact Oracle's Siebel Technical Support or Oracle's Siebel Expert Services to migrate from a non-Unicode code page (or character set) to Unicode.

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.
• If you are upgrading from Siebel 6.x, you must install a new set of stored procedures and user-defined functions on the DB2 RDBMS server.