Bookshelf Home | Contents | Index | PDF     

Siebel Installation Guide for Microsoft Windows: 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.exe utility is invoked.

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 Server Address screen, type the values you recorded in your copy of Deployment Planning Worksheet for the following parameters, and then click Next:

    Gateway 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, siebel.

  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:\sea77\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:\sea77\dbsrvr.)
    • Use the Browse button to select an alternate directory.
  5. On the RDBMS Platform screen, select the appropriate RDBMS for your installation and click Next.
  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, as appropriate:
    • Import Repository. To import the Siebel Repository for the first time with a primary (base) language, select this option. Click Next and proceed to Step 8.
    • Add language to an existing Repository. To add a new language to your repository, select this option. Click Next and proceed to Step 9. For instructions on importing a new language to the Siebel Repository, see Importing a New Language to the Repository.
    • Export Repository. Exports the Siebel Repository into a platform-independent file that can be sent to Siebel Technical Support for analysis if needed. Click Next and proceed to Step 13.
  8. On the Import Selection screen, indicate the following and then click Next:
    • If you want to import a standard Siebel 7.x repository, click the uppermost radio button.
    • If you want to import a Siebel 7.x repository that you have customized to a new environment, click the bottom radio button.

      NOTE:  Select Import Custom Siebel 7.x Repository when you are importing a multilingual repository from a test or development environment. This selection imports all languages to your target repository.

  9. On the ODBC Data Source Name screen, indicate the name for the ODBC data source and then click Next.

    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 import or export process.

  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 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 tableowner, or the account that will own the Siebel objects; for example, ora*** for Oracle and siebel for DB2 and MS SQL Server.

    Database Table Owner Password. Type the Siebel Database tableowner password.

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

    Proceed to Step 14.

  13. On the Export Repository Name screen, type the following values, and click Next:

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

    Repository File Name. Accept the default installation path and file name for this repository or type another valid installation path.

    The Configuration Parameter Review screen appears, showing the values you typed on the previous screens.

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

    C:\SIEBEL_ROOT\siebsrvr\bin\siebupg.exe /m master_imprep.ucf

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

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

  15. 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 DB Server.

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

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