Bookshelf Home | Contents | Index | PDF     

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.)

NOTE:  Before you run the Database Configuration Wizard, review the information about Siebel database updates for Siebel CRM version 8.1.1.11 or version 8.2.2.4, in About Installing the Siebel Database.

To install Siebel database components

  1. Start the Database Configuration Wizard. Choose Start, All Programs, Siebel Enterprise Server Configuration 8.1.1.11.0 or 8.2.2.4.0, and then Database Server Configuration.
  2. On the Siebel Server Directory screen, do one of the following, and click Next:
    • Accept the default value displayed in the Siebel Server Directory field. The location that you specify is the SIEBSRVR_ROOT installation directory. For example, for Siebel CRM version 8.1.1.11, this directory might be C:\siebel\8.1.1.11.0\ses\siebsrvr.
    • Click Browse to select a different Siebel Server installation location.
  3. On the Siebel Database Server Directory screen, do one of the following, and click Next:
    • Accept the default path displayed in the Siebel Database Server Directory field. The location that you specify is the Siebel Database Configuration Utilities installation directory (the DBSRVR_ROOT directory). For example, for Siebel CRM version 8.1.1.11, this directory might be C:\siebel\8.1.1.11.0\ses\dbsrvr.
    • Click Browse to select a different Siebel Database Configuration Utilities installation location.
  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 About 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 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.

    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.

    NOTE:  If you installed a single Siebel language pack on the Siebel Server where you also installed Database Configuration Utilities, then this screen does not appear. Go to the next step.

    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.
    • 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.
  11. On the Language Selection screen, select the language that you want to install in the Siebel database. Select the language in which you want to run your database (for an install database operation), or choose the language that you want to add (for an Add Language operation).

    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.

    NOTE:  If you installed multiple Siebel language packs on the Siebel Server where you also installed Database Configuration Utilities, and you are installing a new Siebel database, then this screen does not appear. (You already selected the language from the Base Language screen in the previous step.) Go to the next step.

    Do one of the following, and click Next:

    • If you are installing a new Siebel database and only one Siebel language pack was installed on the Siebel Server where you also installed Database Configuration Utilities, then this screen appears instead of the Base Language screen displayed in the previous step. Select the installed language, which will be the primary (base) language for your database. Seed data and Siebel Repository data will be installed for this language.
    • If you are adding a language, then 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.

      For an add-language operation, some of the remaining screens do not apply. Go to the next applicable step.

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

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

  13. On the Siebel Database User Name screen, indicate the following, and click Next:

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

  14. On the Siebel Database Password screen, indicate the following, and click Next:

    Database Password. Type the password for the Siebel administrator.

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

  15. On the Siebel Database Table Owner screen, indicate 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.

  16. On the Siebel Database Table Owner Password screen, indicate the following, and click Next:

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

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

  17. (IBM DB2 only) On the Index Table Space Name screen, indicate 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.)

  18. (IBM DB2 only) On the 4K Table Space Name screen, indicate the following, and click Next:

    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.)

  19. (IBM DB2 only) On the 16K Table Space Name screen, indicate the following, and click Next:

    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.)

  20. (IBM DB2 only) On the 32K Table Space Name screen, indicate the following, and click Next:

    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.)

  21. (Oracle Database only) On the Index Table Space Name screen, indicate 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.)

  22. (Oracle Database only) On the Table Space Name screen, indicate the following, and click Next:

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

  23. (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.
  24. (Oracle Database and Microsoft SQL Server only) On the Siebel License Key Option screen, specify whether you will enter the license key now or later, and click Next.

    If you are not entering the license key in this field, then you can enter it later using Siebel Tools. Go to Step 27.

  25. On the License Key screen, enter the license key, and click Next.

    Go to Step 27.

  26. On the Repository Name screen, specify the name of the Siebel Repository, and click Next.
  27. (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.

  28. On the Security Group ID / Grantee screen, indicate the following, and click Next:

    Security Group ID / Grantee. Type the name for your security group; for example, SSE_ROLE.

  29. 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.

    The next screen asks if you are ready to apply configuration changes to the Siebel database now, using the Siebel Upgrade Wizard, or will do so later. The following message is displayed:

    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.

  30. 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 this procedure, operation is either install or install_lang.

    NOTE:  If you ran the Database Configuration Wizard previously, then the SQL files might already have been generated by the sqlgen.exe program. In this case, this program will not run again in the current session. Whether sqlgen.exe runs depends on the existence of the file DBSRVR_ROOT\COMMON\sqlgen.usg. If this file does not exist, then sqlgen.exe will run and the SQL files will be regenerated. If you want to force sqlgen.exe to run, then you can manually delete sqlgen.usg.

  31. On the Configuration Parameter Review screen, 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 30, 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 30, 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.

  32. 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 © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.