Siebel Installation Guide for Microsoft Windows > Configuring the RDBMS >

Overview of Database Configuration

This chapter is intended for use by database administrators (DBAs) and by others who can perform the tasks for configuring the third-party RDBMS and creating the database instance that you will use for the Siebel database.

Follow the general steps for your supported RDBMS platform, as described in this chapter. For more information, see your third-party vendor documentation, the guidelines presented in this chapter for each RDBMS, and other applicable parts of this guide.

For the third-party RDMBS product versions supported for this release of Siebel Business Applications, see the Certifications tab on My Oracle Support.

For Siebel language support, Unicode support, and legacy code page support, see 1513102.1 (Article ID) for Siebel CRM version 8.1.1.x or 1524342.1 (Article ID) for Siebel CRM version 8.2.2.x on My Oracle Support.

CAUTION:  Do not perform any of the tasks mentioned in this chapter in an upgrade environment (or in another environment where you have an existing Siebel database). In particular, you do not create the database instance on the RDBMS. However, after the upgrade is complete, you might have to modify database parameters for your RDBMS platform to match settings described in this chapter. For more information, see About Installing in Upgrade Environments and Roadmap for Installing and Configuring Siebel Business Applications in an Upgrade Case (Existing Database).

For nonupgrade deployments (where there is no existing Siebel database), after creating the database instance and installing Siebel Business Applications software, you use scripts and utilities that are provided with the Database Configuration Utilities installation to create the Siebel database. Creating the Siebel database loads the Siebel schema and seed data into the database instance. For more information, see Installing the Siebel Database on the RDBMS.

See also Planning RDBMS Installation and Configuration.

In this guide, DBSRVR_ROOT refers to the installation directory of the Siebel Database Configuration Utilities. For more information, see File and Directory Naming Conventions.

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

After you have completed configuring your database as described in this chapter, you can perform all of the Siebel installation and configuration tasks, including those described in:

• Installing Siebel Enterprise Server Components and the Siebel Web Server Extension
• Configuring Siebel Enterprise Server Components and the Siebel Web Server Extension
• Installing the Siebel Database on the RDBMS
• Additional Postinstallation and Configuration Tasks

Overview of Configuring the Database

The overall process of configuring the RDBMS and installing the Siebel database is outlined as follows. The exact process depends on your deployment requirements.

1. Install the RDBMS software:
   • Install the RDBMS server software on the appropriate server computers.
   • Install the RDBMS client software on computers where you will install Siebel Server, Siebel Tools, or other modules that directly connect to the Siebel database.
2. Create the database instance.
3. Configure the parameters for the database instance.
4. (IBM DB2 and Microsoft SQL Server) Create the database, and configure the parameters for the database.
5. Configure storage settings, log space, and other elements for the Siebel database.

   NOTE:  After you perform these tasks, you install the Siebel Enterprise Server software, including Siebel Gateway Name Server, Siebel Database Configuration Utilities, and Siebel Server. You must install Database Configuration Utilities and Siebel Server on the computer where you run the Siebel Gateway Name Server; it is optional to configure and deploy this installed Siebel Server. Then you configure the Siebel Gateway Name Server, the Siebel Enterprise, and the Siebel Web Server Extension (SWSE) logical profile.

6. On the computer where you installed the Database Configuration Utilities, run the Database Configuration Wizard. Perform the task to install the Siebel database (schema) in the database instance.

   This step creates the Siebel objects (tables and indexes) in the Siebel database, imports seed data for the primary language, and adds the Siebel Repository for the primary language. Also perform the other applicable tasks for the Siebel database. For more information, see Installing the Siebel Database on the RDBMS.

   NOTE:  After you perform these tasks, you configure the Siebel Server, install and configure the SWSE, and perform additional configuration tasks that are required for your deployment.

About Using Sample Scripts for Creating Siebel Database Objects

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

Related Topics

Guidelines for Creating Oracle Database Objects

Guidelines for Creating IBM DB2 Database Objects

Guidelines for Creating Microsoft SQL Server Database Objects