Siebel Installation Guide for UNIX > Configuring the Siebel Database >

Requirements for Siebel Database Configuration

Before you configure the Siebel Database, review the following information:

• Review Process of Configuring the Siebel Database.
• Obtain the services of a qualified database administrator (DBA) to assist you with your installation and, where applicable, upgrade.
• For new installations, make sure that the Siebel Database instance has been created and is properly configured, as documented in Configuring the RDBMS.
• Complete the appropriate RDBMS-specific information in your copy of the worksheet in Deployment Planning Worksheet as shown below.

Oracle Database

Make sure the following elements are defined for your Siebel Database:

• Oracle SQLNet alias connect string. You need this to connect to your Oracle database.
• Table owner account (schema) name and password. Using an Oracle Database requires that you assign a user name and password to any database tables you create. The term table owner refers to the schema that owns the database objects, such as tables, indexes, views, and triggers. SIEBEL is the default Table Owner Account user name and password for Siebel applications.

  Prior to installing the Siebel Database components, you need to edit the grantusr.sql script, enter this and related information, and execute the script. See Creating Table Owner and Administrator Accounts.

• Siebel data table space. The name of the default table space on the Oracle Database server where the Siebel data tables are stored.
• Siebel index table space. The name of the default table space on the Oracle Database server where the Siebel indexes are stored.
• Install Oracle database client software onto the machine where you will install the Database Configuration Utilities. Make sure that you have set the ORACLE_HOME variable appropriately before installing the Siebel software.

  NOTE:  Oracle database client and Oracle database versions must be the same. For supported versions of Oracle, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.

DB2 UDB

Make sure the following elements are defined for your Siebel Database:

• Database alias. The DB2 database alias that you created when you installed the DB2 software.
• Table owner/database owner account user name and password. DB2 UDB requires that you assign a user name and password to each database you create. SIEBEL is the default table owner account user name and password for Siebel applications.

  Before installing the table spaces and indexes, you will be prompted to edit the grantusr.sql script, enter this and related information, and execute the script. See Creating Table Owner and Administrator Accounts.

• Siebel index table space. The name of the table space on the DB2 UDB server where the Siebel indexes are stored.
• Siebel 4-KB table space. The name of the table space on the DB2 UDB server where the 4 KB Siebel data tables are stored.
• Siebel 16-KB table space. The name of the table space on the DB2 UDB server where tables reside whose row length is equal to or greater than 4005 bytes, but less than 16384 bytes.
• Siebel 32-KB table space. The name of the table space on the DB2 UDB server where tables reside whose row length is 32768 bytes.
• Statistics are generated automatically during table, index, and seed data installation, and during the repository import process. However, it is recommended that statistics be kept up to date through standard database administration procedures.
• Make sure you have installed the required IBM fix pack on your database server machine. For more information, see Siebel System Requirements and Supported Platforms on Oracle Technology Network.
• Make sure that IBM DB2 UDB is properly configured and you have allocated disk space appropriate to your installation requirements.