Bookshelf Home | Contents | Index | PDF     

Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Installing the Siebel Database Server and Configuring the Siebel Database > Configuring the Siebel Database on the RDBMS >

Installing the Siebel Database Components

When you choose Install Database from the Siebel Database Operation screen in the Database Server Configuration Wizard, the utility performs several tasks within the database instance you created in Configuring the RDBMS.

  • Creates the Siebel schema (tables and indexes) in a specified table space.
  • Inserts Siebel seed data specific to your database, and installs views, packages, and procedures for your database.
  • Sets system preferences.

Some steps in the procedure in this topic pertain to adding a language to an existing Siebel Database, also using the Database Server Configuration Wizard. Adding a language to an existing Siebel Database installs seed data to support that language.

In order to add a new language to previously installed Siebel applications, you must have installed its Language Pack on the Siebel Server using the Siebel Enterprise Server installer.

After you have added a language to the Siebel Database, your seed data is multilingual. You must enable the multilingual list of values (MLOV) capability for Siebel Business Applications. For more information, see Configuring Siebel Business Applications and the Global Deployment Guide. See also any applicable documents on this issue on Siebel SupportWeb.

For a list of languages supported by Siebel Business Applications in this release, see System Requirements and Supported Platforms on Siebel SupportWeb.

To install Siebel Database components

  1. Navigate to $SIEBEL_HOME/bin and source environment variables, using one of the following commands, depending on the type of shell you use:

    Bourne or Korn shell

    . ./siebenv.sh

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

    C shell

    source siebenv.csh

    where:

    • $SIEBEL_HOME = The location of the Siebel Server root directory, such as /export/home/siebel/siebsrvr.
  2. 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, reset them using one of the following commands, as appropriate to the shell you use.

    For example, the SIEBEL_ROOT value might resemble /export/home/siebel/siebsrvr, while the value for LANGUAGE might be ENU, FRA, JPN, or CHS (or another language code).

    Bourne or Korn shell

    export SIEBEL_ROOT=New_Value

    export LANGUAGE=New_Value

    C shell

    setenv SIEBEL_ROOT New_Value

    setenv LANGUAGE New_Value

  3. Navigate to $SIEBEL_ROOT/bin and run the following script:

    dbsrvr_config.ksh

    This script launches the Database Server Configuration Wizard.

  4. Confirm whether the displayed settings for the SIEBEL_ROOT and LANGUAGE environment variables are correct (as discussed in Step 2) by entering either Y or N.

    If either the SIEBEL_ROOT value or the LANGUAGE value, which is the language in which you are running the wizard, is not set or is incorrect, you must correct them before proceeding.

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

  5. Specify a different path to your Siebel Server root directory, or press Enter to accept the current default setting (for example, /export/home/siebel/siebsrvr).

    The Configuration Wizard then prompts you for the path to the Siebel Database Server root directory.

  6. Specify the path to your Siebel Database Server root directory, or press Enter to accept the current default setting (for example, /export/home/siebel/dbsrvr).
  7. Select the appropriate RDBMS for your installation by entering the respective number from the list of supported database platforms displayed:

    Select the RDBMS Platform:

    1- IBM DB2 UDB for Windows and UNIX
    2- IBM DB2 UDB for z/OS
    3- Oracle Database Enterprise Edition

  8. Enter 1 to select the Install Database option from the Siebel Database Operation menu.

    Select the Siebel Database Operation

    1- Install Database
    2- Upgrade Database
    3- Import/Export Repository
    4- Migrate Repository
    5- Run Database Utilities

  9. On the next screen, enter Y if you ran grantusr.sql to set up your table owner and administrator accounts, or enter N to exit the Database Server Configuration Wizard to run this script.

    NOTE:  These accounts must be in place or you will not be able to complete installation of your tables, indexes, and seed data.

  10. If you elected to proceed, enter 1 to select Install Siebel Database from the Installation Options menu.

    Select one of the following options:

    1- Install Siebel Database
    2- Add a language to an existing Siebel Database

    The Install Siebel Database option creates the Siebel schema and inserts seed data at the end of the configuration session.

    (If you instead selected Add a language to an existing Siebel Database, proceed to Step 12, and specify the base language for the Siebel Database.)

  11. On the Database Encoding screen, enter the number that corresponds to the database encoding value for your database:

    1- Unicode
    2- Non-Unicode

    CAUTION:  Choose the correct option for your database to prevent installation of the wrong data types. The database will not be able to create Unicode data types on a non-Unicode page setting, so check this setting carefully before choosing the option.

    If you are installing a new Siebel Database, proceed to Step 13.

  12. On the Base Language screen, specify which language is as the primary (base) language for the Siebel Database.

    The primary (base) language is the language in which you already installed the Siebel Database (the first installed language). This screen appears only if you are adding a language to an existing Siebel Database.

    The languages listed in this screen are those you previously installed on the Siebel Server.

  13. On the Language Selection screen, enter the number corresponding to the language in which you want to run your database (for an install database operation), or to the language you want to add (for an add language operation).

    For an install database operation, the language you select will be the primary (base) language for your database (the first language installed).

    The languages listed in this screen are those you previously installed on the Siebel Server.

    For an install database operation, the language you select will be the primary (base) language for your database (the first language installed).

  14. On the ODBC Data Source screen, specify the ODBC data source name; for example, siebsrvr_sieb78. Then press Enter.

    You can find the ODBC data source name under the [ODBC Data Sources] section of the .odbc.ini file, located in the $SIEBEL_ROOT/sys directory.

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

    The Database User Name screen appears.

  15. Enter the user name and password for the Siebel administrator for your database; for example, SADMIN and SADMIN (Oracle) or SADMIN and db2 (DB2 UDB).

    The Database Table Owner screen appears.

  16. Enter the database table owner name and password; for example, ora*** and ora*** or siebel and db2.

    The Database Server OS screen appears.

  17. (DB2 UDB for UNIX and Windows only) On the Database Server OS screen, select the platform on which your database server runs, and press Enter.

    1- Windows
    2- Solaris
    3- AIX
    4- HP-UX
    5- Linux

  18. (DB2 UDB only) On the Database Index screen, enter the name of your index table space.
  19. (DB2 UDB only) Enter the name of your 4-KB table space.
  20. (DB2 UDB only) Enter the name of your 16-KB table space.
  21. (DB2 UDB only) Enter the name of your 32-KB table space.
  22. (Oracle only) On the Database Index screen, enter the name of your index table space; for example, INDEX01.
  23. (Oracle only) Enter the name of your table space; for example, DATA01.

    The Oracle Parallel Index screen appears.

  24. (Oracle only) In the Oracle Parallel Index screen, specify the appropriate environment for your installation:

    1. I am not running with Parallel Indexing On
    2. I am running with Parallel Indexing On

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

    The Common Parameters screen appears:

    Siebel Log Process

    (Default: install)
    Press Enter for default

  25. To accept the default log process (install for Install Database or install_lang for Add language) as the name of the logging directory under siebsrvr/log, press Enter. Or, specify a different name for the logging directory, then press Enter.

    The List of Parameters Used screen appears, which shows the settings made during the session.

    NOTE:  Optionally, you can press Ctrl-C to cancel the Database Server Configuration Wizard session, then restart dbsrvr_config.ksh and reconfigure with different values.

  26. You are prompted whether to run the Siebel Upgrade Wizard now. When you have verified the configuration values, do one of the following in order to generate SQL:
    • To run the Upgrade Wizard and execute the SQL after it is generated, type 1 and press Enter. The SQL is generated, and then executed in the Siebel Upgrade Wizard, after you complete this procedure.
    • To run the Upgrade Wizard and execute the SQL later, type 2 and press Enter. The SQL is generated, but not executed, after you complete this procedure. In this case, you will need to run the Upgrade Wizard manually at a later time in order to execute the generated SQL.

      CAUTION:  It is strongly recommended not to run the Upgrade Wizard and execute generated SQL at this time. Both new customers and upgrade customers must run this wizard to apply the configuration, whether you run it now or run it later using the srvrupgwiz command. Before running the Upgrade Wizard, check the Release Notes on Siebel SupportWeb for the current release. If this document describes any tasks you must perform to modify the generated SQL files, modify the generated SQL as necessary after you complete this procedure. Then run the Upgrade Wizard using the srvrupgwiz command to apply the configuration.

      The command line to apply the configuration later is:

    SIEBEL_ROOT/siebsrvr/bin/srvrupgwiz /m master_operation.ucf

    where, for this procedure, operation may be install or install_lang.

    
Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools