Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Configuring the RDBMS >

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.

For non-upgrade deployments, after creating the Siebel Database and installing the Siebel Business Applications software, you use scripts and utilities provided with the Siebel Database Server installation to load the Siebel schema and seed data into the Siebel Database. For details, see Installing the Siebel Database Server and Configuring the Siebel Database.

See also Planning RDBMS Installation and Configuration.

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:

1. 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.
2. Create the database instance.
3. Configure parameters for the database instance.
4. (DB2 UDB) Create the database, and configure parameters for the database.
5. Configure table spaces, logspace, and other elements for the Siebel Database.
6. After you install the Siebel Gateway Name Server and Siebel Server (described in subsequent chapters), install the Siebel Database Server on a Siebel Server machine. See Installing the Siebel Database Server and Configuring the Siebel Database. (The remaining steps are described in the same chapter.)
7. On the machine where you installed the Siebel Database Server, run the Database Server Configuration Wizard to install the Siebel schema in the Siebel Database. See Configuring the Siebel Database on the RDBMS.

   This step creates Siebel objects (tables and indexes) and imports seed data in the Siebel Database.

8. Run the Database Server Configuration Wizard to import repository data into the Siebel Database. See Configuring the Siebel Database on the RDBMS.
9. Perform other tasks described in Postinstallation Tasks for the Siebel Database Server and 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.

For more information about the scripts, see:

• Guidelines for Creating DB2 UDB Database Objects
• Guidelines for Creating Oracle Database Objects