Siebel Installation Guide for Microsoft Windows > Requirements for Installing and Configuring Siebel Business Applications >

Requirements for Installing and Configuring the Siebel Database

Before you install and configure the Siebel database, review the following information:

• Review database information in the Certifications tab on My Oracle Support and elsewhere.

  For Siebel CRM language support, Unicode support, and legacy code page support, see 1513102.1 (Article ID) on My Oracle Support.

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

General Requirement

Installing the Siebel database is subject to installation requirements for Siebel Database Configuration Utilities related to Siebel Gateway authentication, which are noted in General Requirements for Installing and Configuring Siebel Enterprise Server Components.

Oracle Database

For Oracle Database, make sure that the following elements are defined for your Siebel database:

• Oracle SQLNet alias connect string. Provide the name of the Oracle schema qualifier or table owner name and the SQLNet connect string for Oracle. 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 that you create. The term table owner refers to the schema that owns the database objects, such as tables, indexes, views, and triggers.

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

• Siebel data tablespace. The name of the tablespace on the Oracle Database server where the Siebel data tables are stored.
• Siebel index tablespace. The name of the tablespace on the Oracle Database server where the Siebel indexes are stored.
• Install the Oracle Database Client software onto the computer where you will install the Database Configuration Utilities.

  NOTE:  Make sure that the Oracle Database Client and Oracle Database versions are compatible, unless you are otherwise advised by Oracle Global Software Support or unless required for your particular deployment. For supported versions of Oracle Database products, see the Certifications tab on My Oracle Support.

IBM DB2

For IBM DB2, make sure that 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 or database owner account user name and password. DB2 requires that you assign a user name and password to each database that you create.

  Before you install the tablespaces and indexes, you are 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 tablespace. The name of the tablespace on the DB2 server where the Siebel indexes are stored.
• Siebel 4-KB tablespace. The name of the tablespace on the DB2 server where the 4 KB Siebel data tables are stored.
• Siebel 16-KB tablespace. The name of the tablespace on the DB2 server where tables reside whose row length is equal to or greater than 4005 bytes, but less than 16384 bytes.
• Siebel 32-KB tablespace. The name of the tablespace on the DB2 server where tables reside whose row length is 32768 bytes.
• Statistics are generated automatically during table, index, and seed data installation, and during the Siebel Repository import process. However, it is recommended that statistics be kept up to date through standard database administration procedures.
• Make sure that you have installed the required IBM fix pack on your database server computer. For more information, see the Certifications tab on My Oracle Support.
• Make sure that IBM DB2 is properly configured and you have allocated disk space appropriate to your installation requirements.

Microsoft SQL Server

For Microsoft SQL Server, make sure that the following elements are defined for your Siebel database:

• Database name. The name of the Microsoft SQL Server database that you created for Siebel Business Applications.
• Table owner account user name and password. Microsoft SQL Server requires that you assign a user name and password to any database tables that you create.

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