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

Importing the Siebel Repository for the DB Server

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

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

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.

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:

   Korn or Bourne 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

   SIEBEL_ROOT=New Value; export SIEBEL_ROOT

   LANGUAGE=New Value; export LANGUAGE

   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 Siebel 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.

   Select the RDBMS Platform:

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

7. Enter the appropriate number for the RDBMS for your installation and press ENTER.
8. (Oracle only) On the Database Version screen, enter 1 or 2 based on the Oracle version you are using.
9. 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

10. On the Repository Operations screen, type 1 and press Enter to select Import Repository.

    Select one of the following options:

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

11. On the Import Repository screen, specify the type of Repository you want to import.

    Specify your import repository option:

    1- Import Siebel Repository
    2- Import Custom Repository

    The script displays the list of available Language Packs.

12. Enter the number that corresponds to the Language Pack you want to install.

    NOTE:  In a Unicode-enabled database environment, you can install any of the available Siebel Language Packs. In a non-Unicode database environment, you must consider the correlation of the Language Packs you want to install and the characters supported by your database code page. For example, in a Western European code page database, you can only install Western European Language Packs, such as English, French, Spanish, or German Language Packs. In a Japanese code page database, you can only install Japanese or English Language Packs.

    For a list of supported code pages and encoding strategies, see System Requirements and Supported Platforms on Siebel SupportWeb.

13. Enter the ODBC data source name; for example, siebsrvr_ent_srvr1.

    NOTE:  The data source is created automatically by the Siebel Server installation, using the format SiebSrvr_enterprise_server_name. You should not change any of the default ODBC settings or parameters; otherwise, you will encounter problems using the ODBC. For example, setting the OptimizeLongPerformance parameter to enable corrupts all the scripts in the repository during the import or export processes.

14. Enter the user name password for the Siebel administrator for your database; for example, SADMIN and ORASADMIN.
15. Enter the Oracle database tableowner name and password; for example, siebel and orasadmin.
16. Enter the name of your repository or accept the default; for example, Siebel Repository.
17. 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).

18. 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.

    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 Upgrade Guide.

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