Table 27. Information Required for the Database Configuration Utilities
|
|
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, 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 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 |
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 (where you previously had installed a new database or run Incremental Repository Merge, where applicable), based on the following criteria. For migrations to Siebel CRM version 15.5 or later:
- If your Siebel database is currently on version 15.0, then choose v15_0. Choose this option if you previously ran incremental repository merge for version 15.0 or performed a new installation.
- If your Siebel database is currently on version 8.1.1.14, then choose v8_1_1_14. Choose this option if you migrated your Siebel CRM software from version 8.1.1.14.
- If your Siebel database is currently on version 8.1.1.11, then choose v8_1_1_11. Choose this option if you migrated your Siebel CRM software from version 8.1.1.11.
- If your Siebel database is currently on version 8.1.1.10, then choose v8_1_1_10. Choose this option if you migrated your Siebel CRM software from version 8.1.1.10.
- If your Siebel database is currently on version 8.1.1.0 (SIA only) to 8.1.1.9, then choose v8_1_1SIA_To_v8_1_1_9SIA. Choose this option if you migrated your Siebel CRM software from version 8.1.1.9 or earlier.
- If your Siebel database is currently on version 8.2.2.14, then choose v8_2_2_14. Choose this option if you migrated your Siebel CRM software from version 8.2.2.14.
- If your Siebel database is currently on version 8.2.2.4, then choose v8_2_2_4. Choose this option if you migrated your Siebel CRM software from version 8.2.2.4.
- If your Siebel database is currently on version 8.2.2.3, then choose v8_2_2_3. Choose this option if you migrated your Siebel CRM software from version 8.2.2.3.
- If your Siebel database is currently on version 8.2.2.0 to 8.2.2.2, then choose v8_2_2SIA_To_v8_2_2_2SIA. Choose this option if you migrated your Siebel CRM software from version 8.2.2.2 or earlier.
|
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_TOOLS_ROOT \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. 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. |
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. |