Bookshelf Home | Contents | Index | PDF     

Siebel Installation Guide for UNIX > 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 Configuration Wizard, the utility performs several tasks within the database instance you created in Configuring the RDBMS.

The Install Database task does the following:

  • 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. This task inserts seed data for the primary language only.
  • Imports the Siebel Repository. This task imports the Repository for the primary language only.
  • 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 Configuration Wizard. Adding a language to an existing Siebel Database installs seed data to support that language. Each language other than the primary language must be installed separately.

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. See also Preparing to Run Siebel Server Components After Installing.

After adding a language you also need to import the Siebel Repository for this language. For details, see Importing a Siebel Repository into the Siebel Database.

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, and must enable individual LOVs associated with the language. For more information, see:

  • Configuring Siebel Business Applications
  • Siebel Global Deployment Guide
  • Any applicable documents on this issue on My Oracle Support

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

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 launch the Database Configuration Wizard:

    ssincfgw -is:javaconsole -console -args LANG=language MODEL_FILE=SIEBEL_ROOT/siebsrvr/admin/dbsrvr.scm

    NOTE:  This procedure generally assumes you are running the Database Configuration Wizard in console mode. You can also run it in GUI mode. For more information about launching the Database Configuration Wizard, see Launching the Siebel 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 Database Configuration Utilities root directory.

  6. Specify the path to your Database Configuration Utilities 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 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. 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. Confirm that you have already run the grantusr.sql script to set up table owner and administrator accounts.

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

    • If you already ran grantusr.sql, enter Y.
    • If you did not already run grantusr.sql, enter N. Exit the Database Configuration Wizard and run the script now. When the script has finished executing, restart the Configuration Wizard.
  10. If you elected to proceed, 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, specify 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 serves as the primary language (base language) for the Siebel Database.

    The primary 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. However, the screen does not appear if the existing database has only one language.

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

    NOTE:  Before you install Language Packs, see the information about code pages in Planning RDBMS Installation and Configuration.

  13. On the Language Selection screen, specify the language in which you want to run your database (for an install database operation), or corresponding 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 language for your database.

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

  14. On the ODBC Data Source screen, specify the ODBC data source name; for example, SBA_80_DSN. 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 cancel the Database Configuration Wizard session, then restart it and reconfigure with different values.

  26. Press Enter. Configuration is now complete. Your configuration is saved into the following file:

    SIEBEL_ROOT/siebsrvr/bin/master_operation.ucf

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

    NOTE:  Check the Siebel 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 before you execute the SQL in the Upgrade Wizard.

  27. Run the Upgrade Wizard to apply the configuration. Enter the following command:

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