Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools > Installing the Siebel Database Server and Configuring the Siebel Database >

Preinstallation Tasks for the Siebel Database Server

Before installing the Siebel Database Server, you must complete the following tasks:

• Review Process of Installing the Siebel Database Server.

  CAUTION:  In an upgrade environment, you install the Siebel Database Server on the Siebel Server, following the procedure in Installing the Siebel Database Server on the Siebel Server, but you do not perform any of the other tasks mentioned in this chapter. For more information, see About Installing in Upgrade Environments.

• Obtain the services of a qualified database administrator 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.
• If you already installed the Siebel Server on which you will install the Siebel Database Server, make sure that all the language packs you require are first installed on this Siebel Server. If you require additional languages, install your software using one of the following methods:
  • Add languages to the Siebel Server. Then install the Siebel Database Server, which installs the same languages installed on the Siebel Server.
  • Install the Siebel Database Server, which installs the same languages installed on the Siebel Server. Then add languages to both the Siebel Server and Siebel Database Server, using the Siebel Enterprise Server installer. Adding languages installs them for all products installed under the same SIEBEL_ROOT directory.

    NOTE:  You can include languages in a new installation of the Siebel Database on the RDBMS, or add them to an existing Siebel Database later. For details, see Installing the Siebel Database Components.

• Complete the appropriate RDBMS-specific information in your copy of the worksheet in Deployment Planning Worksheet as shown below.
• Review the issues described in Managing Temporary Disk Space Required by Installers. For example, make sure you have adequate disk space.

DB2 UDB

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

• Database alias. This is the appropriate 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. Before installing the table spaces and indexes, you will be prompted to edit the grantusr.sql script and enter this information. SIEBEL is the default table owner account user name and password for Siebel applications.
• 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.
• In Siebel Business Applications, release 7.x, statistics are generated automatically during table, index, and seed data installation for DB2 UDB, 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 System Requirements and Supported Platforms on Siebel SupportWeb.
• Make sure that IBM DB2 UDB is properly configured and you have allocated disk space appropriate to your installation requirements.

Oracle

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. Oracle 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. Prior to installing the Siebel Database components, you need to edit the grantusr.sql script and enter this information. SIEBEL is the default Table Owner Account user name and password for Siebel applications.
• Siebel data table space. The name of the default table space on the Oracle server where the Siebel data tables are stored.
• Siebel index table space. The name of the default table space on the Oracle server where the Siebel indexes are stored.
• Install Oracle database client software onto the machine where you will install the Siebel Database Server.

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

MS SQL Server

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

• Database name. This is the name of the SQL Server database that you created for the Siebel application.
• Table owner account user name and password. SQL Server requires that you assign a user name and password to any database tables you create. Before installing the Siebel Database components, you need to edit the grantusr.sql script and enter this information. SIEBEL is the default table owner account user name and password for Siebel applications.