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

Importing the Siebel Repository for the Siebel Database


As a final step, you must import the Siebel Repository, using the Database Server Configuration Wizard. This task populates all the repository tables in the Siebel Database with the new Siebel Business Applications application objects.

Regardless of how many Siebel Business Applications you are using (for example, Siebel Call Center, Siebel Sales, Siebel Service, and Siebel Marketing), you will load the repository tables only once for each language.

NOTE:  When you import data into the Siebel Repository tables, a commit is performed once for each table into which repository data is imported. Alternatively, the commit frequency can be set to a specified number of rows by including the command-line option /h num_rows_per_commit when the repimexp.exe utility is invoked.

Some steps in the procedure in this topic pertain to adding a language to an existing repository, also using the Database Server Configuration Wizard. By adding a new language to a repository, you populate rows of localized user interface strings for repository objects, which allows Siebel Business Applications to display the UI in the new language.

In order to add a new language to an existing repository, you must have installed its Language Pack on the Siebel Server using the Siebel Enterprise Server installer. Also, you must have added the language to the Siebel Database. For more information, see Installing the Siebel Database Components.

To import the Siebel Repository

  1. Launch the Database Server Configuration Wizard using any method described in Launching the Siebel Software Configuration Wizard.
  2. On the Gateway Name Server Address screen, type the values you recorded in your copy of the worksheet in Deployment Planning Worksheet for the following parameters, and then click Next:

    Gateway Name Server Address. The 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, Sieb78.

  3. On the Siebel Server Directory screen, perform either of the following tasks, and then click Next:
    • Accept the default value displayed in the Siebel Server Directory field. (This is the SIEBSRVR_ROOT directory, for example, D:\sea78\siebsrvr.)
    • Use the Browse button to select an alternate directory path.

      The Siebel Database Server Directory screen appears.

  4. On the Siebel Database Server Directory screen, perform either of the following tasks, and then click Next:
    • Accept the default path displayed in the Siebel Database Server Directory field. (This is the DBSRVR_ROOT directory, for example, D:\sea78\dbsrvr.)
    • Use the Browse button to select an alternate directory
  5. On the RDBMS Platform screen, select the appropriate RDBMS platform for your installation and click Next.

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

  6. On the Siebel Database Operation screen, select Import/Export Repository, and then click Next.
  7. On the Select Repository Operation screen, choose one of the following options:

    Import Repository. This option imports the Siebel Repository for the first time with a primary (base) language. Click Next and proceed to Step 8.

    Add language to an existing Repository. This option adds a new language to your repository. Click Next and proceed to Step 9.

    Export Repository. This option exports the Siebel Repository into a platform-independent file that can be sent to Siebel Technical Support for analysis if needed.

  8. On the Import Selection screen, specify that you want to import the standard Siebel 7.x repository, and then click Next.
  9. On the ODBC Data Source Name screen, indicate the name for the ODBC data source, such as SiebSrvr_Sieb78, and then click Next.

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

  10. On the Database User Name screen, indicate the following about your database, and then click Next:

    Database User Name. Type the user name of the Siebel administrator, for example, sadmin for Oracle and DB2 UDB, or SADMIN for MS SQL Server.

    Database Password. Type the password for the Siebel administrator.

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

  11. On the Database Table Owner screen, indicate the following about your database, and then click Next:

    Database Table Owner. 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 Siebel Database table owner password.

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

  12. On the Import Repository Name screen, type the following values, and click Next:

    Import Repository Name. Accept the default name (Siebel Repository) or type another valid name.

    Repository File Name. If you are importing your repository for the first time, this is the second field appearing on the screen. Accept the default installation path and file name for this repository or type another valid installation path. (If you are adding a language to an existing repository, this field is named Localized Repository File Name.)

    For Oracle, proceed to Step 13. For DB2 UDB or MS SQL Server, proceed to Step 14.

  13. (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.

  14. 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 imprep for Import Repository or imprep_lang for Add language.

    The Configuration Parameter Review screen appears.

  15. Review the configuration values you entered on the previous Configuration Wizard screens:
    • 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.
    • When you have verified the configuration values, click Finish. A message box appears with the prompt:

    To apply the configuration now, press OK.

    To apply the configuration later, press Cancel.

    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 imprep or imprep_lang.

    NOTE:  If a program or system error occurs and you need to rerun the Siebel Upgrade Wizard, you can do so, starting at the point at which the wizard failed. For details, see the Upgrade Guide.

    The Siebel Upgrade Wizard screen appears, displaying the items to be executed or imported.

  16. To begin, click OK.

    A window appears, displaying information about Siebel Upgrade Wizard repository import activities.

    The Siebel Upgrade Wizard displays a message when installation is complete.

    To verify that the import was successful, review the log files. See Reviewing the Log Files for Repository Import for the Siebel Database.

If you need to change the values you previously entered, relaunch the Configuration Wizard by running Start > Programs > Siebel Enterprise Server Configuration 7.x > Configure DB Server. Doing this allows you to reconfigure with different values.

Siebel Installation Guide for Microsoft Windows: Servers, Mobile Web Clients, Tools