Upgrade Guide > Preparing an Oracle Database for a Siebel Upgrade >

Verifying the Oracle Database ODBC Definition for a Siebel Upgrade

Upgrades: All Siebel upgrades.

Environments: Development, production test, production.

Databases: Oracle only.

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

When you install a Siebel Server, the installer creates the ODBC definition for the Oracle database you specify.

When you upgrade your production test environment and your production environment, you must manually create an ODBC definition for connecting to your development environment database. If the development environment database is Oracle 9i, you must edit the ODBC definition after it has been created.

To verify or edit an ODBC definition under Windows

1. Start the registry editor (regedit).

   CAUTION:  Editing the registry can adversely affect the operating system. Be sure you understand how to use regedit correctly.

2. Navigate to the following location:

   HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC_Name

   Where:

   ODBC_Name is the ODBC name for the Oracle database.

3. In the data display pane, verify that the following entries are present:

If these entries are not present, right-click in the data display pane and choose New > String Value to add them.

4. Step off the ODBC_Name and return to it. Verify that the two new entries are present and correct.
5. Close the Registry Editor and reboot.

To verify or edit an ODBC definition under UNIX

1. Navigate to the following file in the Siebel Server installation directory:

   $SIEBEL_ROOT/sys/.odbc.ini

2. Open the .odbc.ini file and add the following two entries:

   ColumnsAsChar=1

   ColumnSizeAsCharacter=1

3. Save the file.
4. Stop and restart any processes that are using this .odbc.ini file.