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
- Navigate to the file $SIEBEL_HOME/sys/.odbc.ini, and open this file for editing.
- Locate the section of the file containing a reference to
This section defines the ODBC DSN for Siebel Server. A sample section is represented in the following example. The
ColumnSizeAsCharacter parameters are the most critical for this procedure:
ColumnSizeAsCharacter parameter settings are required, in order for the ODBC driver to behave correctly.
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.
- Verify that the
SIEBEL_UNIXUNICODE_DB environment variable is set to
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.
- Source the siebenv.csh (C shell) or siebenv.sh (Korn or Bourne shell) file.
- Test the connection by navigating to $SIEBEL_HOME/bin and entering the command:
odbcsql /u user_name /p password /s ODBC_DSN
- ODBC_DSN = The ODBC data source name, in the form
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.