Siebel Database Upgrade Guide > Performing the Siebel Incremental Repository Merge > Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x and 8.2.2.x (SIA Repository) >

Preparing to Run the Siebel Database Configuration Wizard


This task is a step in Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x and 8.2.2.x (SIA Repository). Use this task to prepare for running the Siebel Database Configuration Wizard.

Environments: Development, production test, and production.

About the Database Configuration Utilities

The Database Configuration utilities are a group of wizards that request information about the upgrade process that you want to perform. The utilities add this information to a master upgrade file and call an SQL generator. The SQL generator uses the information to create or populate SQL files. See Table 26 for a list of the information that the utilities request when you perform an upgrade.

To prepare to run Database Configuration utilities

  1. Identify the information that you must enter when running the Database Configuration utilities.
  2. Use Table 26 as a guide to collect all the required information.

After the Database Configuration utilities exit, you run the Siebel Upgrade Wizard. The Siebel Upgrade Wizard executes the SQL files against the Siebel database. After running the Database Configuration utilities, you run the Siebel Upgrade Wizard. For information on running the Siebel Upgrade Wizard, see Preparing to Start the Siebel Upgrade Wizard.

Table 26. Information Required for the Database Configuration Utilities
Field Name or Menu
Required Information

Enterprise Server Name

The Enterprise Server name.

Siebel Server Directory

The absolute path of the directory where the Siebel Server is installed. For UNIX, do not enter the string $SIEBEL_ROOT.

Siebel Database Server Directory

The absolute path of the directory where the Siebel Database Server is installed, for example:

C:\sba81\dbsrvr

RDBMS Platform

Choose the RDBMS type: IBM DB2, MSSQL, or Oracle.

Siebel Database Operation menu

Choose Upgrade Database. The remaining menu choices are for database installation and administration.

Environment Type

Choose Development for development environment upgrades. Choose Production for production test environment and production environment upgrades.

Upgrade Options

Choose one of the following:

  • Development Environment:
    • Upgrade Siebel Database Schema (upgrep)
    • Upgrade Custom Database Schema (upgphys)
  • Production Environment. Choose Upgrade Siebel Database Schema (upgrep and upgphys).

Siebel Industry Application

Choose the industry application that you are upgrading from, such as SIA.

Current Siebel Version

Choose the application version you are upgrading from.

Choose v8_1_1SIA_To_v8_1_1_9SIA if your current Siebel CRM version is either v8.1.1GA SIA or any of the fix packs from v8.1.1.1 to v8.1.1.9. You must choose this option even if your Siebel application is on v8.1.1.10, but you have not performed an incremental repository merge in v8.1.1.10. Choose v8_1_1_10 if your current Siebel CRM version is v8.1.1.10.

Siebel Tools Installation Directory

The absolute path of the directory where the Siebel Tools is installed, such as c:\8.1\Tools.

NOTE:  This entry applies only to the Siebel Server installed on Windows.

Siebel Tools Data Source

Provide the data source name that you use to log in using Siebel Tools, such as ServerDataSrc. This entry is in SiebelTools Installation Directory\BIN\Language\tools.cfg.

Database Encoding

Indicate whether your database uses a Unicode code page.

ODBC Data Source Name

Verify the ODBC name for connecting to the Siebel database that you are upgrading. If the ODBC name is not correct, then enter the correct name.

Database User Name and Database Password

Account name and password for the Siebel administrator of the Siebel database that you are upgrading.

Database Table Owner and Database Table Owner Password

Account name and password for the Siebel database table owner.

Index Table Space Name and Table Space Name

Oracle Database and IBM DB2 database only. Index table space name and table space name (4-KB table space name for DB2).

16-KB Table Space Name, 32K Table Space Name

IBM DB2 only. The 16-KB and 32-KB tablespace names.

Database Server OS

Choose the RDBMS server operating system type.

Parallel Indexing

Is valid for Oracle Database only. Select parallel indexing if you want SQL commands for index creation to include the arguments parallel and no logging.

Parallel indexing causes an index to be created using parallel processing, which requires an RDBMS server with multiple CPUs. Verify with your database administrator whether your RDBMS server is configured for parallel processing.

Selecting parallel indexing does not cause multiple indexes to be created simultaneously, in parallel. To set up parallel indexing, you must set up parallel index-creation threads, using Siebel Upgrade Tuner. You create parallel threads as part of tuning the production upgrade files. For more information, see Tuning the Siebel Upgrade Files.

Security Group ID/Grantee

Security group or grantee name for Siebel application users. You must have select, update, insert, and delete privileges on Siebel application tables. The default value is SSE_ROLE.

Log Output Directory

Accept the default or enter the directory name. If the directory does not exist, then it will be created. Do not use special characters, such as spaces or slashes.

Select runupg option

Indicate whether you want to run the operation that you configured or run it at another time.

Siebel Database Upgrade Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.