Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Installing the Siebel Server >

Verifying the ODBC Data Source for Oracle

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.

CAUTION:  In general, do not change the default settings created automatically with the ODBC data source. However, if you have upgraded from Oracle 8i to either Oracle 9i or 10g, 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

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 DSN 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:

   [SiebSrvr_EnterpriseName]
   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.

   The ServerName should be the Oracle connect string you entered while installing the Siebel Server. (To verify this connect string, run sqlplus.) The driver should 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 are using Siebel Marketing, which requires simultaneous heterogeneous database connectivity, you need to 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 user_name /p password /s ODBC_DSN

   where:

   • ODBC_DSN = The ODBC data source name, in the form siebsrvr_enterprisename, 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 Troubleshooting the ODBC Data Source Connection.