Siebel Installation Guide for Microsoft Windows > Installing the Siebel Database on the RDBMS >

Installing the Siebel Database


This topic describes how to install the Siebel database on the RDBMS. This task is a step in Roadmap for Installing and Configuring Siebel Business Applications for a New Deployment. (Also perform all of the other applicable tasks in this chapter.)

To install Siebel database components

  1. Review About Installing the Siebel Database.

    See also the referenced information such as the relevant information about the Siebel Configuration Wizards in Configuring Siebel Enterprise Server Components and the Siebel Web Server Extension.

  2. Start the Database Configuration Wizard, as described in Starting a Siebel Configuration Wizard. Choose Start, All Programs, Siebel Enterprise Server 15.0, and then Database Server Configuration.
  3. Specify the following, and click Next:

    Siebel Server Directory. Accept the default path, or click Browse to select a different Siebel Server installation location. The location that you specify is the SIEBSRVR_ROOT installation directory. For example, this directory might be C:\siebel\15.0.0.0.0\ses\siebsrvr.

    Siebel Database Server Directory. Accept the default path, or click Browse to select a different location. The location that you specify is the Siebel Database Configuration Utilities installation directory (the DBSRVR_ROOT directory). For example, this directory might be C:\siebel\15.0.0.0.0\ses\dbsrvr.

  4. On the RDBMS Platform screen, select one of the following platforms, and click Next:

    IBM DB2 UDB for Linux UNIX Windows
    IBM DB2 UDB for z/OS
    Microsoft SQL Server
    Oracle Database Enterprise Edition

  5. On the Siebel Database Operation screen, select Install Database from the list, and click Next.
  6. On the Select Installation Operation screen, select Install Siebel Database to install a new Siebel database, or select Add a Language to an Existing Siebel Database, and then click Next.

    The Install Siebel Database option creates the Siebel schema and inserts seed data and Siebel Repository data for the primary language at the end of the Configuration Wizard session.

    If you instead selected Add a Language to an Existing Siebel Database, then go to Step 10. You must have included the language when you installed the Siebel Server and Database Configuration Utilities. For more information, see Installing and Deploying Siebel Business Applications with Multiple Languages.

  7. On the next screen, confirm that you want to install a new Siebel database, or indicate that you already have a Siebel database.
  8. On the Siebel User/Role Creation screen, confirm that you (or a database administrator) have already run the grantusr.sql script to set up table owner and administrator accounts.

    NOTE:  The table owner and administrator accounts must be in place or you will not be able to complete the installation of the tables, indexes, and seed data in the Siebel database. For more information, see Creating Table Owner and Administrator Accounts.

    • If you already ran grantusr.sql, then select the corresponding option, and click Next.
    • If you did not already run grantusr.sql, then exit the Database Configuration Wizard, and run the script now. When the script has finished executing, restart the Database Configuration Wizard.
  9. On the Database Encoding screen, identify the appropriate database encoding method, and click Next:

    UNICODE Database
    Non-UNICODE Database

    CAUTION:  Choose the correct option for your database to prevent installing the wrong data types. The database cannot create Unicode data types on a non-Unicode page setting, so check this setting carefully before choosing this option.

    NOTE:  Before you select languages in the next two steps, review the information about code pages in Planning RDBMS Installation and Configuration.

  10. On the Base Language screen, specify which language serves as the primary language (base language) for the Siebel database.

    NOTE:  If you installed a single Siebel language pack on the Siebel Server where you also installed Database Configuration Utilities, then that language is assumed for a new database installation. Neither the Base Language nor the Language Selection screen appears. Go to Step 12.

    The languages listed in this screen are those for which you previously installed Siebel language packs on the Siebel Server where you also installed Database Configuration Utilities. Do one of the following, and click Next:

    • If you are installing a new Siebel database, then specify the language that will be the primary language. Seed data and Siebel Repository data will be installed for this language. Go to Step 12. (The Language Selection screen does not appear in this case.)
    • If you are adding a language to an existing Siebel database, then specify the language that you already installed as the primary language. Go to the next step to specify the additional language to install, from the Language Selection screen.
  11. (Add Language case only) On the Language Selection screen, select the language that you want to install in the Siebel database, for an Add Language operation.

    NOTE:  This screen does not appear for a new database install case. Go to the next step.

    The languages listed in this screen are those for which you previously installed Siebel language packs on the Siebel Server where you also installed Database Configuration Utilities.

    Select the language that you want to add. Seed data will be installed for this language. You must import the Siebel Repository for this language separately (using the Add Language to an Existing Repository task), as described in Importing a Siebel Repository Manually into the Siebel Database.

    Some of the remaining screens do not apply for an add-language operation. Go to the next applicable step.

  12. On the ODBC Data Source Name screen, indicate the name for the ODBC data source, such as sieb15_DSN, and click Next.

    For more information about the ODBC data source, see Planning RDBMS Installation and Configuration.

  13. Specify the following, and click Next:

    Database User Name. Type the user name of the Siebel administrator; for example, sadmin.

    Database Password. Type the password for the Siebel administrator.

    Database Password (confirm). Retype the password to confirm it.

  14. Specify the following, and click Next:

    Database Table Owner. Type the name of the Siebel database table owner or the account that will own the Siebel objects.

    Database Table Owner Password. Type the password for the Siebel database table owner.

    Database Table Owner Password (confirm). Retype the password to confirm it.

  15. (IBM DB2 only) Specify the following, and click Next:

    Index Table Space Name. Type the name for your index tablespace; for example, SBL_INDX. (Tablespace names must not contain spaces; underscores are allowed.)

    4K Table Space Name. Type the name for your 4-KB tablespace; for example, TBS_4K. (Tablespace names must not contain spaces; underscores are allowed.)

    16K Table Space Name. Type the name for your 16-KB tablespace; for example, TBS_16K. (Tablespace names must not contain spaces; underscores are allowed.)

    32K Table Space Name. Type the name for your 32-KB tablespace; for example, TBS_32K. (Tablespace names must not contain spaces; underscores are allowed.)

  16. (Oracle Database only) Specify the following, and click Next:

    Index Table Space Name. Type the name for your index tablespace; for example, INDEX01. (Tablespace names must not contain spaces; underscores are allowed.)

    Table Space Name. Type the name for your tablespace; for example, DATA01. (Tablespace names must not contain spaces; underscores are allowed.)

  17. (Microsoft SQL Server only) On the Repository Selection screen, specify if you are using binary sort order or case-sensitive sort order for the Siebel Repository, and click Next.
  18. (Oracle Database and Microsoft SQL Server only) On the Siebel License Key Option screen, specify that you will provide the license key data later, and click Next.

    In the current release, the license keys for Siebel CRM base applications do not need to be entered manually. The license keys are provided in the seed data that is imported into a new Siebel database. The license keys are also part of the seed data that is imported into an existing database as part of Incremental Repository Merge or database upgrade operations. For more information about performing these operations, see Siebel Database Upgrade Guide.

  19. (Oracle Database only) On the Oracle Parallel Index screen, specify the statement describing your database environment, and click Next:
    • Does not use the Oracle Parallel Indexing option
    • Uses the Oracle Parallel Indexing option

      If you have a single-CPU environment, then choose the first option. If you have a multiple-CPU environment, then choose the first or second option, depending on whether you are running your Oracle Database with parallel indexing on.

  20. Specify the following, and click Next:

    Security Group ID / Grantee. Type the name for your security group. Specify SSE_ROLE.

  21. On the Log Output Directory screen, accept the default log directory or enter a new directory name, and click Next.

    By default, logging occurs in the SIEBSRVR_ROOT\log\operation\output directory. In this path, operation corresponds to the operation that you are performing, such as install for an Install Database operation or install_lang for an Add Language operation.

    Click Help to view the following message, which asks if you are ready to apply configuration changes to the Siebel database now, using the Siebel Upgrade Wizard, or will do so later:

    Configuration is complete: your output will be saved under $SiebelRoot/siebsrvr/bin/master_<process>.ucf. Would you like to deploy the process you configured to the database now or later?

    NOTE:  Check the Siebel Release Notes on My Oracle Support for the current release. If this document describes any tasks that you must perform to modify the generated SQL files, then modify the generated SQL files as necessary before you execute the SQL in the Siebel Upgrade Wizard.

  22. Choose one of the following, and click Next:
    • Yes apply configuration changes now. Choose this option if you want the generated SQL files to be executed in the Siebel Upgrade Wizard.
    • No I will apply configuration changes later. Choose this option if you do not want the generated SQL files to be executed in the Siebel Upgrade Wizard. In this case, you must run the Upgrade Wizard manually at a later time in order to execute the generated SQL files.

      If you choose to apply configuration changes later, then the command line to apply the configuration later is:

    SIEBEL_ROOT\siebsrvr\bin\siebupg.exe /m master_operation.ucf

    For the purposes of this procedure, operation is either install or install_lang.

  23. Review the values that you entered on the previous screens in the Database Configuration Wizard:
    • If you have to change any values, then click Back and Next to access the screens on which to change entries, and then to return to this screen.
    • Alternatively, you can click Cancel to cancel the Database Configuration Wizard session, then restart the wizard and enter different values.
    • When you have verified your input, click Next. Doing so generates SQL files that you will then apply to the database. When all of the SQL files have been generated, a message appears, stating The configuration changes were applied successfully. Click OK.

      If you chose No in Step 22, then the Siebel Upgrade Wizard does not appear. You must run it manually, after reviewing the generated SQL files.

      If you chose Yes in Step 22, then the Siebel Upgrade Wizard appears.

      NOTE:  When you run the Siebel Upgrade Wizard, if a program or system error occurs, then you can rerun the wizard, starting at the point at which the wizard failed. For more information, see Siebel Database Upgrade Guide.

      When the Siebel Upgrade Wizard finishes running, the Siebel Upgrade Wizard Complete screen appears. You have now finished installing the Siebel database components.

  24. After the Siebel Upgrade Wizard has finished running, click Exit to exit the Database Configuration Wizard.
Related Topics

About Installing the Siebel Database

Verifying Installation for the Siebel Database

Troubleshooting Installation for the Siebel Database

Siebel Installation Guide for Microsoft Windows Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.