Bookshelf Home | Contents | Index | PDF     

Siebel Installation Guide for UNIX > 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. Before you run the Database Configuration Wizard for the first time, run the CreateDbSrvrEnvScript script to generate the environment setup files dbenv.csh and dbenv.sh.

    CreateDbSrvrEnvScript is located in the directory $SIEBSRVR_ROOT/install_script/install. Run CreateDbSrvrEnvScript from this location by using the following command:

    ./CreateDbSrvrEnvScript Siebel_Root_Parent_Directory LANG DB_Platform

    where:

    • Siebel_Root_Parent_Directory is the top-level Siebel Enterprise Server installation directory.
    • LANG is the three-letter code for the primary language for the Siebel database that you will install; for example, ITA for Italian.
    • DB_Platform is Oracle, Db2Udb, or Db2.390.

      For example:

    ./CreateDbSrvrEnvScript /siebel ITA Oracle

    The dbenv.csh and dbenv.sh environment setup files are created in the Siebel Server installation directory.

  2. Open a shell window.
  3. Navigate to the $SIEBSRVR_ROOT directory and source the environment file by using one of the following commands, depending on the type of shell that you use. Perform this step each time that you run the Database Configuration Wizard. You must have created this file first, by using the script CreateDbSrvrEnvScript, as described in Step 1.

    C shell

    source dbenv.csh

    Bourne or Korn shell

    . ./dbenv.sh

    TIP:   Make sure that there is a space between the initial period and ./dbenv.sh.

    In this path, $SIEBSRVR_ROOT is the location of the Siebel Server root directory. For example, for Siebel CRM version 8.1.1.11, the directory might be /export/home/siebel/8.1.1.11.0/ses/siebsrvr.

  4. Verify whether the values for SIEBEL_ROOT and LANGUAGE are correctly set or are empty by entering:

    env

    If the variables are incorrect or missing, then reset them using one of the following commands, as appropriate to the shell that you use.

    For example, for Siebel CRM version 8.1.1.11, the SIEBEL_ROOT value might resemble /export/home/siebel/8.1.1.11.0/ses/siebsrvr, while the value for LANGUAGE might be ENU, FRA, JPN, CHS, or another code representing the language in which you are running the Database Configuration Wizard.

    C shell

    setenv SIEBEL_ROOT New_Value

    setenv LANGUAGE New_Value

    Bourne or Korn shell

    export SIEBEL_ROOT=New_Value

    export LANGUAGE=New_Value

  5. Navigate to the config subdirectory of the $SIEBEL_ROOT directory. For example, for Siebel CRM version 8.1.1.11, navigate to a location like /siebel/8.1.1.11.0/ses/config.
  6. Start the Database Configuration Wizard, as described in Starting a Siebel Configuration Wizard. Enter a command similar to the following:

    install_path/config/config -mode dbsrvr

    In this path, install_path is the installation path for the installed Siebel Enterprise Server software.

    The Database Configuration Wizard validates the existence of the $SIEBEL_ROOT directory.

  7. 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 /export/home/siebel/8.1.1.11.0/ses/siebsrvr.
    • Click Browse to select a different Siebel Server installation location.
  8. 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
      /export/home/siebel/8.1.1.11.0/ses/dbsrvr.
    • Click Browse to select a different Siebel Database Configuration Utilities installation location.
  9. 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
    Oracle Database Enterprise Edition

  10. On the Siebel Database Operation screen, select Install Database from the list, and click Next.
  11. 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 15. 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.

  12. On the next screen, confirm that you want to install a new Siebel database, or indicate that you already have a Siebel database.
  13. 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.
  14. 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.

  15. 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 17.
    • 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.
  16. 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.

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

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

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

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

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

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

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

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

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

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

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

  28. (Oracle Database 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 31.

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

    Go to Step 31.

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

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

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

  34. 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/srvrupgwiz /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 program. In this case, this program will not run again in the current session. Whether sqlgen runs depends on the existence of the file DBSRVR_ROOT/COMMON/sqlgen.usg. If this file does not exist, then sqlgen will run and the SQL files will be regenerated. If you want to force sqlgen to run, then you can manually delete sqlgen.usg.

  35. 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 34, 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 34, 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.

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