Siebel Installation Guide for UNIX > Configuring Siebel Enterprise Server and Related Components > Troubleshooting Siebel Enterprise Server Installation and Configuration >

Troubleshooting the ODBC Data Source Connection

This topic is part of Troubleshooting Siebel Enterprise Server Installation and Configuration.

This topic describes troubleshooting steps for your ODBC data source connection.

NOTE:  If your database is DB2 UDB for z/OS, see Implementing Siebel Business Applications on DB2 UDB for z/OS.

Oracle Database

Complete the following instructions to troubleshoot Oracle connection problems on AIX, HP-UX, Linux, or Solaris.

If you are unable to verify if your ODBC connection to your Oracle database is working, verify that the value of the environment variable TNS_ADMIN is the exact path of tnsnames.ora.

To troubleshoot a failed ODBC connection on AIX, HP-UX, Linux, or Solaris

1. Verify that the Oracle connect string entered as part of Siebel Server configuration is valid.
2. If the connect string entered is correct, check the ODBCINI environment variable to verify that it was set by entering the following command:

   echo ${ODBCINI}

   The response will be the following:

   $SIEBEL_ROOT/sys/.odbc.ini

3. If the ODBCINI environment variable was correctly set, verify that the .odbc.ini file is valid by reviewing it for the presence of the following parameters:

   [EnterpriseName_DSN]
   ServerName=ora901
   Driver=$SIEBEL_ROOT/lib/SEor818.so
   ColumnsAsChar=1
   ColumnSizeAsCharacter=1

   If these parameters are not present, the file is invalid.

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

4. If the .odbc.ini file is valid, verify that the library path includes the path for the ODBC driver on your platform by entering the following command:

   AIX. Use echo ${LIBPATH}.

   HP-UX. Use echo ${SHLIB_PATH}.

   Linux and Solaris. Use echo ${LD_LIBRARY_PATH}.

   The response will be the following:

   $SIEBEL_HOME/lib

   NOTE:  Siebel applications support the Oracle 32-bit client. Therefore, if you have installed the Oracle 64-bit client on your Siebel Server, you must include $ORACLE_HOME/lib32 in your LIBPATH (AIX), SHLIB_PATH (HP-UX), or LD_LIBRARY_PATH (Linux, Solaris) variable definition. (If you require $ORACLE_HOME/lib for non-Siebel applications, make sure $ORACLE_HOME/lib32 is placed in front of $ORACLE_HOME/lib.)

5. If the response illustrated for your platform in Step 4 was correct and you are verifying a Unicode installation, make sure that the following environment variable is set according to the recommendations from your database platform vendor. This variable is also set in the siebenv.csh and siebenv.sh scripts.

   SIEBEL_UNIXUNICODE_DB=ORACLE