Siebel Installation Guide for UNIX > Configuring Siebel Enterprise Server and Related Components > Verifying the ODBC Data Source >

Verifying the ODBC Data Source for Oracle

This topic is part of Verifying the ODBC Data Source.

The Siebel Server installation program automatically creates an ODBC system data source name (DSN) that it uses to connect to the Siebel Database on the RDBMS. Prior to verifying the Siebel Server ODBC data source, make sure that the Siebel Server service is started.

Information in this topic applies also to virtual ODBC data sources in a clustered environment.

CAUTION:  In general, do not change the default settings created automatically with the ODBC data source. However, if you have upgraded from Oracle 8i or 9i (RBO) to Oracle 10g (CBO), or if you manually created your ODBC, it is critical that you check your ODBC settings, as shown in the following procedure.

For more information about the ODBC data source, see Planning RDBMS Installation and Configuration.

To verify the ODBC data source for Oracle (on UNIX)

1. Navigate to the file $SIEBEL_HOME/sys/.odbc.ini, and open this file for editing.
2. Locate the section of the file containing a reference to ServerName and Driver.

   This section defines the ODBC data source for Siebel Server. A sample section is represented in the following example. The ServerName, Driver, ColumnsAsChar, and ColumnSizeAsCharacter parameters are the most critical for this procedure:

   [EnterpriseName_DSN]
   Description=Oracle901
   ServerName=dvlsun6
   Driver=$SIEBEL_HOME/lib/SEor818.so
   ColumnsAsChar=1
   ColumnSizeAsCharacter=1

   CAUTION:  The ColumnsAsChar and ColumnSizeAsCharacter parameter settings are required, in order for the ODBC driver to behave correctly.

   ServerName is the Oracle connect string you entered while installing the Siebel Server. (To verify this connect string, run sqlplus.) The driver must point to $SIEBEL_HOME/lib/SEor818.so, allowing you to verify the existence of this file.

3. Verify that the SIEBEL_UNIXUNICODE_DB environment variable is set to ORACLE.

   NOTE:  If you use Siebel Marketing, which requires simultaneous heterogeneous database connectivity, set this variable to ORACLE, regardless of your database platform.

4. Source the siebenv.csh (C shell) or siebenv.sh (Korn or Bourne shell) file.
5. Test the connection by navigating to $SIEBEL_HOME/bin and entering the command:

   odbcsql /u database_account_name /p password /s ODBC_DSN

   where:

   • database_account_name = A valid database account name
   • password = The corresponding database account password
   • ODBC_DSN = The ODBC data source name, in the form EnterpriseName_DSN, where EnterpriseName is the name of your Siebel Enterprise

     If you do not receive an error message, the ODBC connection is working.

     If your ODBC DSN is not working, the program exits with an error message. For more information, see Verifying Network Connectivity for the Siebel Server Machine and Troubleshooting the ODBC Data Source Connection.