|
Siebel Installation Guide for UNIX > Verifying and Troubleshooting Your Installation >
Troubleshooting the ODBC Data Source Connection
This topic describes troubleshooting steps for your ODBC data source connection. NOTE: If your database is IBM DB2 for z/OS, then see Implementing Siebel Business Applications on DB2 for z/OS.
This topic has the following information:
Troubleshooting Connection Problems on Oracle Database
Complete the following instructions to troubleshoot Oracle Database connection problems on AIX, HP-UX, Linux, or Oracle Solaris. See also Configuring Siebel Server Connectivity to the Siebel Database. If you are unable to verify if your ODBC connection to your Oracle Database is working, then verify that the value of the environment variable TNS_ADMIN is the exact path of tnsnames.ora. To troubleshoot a failed ODBC connection for Oracle Database on AIX, HP-UX, Linux, or Oracle Solaris
- Verify that the Oracle connect string entered as part of Siebel Enterprise configuration is valid.
- If the connect string entered is correct, then check the ODBCINI environment variable to verify that it was set by entering the following command:
echo ${ODBCINI}
The following response appears:
$SIEBEL_ROOT/sys/.odbc.ini
- If the ODBCINI environment variable was correctly set, then verify that the .odbc.ini file is valid by reviewing it for the presence of the following parameters:
[EnterpriseName_DSN]
ServerName=oraDB4
Driver=$SIEBEL_ROOT/lib/SEor827.so
ColumnsAsChar=1
ColumnSizeAsCharacter=1
CAUTION: The ColumnsAsChar and ColumnSizeAsCharacter parameter settings are required in order for the ODBC driver to behave correctly.
- If the .odbc.ini file is valid, then verify that the library path includes the path for the ODBC driver on your operating system by entering the following command:
AIX. Use echo ${LIBPATH}.
HP-UX. Use echo ${SHLIB_PATH}.
Linux and Oracle Solaris. Use echo ${LD_LIBRARY_PATH}.
The following response appears:
$SIEBEL_HOME/lib
NOTE: Siebel CRM supports the Oracle 32-bit client. Therefore, if you have installed the Oracle 64-bit client on your Siebel Server, then you must include $ORACLE_HOME/lib32 in your definition for the LIBPATH (AIX), SHLIB_PATH (HP-UX), or LD_LIBRARY_PATH (Linux or Oracle Solaris) environment variable. (If you require $ORACLE_HOME/lib for non-Siebel applications, then make sure that $ORACLE_HOME/lib32 is placed in front of $ORACLE_HOME/lib.)
- If the response illustrated for your operating system in Step 4 was correct and you are verifying a Unicode installation, then make sure that the following environment variable is set according to the recommendations from your database platform vendor.
SIEBEL_UNIXUNICODE_DB=ORACLE
This variable is also set in the siebenv.csh (for C shell) and siebenv.sh (for Bourne or Korn shell) scripts.
Troubleshooting Connection Problems on IBM DB2
Complete the following instructions to troubleshoot IBM DB2 connection problems. See also Configuring Siebel Server Connectivity to the Siebel Database. To troubleshoot a failed ODBC connection for IBM DB2
- Verify that the data source name (SiebelEnterpriseName_DSN) that you entered during the Siebel Server configuration was valid. Also verify that the required IBM DB2 client version is available on the computer and verify that the IBM DB2 catalog step has been completed correctly.
|
