Siebel Database Upgrade Guide > Performing the Siebel Repository Merge >

Configuring Siebel Tools for the Repository Merge

Upgrades from: All Siebel releases.

Environments: Development environment only.

Databases: Oracle only.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

It applies to the Siebel Tools installation that you use to perform the repository merge.

If you are upgrading on Oracle 8i or 9i, you must run the development environment upgrade in Rule Based Optimization (RBO) mode. To support this mode, you must change the value of the SqlStyle parameter in the Siebel Tools configuration file.

If you are upgrading on Oracle 10g, you do not have to change the value of this parameter.

After the upgrade, if you are upgrading on Oracle 9i, you must reset the value to the default.

Before the Repository Merge

Perform this task if you plan to run the development environment upgrade in RBO mode.

To configure Siebel Tools before the repository merge

1. Exit Siebel Tools.
2. Navigate to the Siebel Tools configuration file. It is located in the following directory:

   install_dir\bin\lang\tools.cfg

   where

   • install_dir is the Siebel Tools installation directory
   • lang is the language in which Siebel Tools is installed, for example enu.
3. Open the file with a text editor and locate the section that controls connectivity to the Oracle RDBMS.

   In most cases, this is the ServerDataSrc section.

4. In this section, set the SqlStyle parameter as follows: SqlStyle = Oracle.
5. Save the file and exit.
6. Restart Siebel Tools.

After the Repository Merge

Do one of the following:

• If you are on Oracle 8i and want to continue using rule-based optimization (RBO), do not perform this task. The current setting of the parameter supports RBO.
• If you are on Oracle 8i and are using cost-based optimization (CBO), then perform this task. You must reset the parameter to support CBO.
• If you are on Oracle 9i, perform this task. You must reset the parameter to support CBO.

To reset Siebel Tools configuration after the repository merge

1. Exit Siebel Tools.
2. Navigate to the Siebel Tools configuration file you revised before the repository merge. It is located in the following directory:

   install_dir\bin\lang\tools.cfg

   where

   • install_dir is the Siebel Tools installation directory
   • lang is the language in which Siebel Tools is installed, for example enu.
3. Open the file with a text editor and locate the section containing the SqlStyle parameter that you revised.

   In most cases, this is the ServerDataSrc section.

4. In this section, set the SqlStyle parameter back to the default as follows: SqlStyle = OracleCBO.
5. Save the file and exit.
6. Restart Siebel Tools.

Related Topics

About the Siebel Repository Merge