Preparing to Run the Siebel Database Configuration Wizard

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

Environments: Development, Test and Production.

To prepare to run Database Configuration utilities

Identify the information that you must enter when running the Database Configuration utilities.
Use the following table as a guide to collect all the required information.

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

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 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	Choose Upgrade Database. The remaining menu choices are for database installation and administration.
Environment Type	Choose Development for development environment upgrades. Choose Production for 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 repository version that you are upgrading - for more information, see Determining Your Repository Version. Note: Your repository version may not match your binary version. For example, customers on Siebel CRM 15.5 who have not run an Incremental Repository Merge from Siebel CRM 15.0 will still be on repository version 15.0.
Siebel Tools Installation Directory	The absolute path of the directory where Siebel Tools is installed, such as `c:\Siebel\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 `$SIEBEL_HOME\BIN\lang_code\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. Note: For more information about supported characters for Siebel passwords, see Siebel Security Guide.
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.
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 checks the Prior Customer Repository for any unreferenced Repository objects across multiple applications. The unused objects are inactivated. If a Repository Object refers to in a custom script, it will not be a candidate for inactivation. Custom files have to be copied from the following locations: For Siebel CRM 15.x and prior releases: `<SWSE HOME>\public\<LANG>\<BUILD#>\scripts\siebel\custom` For Siebel CRM 16.x: `<SWSE HOME>\public\scripts\<LANG>/siebel/custom` In addition, copy every language required into a directory and specify that location here.
Web Templates Directory	Directory where the custom web templates are stored. From Siebel CRM 17.0 onwards, web templates are stored in the database. Since custom web templates must be moved to the database as well, 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 custom files from previous releases from: `<SES>\siebsrvr\webtempl` Copy all the custom files into a single directory and then specify that location in the upgrade path when prompted.
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 that you configured or run it at another time.