Upgrade Guide > Performing the Siebel Repository Merge >

Configuring Siebel Tools for the Repository Merge

Upgrades: All Siebel upgrades.

Environments: Development environment only.

Databases: Oracle only.

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

The topic applies to the Siebel Tools installation you will use to perform the repository merge.

If you are upgrading on Oracle 9i and want to run the development upgrade in Rule Based Optimization (RBO) mode, you must change the value of the SqlStyle parameter in the Siebel Tools configuration file. After the upgrade, you must reset the parameter 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

Perform this task to reset the SqlStyle parameter to the default, OracleCBO.

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.