Bookshelf Home | Contents | Index | PDF     

Siebel Installation Guide for Microsoft Windows > 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. Launch the Database Configuration Wizard, using any method described in Launching the Siebel Configuration Wizard.

    The Gateway Name Server Address screen appears.

  2. Type the following values as you recorded them in your copy of the worksheet in Deployment Planning Worksheet and click Next.

    Gateway Name Server Address. The domain name and alias of the host on which you installed the Siebel Gateway Name Server.

    Enterprise Server Name. The name you gave to your Siebel Enterprise Server, for example, SBA_80.

    The Siebel Server Directory screen appears.

  3. 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. (This location is the SIEBSRVR_ROOT directory, for example, D:\sba80\siebsrvr.)
    • Use the Browse button to select an alternate directory path to a different Siebel Server on that machine.

      The Database Configuration Utilities Directory screen appears.

  4. On the Database Configuration Utilities Directory screen, do one of the following and click Next:
    • Accept the default path displayed in the Database Configuration Utilities Directory field. (This location is the DBSRVR_ROOT directory, for example, D:\sba80\dbsrvr.)
    • Use the Browse button to select an alternate directory.

      The RDBMS Platform screen appears.

  5. Select the appropriate RDBMS platform and click Next.

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

    The Siebel Database Operation screen appears.

  6. Select Install Database and click Next.

    The Siebel User/Role Creation screen appears.

  7. 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, click Next.
    • If you did not already run grantusr.sql, exit the Database Configuration Wizard and run the script now. When the script has finished executing, restart the Configuration Wizard.
  8. On the Select Installation Operation screen, click Install Siebel Database, and then click Next.

    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 10, and specify the base language for the Siebel Database.)

  9. On the Database Encoding screen, identify the appropriate database encoding method:
    • UNICODE
    • 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 11.

  10. On the Base Language screen, specify which language serves as the primary language (base language) for the Siebel Database, and click Next.

    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.

  11. On the Language Selection screen, choose the language in which you want to run your database (for an install database operation), or choose the language you want to add (for an add language operation). Click Next.

    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 for which you previously installed Siebel Language Packs on the Siebel Server.

    The ODBC Data Source Name screen appears.

  12. Indicate the name for the ODBC data source, such as SBA_80_DSN, and then click Next.

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

  13. On the Database User Name screen, indicate the following about your database 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. On the Database Table Owner screen, indicate the following about your database, and then click Next:

    Database Table Owner. Type the name of the Siebel Database table owner, or the account that will own the Siebel objects; for example, ora*** for Oracle and siebel for DB2 UDB and MS SQL Server.

    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. (DB2 UDB only) On the Database Server OS screen, select the platform on which your database server runs, and click Next.

    AIX
    HP-UX
    Solaris
    Windows
    Linux

  16. (DB2 UDB only) On the Index Table Space Name screen, indicate the following values, and click Next to continue:

    Index Table Space Name. Type the name for your index table space; for example, SBL_INDX.

    4K Table Space Name. Type the name for your 4-KB table space; for example, TBS_4K.

    NOTE:  Table space names must not contain spaces; underscores are allowed.

  17. (DB2 UDB only) On the 16K Table Space Name screen, indicate the following values, and click Next to continue:

    16K Table Space Name. Type the name for your 16-KB table space; for example, TBS_16K.

    32K Table Space Name. Type the name for your 32-KB table space; for example, TBS_32K.

    NOTE:  Table space names must not contain spaces; underscores are allowed.

  18. (Oracle only) On the Index Table Space Name screen, indicate the following values, and click Next to continue:

    Index Table Space Name. Type the name for your index table space; for example, DATA01.

    Table Space Name. Type the name for your table space; for example, DATA02.

    NOTE:  Table space names must not contain spaces; underscores are allowed.

  19. (Oracle only) In the Oracle Parallel Index screen, specify the appropriate environment for your installation, and click Next to continue:
    • I am not running with Parallel Indexing On
    • 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.

  20. In the Log Output Directory screen, accept the default log directory, or enter a new directory name, and click OK.

    By default, logging will occur in the SIEBSRVR_ROOT\log\operation\output directory, where operation corresponds to the operation you are performing, such as install for Install Database or install_lang for Add language.

    A dialog box appears with the message:

    The configuration is complete: your output has been saved to <$MasterFile>. Would you like to deploy the process you configured to the database now or later?

    Yes apply configuration changes now.

    No I will apply configuration changes later.

    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.

  21. Respond to the choice in one of the following ways:
    • Yes apply configuration changes now. Choose this option if you want the generated SQL 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 to be executed in the Siebel Upgrade Wizard. In this case, you will need to run the Upgrade Wizard manually at a later time in order to execute the generated SQL.

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

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

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

    NOTE:  If you ran the Database Configuration Wizard previously, SQL files may 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, sqlgen.exe will run and SQL files will be regenerated. If you need to force sqlgen.exe to run, you can manually delete sqlgen.usg.

    The Configuration Parameter Review screen appears.

  22. Review the configuration values you entered on the previous screens in the Database Configuration Wizard:
    • If you need to change any values, use the Previous and Next buttons 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 relaunch the wizard and reconfigure with different values.
    • When you have verified the configuration values, click Finish. Doing so generates SQL files that you will then apply to the database. When all SQL has been generated, a message appears, stating "The configuration changes were applied successfully." Click OK.

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

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

      NOTE:  When you run the Upgrade Wizard, if a program or system error occurs, you can rerun the wizard, starting at the point at which the wizard failed. For details, 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.

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