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

Troubleshooting the ODBC Data Source Connection

This section 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

Complete the following instructions to troubleshoot Oracle connection problems on Solaris, AIX, and HP-UX. If you are unable to verify if your ODBC connection to your Oracle database is working, you should verify that the value of the environment variable TNS_ADMIN is the exact path of tnsnames.ora.

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

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

   [SiebSrvr_EnterpriseName]
   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 9i, 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:

   Solaris. Use echo ${LD_LIBRARY_PATH}.

   AIX. Use echo ${LIBPATH}.

   HP-UX. Use echo ${SHLIB_PATH}.

   The response should be $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 LD_LIBRARY_PATH (Solaris), SHLIB_PATH (HP-UX), or LIBPATH (AIX) 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 variables are set according to the recommendations from your database platform vendor. These variables should also be set in the siebenv.csh and siebenv.sh scripts.

SIEBEL_UNIXUNICODE_DB=ORACLE