Configuring Siebel Server Connectivity to the Siebel Database

Review this topic to configure connectivity to the Siebel database from the computer where you will install Siebel Server.

The database will already have been created, as described in this chapter.

For database connectivity software requirements, see the Certifications tab on My Oracle Support.

Oracle Database

Verify that the Oracle Database connectivity software is installed on each computer, according to the Oracle Database documentation.

Siebel Server connections to the Oracle Database are made through dedicated server processes rather than through Oracle MTS; the use of MTS might negatively affect performance.

Use Oracle’s Easy Configuration utility to define a database alias with the proper connection information for your Siebel database. Record the connect string in Siebel Deployment Planning Worksheet. You specify this connect string when configuring the Siebel Enterprise.

Note: (UNIX) 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.

IBM DB2

Define a database alias with the proper connection information for your Siebel database. Record the connect string in Siebel Deployment Planning Worksheet. You specify this connect string when configuring the Siebel Enterprise.

You can use the DB2 command line processor to define your database alias. For more information, see IBM DB2 documentation.

IBM DB2 for z/OS

For information about configuring database connectivity for IBM DB2 for z/OS, see Implementing Siebel Business Applications on DB2 for z/OS.

Microsoft SQL Server

No configuration is required after the Microsoft SQL Server ODBC driver has been installed on each computer, as specified in the Certifications tab on My Oracle Support.

Siebel CRM automatically creates an ODBC data source using connectivity parameters that you specify when configuring the Siebel Enterprise. Record this data source in Siebel Deployment Planning Worksheet.

Note: For Microsoft SQL Server deployments, valid versions of SQL Server Native Client and Microsoft Data Access Components (MDAC) must reside on the server computer where you will install the Siebel Server. For more information, see the Certifications tab on My Oracle Support.