1. Installation Guide
  2. Planning RDBMS Installation and Configuration

Planning RDBMS Installation and Configuration

This task is part of Planning Your Siebel Deployment.

Note the following guidelines for installing and configuring the Relational Database Management System (RDBMS) on which you will create the Siebel database.

For more information about configuring the RDBMS, see Configuring the RDBMS. For more information about configuring the Siebel database after installing Siebel Enterprise Server, see Installing the Siebel Database on the RDBMS.

  • Make sure that this release of Siebel CRM supports the exact version of your chosen RDBMS, as specified in the Certifications tab on My Oracle Support, and that the RDBMS has been installed on its designated server. This database server will hold the database tables containing your business data, such as sales (personnel, territories, opportunities, and activities), marketing, and customer service information. It will also contain Siebel Repository tables, which are used both for developing and for operating Siebel applications.

  • Verify that the network name of the server that will support the Siebel database is properly recorded in your copy of the worksheet in Siebel Deployment Planning Worksheet.

  • Installing the Siebel database, as described in Installing the Siebel Database, creates a ODBC data source name, which might be needed to provide authentication for the Siebel Management Console configuration process, as described in Configuring Siebel CRM Server Modules.

  • When you configure the Siebel Enterprise, the Siebel Management Console creates the ODBC data source name, using the name SiebelEnterpriseName_DSN. For example, if your Siebel Enterprise name is sieb21, then the ODBC data source name will be sieb21_DSN. If a data source using this name exists, then it is overwritten. Using this pattern, determine what your ODBC data source name will be and record it in your copy of the worksheet in Siebel Deployment Planning Worksheet.

    Note: In most cases, do not change any of the default ODBC settings or parameters. Otherwise, you will encounter problems using the ODBC. For example, setting OptimizeLongPerformance to enable corrupts all of the scripts in the Siebel Repository during import or export processes. For information about verifying the ODBC data source for your RDBMS platform, see Verifying the ODBC Data Source. See also Troubleshooting the ODBC Data Source Connection.

    Siebel Web Client and Siebel Tools installers also create ODBC data source names during the installation. The naming convention is different than it is for ODBC data source names created by the Siebel Management Console. For more information, see Installing Siebel Web Clients and Siebel Tools.