Siebel Database Upgrade Guide > Upgrading the Siebel Database >

Preparing to Run the Siebel Database Configuration Wizard


Environments: Development, production test, production.

Use this topic to identify the information you must enter when running the Database Configuration Utilities. Collect this information, and verify that it is correct before running the utilities.

NOTE:  If you are running Siebel CRM version 8.1.1 (SEA), and want to migrate to Siebel CRM version 8.1.1 (SIA), then you do so with the Database Configuration Wizard.

The Database Configuration Utilities are a group of wizards that request information about the upgrade process 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:

  • Table 18 lists the information that the utilities request for performing an upgrade.
  • Table 19 lists the additional information specific to Additive Schema Changes mode.

After the Database Configuration Wizard exits you run the Upgrade Wizard. The Upgrade Wizard executes the SQL files against the Siebel database.

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

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 (Siebel Database Configuration Utilities) is installed. For example: C:\sba81\dbsrvr

RDBMS Platform

Choose the RDBMS type: IBM DB2, Microsoft SQL Server, or Oracle Database.

NOTE:  For IBM DB2 for z/OS, see Siebel Database Upgrade Guide for DB2 for z/OS instead of this guide.

Siebel Database Operation menu

For upgrep, upgphys and Prepare for Production modes, choose Upgrade Database.

For Apply Additive Schema Changes mode, choose Apply Additive Schema Changes.

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:
    • Upgrade Siebel Database Schema (upgrep and upgphys)

Siebel Industry Application

As appropriate for the environment you are upgrading from, choose SIA (for Siebel Industry Applications) or SEA (for Siebel Business Applications, also known as Siebel Cross-Industry Applications).

Current Siebel Version

Choose the option for the application version that you are upgrading your Siebel database from. For more information about valid options for performing a full database upgrade, see Supported Upgrade Paths for Siebel CRM Version 17.0.

For information about specifying options for performing an Incremental Repository Merge instead, see Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x (SIA Repository), 8.2.2.x, 15.x, and 16.x.

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.

NOTE:  For more information about supported characters for Siebel passwords, see Siebel Security Guide. See also relevant articles on My Oracle Support, such as 1931241.1 (Article ID).

Database Table Owner and Database Table Owner Password

Account name and password for the Siebel database table owner.

NOTE:  For more information about supported characters for Siebel passwords, see Siebel Security Guide. See also relevant articles on My Oracle Support, such as 1931241.1 (Article ID).

Index Table Space Name and Table Space Name

Oracle Database and IBM DB2 only. Index tablespace name and tablespace name (4-KB tablespace name for IBM 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

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 processors. Verify with your database administrator whether your RDBMS server is configured for parallel processing.

TIP:   Oracle Library search phrase: parallel execution.

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. Must have select, update, insert, and delete privileges on Siebel application tables. Specify SSE_ROLE.

Custom Scripts Directory

During the upgrade process, the Repository Sanitization script is executed. This script scans the prior customer repository to check if there are any unreferenced repository objects across multiple applications. The unused objects are then inactivated. If a repository object is referred to in a custom script, it will not be a candidate for inactivation.

Custom files have to be copied from the following locations:

For IP2015 and prior releases:

<SWSE HOME>\public\<LANG>\<BUILD#> \scripts\siebel\custom

For IP2016:

<SWSE HOME>\public\scripts\<LANG>/siebel/custom

In addition, copy every language required into a directory and specify that location.

Web Templates Directory

Directory where the custom web templates are stored. With IP2017 onwards, web templates are stored in the database.

Custom web templates must be moved to the database as well. Therefore, a step is executed during the upgrade process that moves all the web templates specified in this particular location to the database.

You must copy over the files of the previous release from:

<SES>\siebsrvr\webtempl

In addition, copy all files into a single directory and specify that location.

Verify Repository After Upgrade

Indicate whether you want to execute the steps to verify the repository during upgphys. To perform upgphys separately, select the Verify Repository After Upgrade option in the Database Configuration Wizard.

Upgrep log directory

If you select the option Verify Repository After Upgrade in the previous step, then you will have to provide the log directory of the upgrep process. The log directory is of the form $SIEBEL_ROOT/siebsrvr/log/upgrep_dev_UpgradeNumber. For example: C:\ses\siebsrvr\log\upgrep_dev_811. The log directory path is a requirement for generating the seed data conflict report.

Log Output Directory

Specify a different subdirectory, under the log directory, in which to create the log files. 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 you configured or run it at another time.

Additional Information Required for Apply Additive Schema Changes Mode

You can optionally run the Database Configuration Utilities in Apply Additive Schema Changes mode. Additive Schema Changes generates an SQL script, schema.additive.sql. The script contains production upgrep schema changes that can be performed while the database is online. This reduces the amount of time required for the upgrep when the database is offline.

The additional information shown in Table 19 is required when you run the Database Configuration Utilities in Apply Additive Schema Changes mode.

Table 19. Additional Information Required for Apply Additive Schema Changes Mode
Field Name
Required Information

Schema File

The absolute path to the schema.ddl file. If a path is displayed, then verify that schema.ddl is located in this directory.

Output Directory

The absolute path to the directory where schema.additive.sql will be placed after the Upgrade Wizard generates it. The Upgrade Wizard also places the log file in this directory.

Related Topics

About the Siebel Database Configuration Wizard Utilities

About Siebel Additive Schema Changes Mode

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