Siebel Remote and Replication Manager Administration Guide > Implementing Replication Manager >

Initializing the Regional Database


This topic describes how to initialize the regional database. Replication Manager loads the regional database extract that you create in Extracting the Regional Database in the regional database. It creates database objects and populates them with data. You can initialize the regional database from the administrative interface or the command line interface.

Initializing the Regional Database from the Administrative Interface

You can initialize the regional database from the administrative interface.

To initialize the regional database from the administrative interface

  1. Make sure your environment meets the requirements for running the Regional Database Initialization program.

    For more information, see Requirements for Running the Regional Database Initialization Program.

  2. On the regional server, stop the Siebel Server.

    You run the srvrinit command on the regional server. You must stop only the Siebel Server. Do not stop the Gateway Server.

  3. Open a command line on the regional server.
  4. If the regional server runs on Windows, then navigate to the SIEBEL_ROOT folder, and then run the siebenv.bat batch file, where SIEBEL_ROOT is the folder where you installed the Siebel Server.

    The siebenv.bat batch file sets the environment variables that srvrinit.exe requires. Make sure you run siebenv.bat in the same command shell where you run srvrinit.exe.

  5. Navigate to the siebsrvr_root/bin folder.
  6. Run the srvrinit program:
    • In Windows, the Regional Database Initialization program is named srvrinit.exe. You must run srvrinit.exe from the DOS command prompt in the same window where you run siebenv.bat in Step 4.
    • In UNIX, the Regional Database Initialization program is named srvrinit. You must run srvrinit from the command line interface.

      The srvrinit program runs the Regional Database Initialization program and displays the Regional Database Initialization dialog box.

  7. In the Siebel Remote Parameters fields, specify the values for each of the parameters that the regional server uses to connect to the parent node.

    For more information, see Parameters of the Regional Database Initialization Program.

  8. In the Regional Database Parameters fields, specify the values for each of the parameters that the regional server uses to connect to the regional database.

    For more information, see Parameters of the Regional Database Initialization Program.

  9. Click the following item:

    Start Initialization

    The Siebel Upgrade Wizard starts automatically and completes the work that Replication Manager requires to initialize the regional database. If a dialog box does not display while the utility runs, then something is wrong. If this situation occurs, or if the wizard fails, then see Recovering from a Failure While Initializing a Regional Database. For more information, see Error Messages You Can Ignore.

  10. Wait for the initialization to finish.
  11. Enable the required server components, such as Siebel Remote and the required object managers.

    For more information, see Administering Server Components for Siebel Remote. For information about enabling object managers and other components, see Siebel System Administration Guide.

  12. If necessary, install the Siebel Web Server Extension (SWSE).

    For more information, see Requirements for Installing SWSE.

  13. If necessary, create user accounts.

    Srvrinit does not create user accounts. You must create users for database accounts for all users who access the regional node.

Initializing the Regional Database from the Command Line Interface

You can initialize the regional database from the command line interface.

To initialize the regional database from the command line interface

Requirements for Running the Regional Database Initialization Program

To initialize the regional database from the Siebel Server, you use the Regional Database Initialization (srvrinit) program. Srvrinit does the following work:

  • Connects to the parent Siebel Server, and then downloads the regional database extract for the regional node.
  • To initialize the database, it starts the Siebel Upgrade Wizard.

Note the following requirements:

  • You must do this work on the Siebel Server on the regional node.
  • You must make sure that sufficient transaction space, known as the Rollback Segment, is available on the regional database. To determine if you must increase or modify the existing rollback segment, you can work with your database administrator.
  • You must make sure that the database user ID and password that you use to run srvrinit exists on the Siebel Server of the headquarters node and the regional node. Srvrinit only allows you to specify one set of credentials. It must use those credentials for these computers. If credentials on the two computers are different, then the process might not start, or it might fail before it finishes.

Requirements for Installing SWSE

If you use the Web client to support users on a regional node, then you must install SWSE. If you use the Developer Web Client to support users on a regional node, then SWSE is not required. You can use the Developer Web Client only in a test environment or for troubleshooting. For more information, see the Siebel Installation Guide for the operating system you are using.

Error Messages You Can Ignore

You can ignore the following error messages:

  • ORA-01921: role name 'SSE_ROLE' conflicts with another user or role name
  • ORA-01017: invalid username/password, or logon denied
  • ORA-00942:table or view does not exist

These messages might display while you initiate a regional database.

Options for Initializing the Regional Database

This topic describes options for initializing the regional database.

Running Srvrinit in Parallel to Improving Performance

If the Siebel Server includes multiple CPUs and disk arrays, then you can run srvrinit in parallel to significantly improve performance.

Reducing the Rollback Segment

To reduce the size of the rollback segment that srvrinit requires, you can reduce the following extract parameter for the regional database:

Maximum data file size (DatFileSize)

The srvrinit task sends commits for each file. The smaller the file, the smaller the rollback segment. For more information, see Parameters of the Database Extract Server Component.

Reinitializing a Regional Node

If you reinitialize a regional node with remote clients, then you must verify that the remote clients who synchronized with this node can reinitialize without having to delete their local databases.

Siebel Remote and Replication Manager Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.