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 >

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 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. 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
2. Verify whether the SIEBEL_ROOT and LANGUAGE variables 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:

   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.

   NOTE:  You must have read, write, and execute permission to run this script successfully.

   The script begins by displaying the current settings for the SIEBEL_ROOT and LANGUAGE variables and prompts you as to whether these settings are correct.

4. Confirm whether or not the settings are correct by entering either Y or N.

   NOTE:  If either the SIEBEL_ROOT or LANGUAGE value is not set or is incorrect, you must correct them before proceeding.

5. Specify the path of your Siebel Server root directory, or accept the default by pressing Enter.
6. Specify the path of your Siebel Database Server root directory, or accept the default by pressing Enter.

   The script displays the RDBMS Platform screen.

7. Enter the appropriate number for the RDBMS for your installation and press Enter.

   Select the RDBMS Platform:

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

8. On the Siebel Database Operation screen, type 3 and press Enter to select Import/Export Repository.

   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 Repository Operations screen, type 1 to select Import Repository, or type 2 to add a language to the repository. Press Enter.

   Select one of the following options:

   1- Import Repository
   2- Add language to an existing Repository
   3- Export Repository

10. On the Import Repository screen, enter 1 to specify that you want to import the Siebel repository. Press Enter.

    Specify your import repository option:

    1- Import Siebel Repository
    2- Import Custom Repository

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

    For an import repository operation, the language you select should be the primary (base) language for your database (the first language installed in Importing the Siebel Repository for the Siebel Database).

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

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

12. Enter the ODBC data source name; for example, siebsrvr_sieb78.

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

13. Enter the user name password for the Siebel administrator for your database; for example, SADMIN and ORASADMIN.
14. Enter the Oracle database table owner name and password; for example, siebel and orasadmin.
15. Enter the name of your repository or accept the default; for example, Siebel Repository.
16. Enter the name of your repository file name or accept the default; for example, mstrep.dat.

    After you have completed your Import Repository specifications, the Configuration Wizard displays the list of configured values and prompts you as to whether you want to launch the Siebel Upgrade Wizard (srvrupgwiz).

17. Enter 1 to confirm your specifications and launch the Upgrade Wizard, or 2 to reject the values and exit the Configuration Wizard.

    If you need to change the values you previously entered, rerun the Configuration Wizard by running the dbsrvr_config.ksh script. Rerunning the wizard allows you to reconfigure with different values.

    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.

    If the upgrade was successful, the Siebel Upgrade Wizard displays a success message when installation is complete.