Overview of Database Configuration

In general, each customer must follow these general steps for each supported RDBMS platform described in this chapter. For more information, see your third-party vendor documentation, guidelines presented in this chapter for each RDBMS, and other applicable parts of this book.

CAUTION: In an upgrade environment, you do not perform any tasks mentioned in this chapter. In particular, you do not create the database instance on the RDBMS. However, after the upgrade is complete, you may need to modify database parameters for your RDBMS platform to match settings described in this chapter. For more information, see About Installing in Upgrade Environments.

NOTE: In general, it may be easier to configure and administer a Siebel Database that does not share a database instance with other applications, and this approach is considered a best practice. However, some customers may decide to include multiple applications in a single database instance. The implications of this choice may differ by RDBMS type: for example, the term database instance has a different meaning for Oracle than it does for DB2 UDB. The shared database instance must be configured according to requirements described here.

CAUTION: Changing the Siebel schema requires changing referential integrity rules for business components and Siebel EIM interface tables, using Siebel Tools. Failure to make the appropriate changes in the Siebel schema can lead to data corruption. Changing the Siebel schema also requires changing assignment objects, dock objects (for data access or visibility), import objects, and integration objects, also using Siebel Tools. Failure to make the appropriate changes can lead to functional deficiencies in the application and, in severe cases, may prevent you from starting the application. Customers are advised to seek the help of Siebel Expert Services when planning to modify the Siebel schema.

Process of Configuring the Database

The process of configuring the database is outlined below:

Install the RDBMS software:

Install RDBMS server software on the appropriate server machines.

Install RDBMS client software on machines where you will install Siebel Server, Siebel Tools, or other products that will connect to the Siebel Database.

Create the database instance.

Configure parameters for the database instance.

(DB2 UDB) Create the database, and configure parameters for the database.

Configure table spaces, logspace, and other elements for the Siebel Database.

About Using Sample Scripts for Creating Siebel Database Objects

Sample scripts provided with the Siebel Database Server installation can optionally be used to create the Siebel Database and install the Siebel schema. These scripts are for testing purposes in small, nonproduction environments only. If you intend to use such a script, first perform the tasks above, through Step 6, but omit Step 4 and Step 5.