Siebel Remote and Replication Manager Administration Guide > Implementing Replication Manager > Installing Servers and File Systems on the Regional Node >

Installing the Server Database Configuration Utilities on the Regional Node


You can install the server Database Configuration Utilities on the regional node. The server Database Configuration Utilities is a set of files that you install on a Siebel Server. To install them, you use the Siebel Enterprise Server installer. To configure the server database on the RDBMS, you access these files when you run the Database Configuration Wizard and the Siebel Upgrade Wizard. For more information, see the Siebel Installation Guide for the operating system you are using. The server Database Configuration Utilities were formerly known as the Siebel Database Server.

To install the server Database Configuration Utilities on the regional node

  1. Have an Oracle database administrator set storage parameters.

    The Regional Database Initialization program uses the default storage parameters for the data and index tablespaces. For larger tables, you can modify the storage parameters after you create the tables.

  2. Install the RDBMS software on the regional Siebel Server.

    To create an empty database that contains adequate space for data and index storage, you must install the RDMBS software. Do this in accordance with the documentation of the RDBMS vendor and the guidelines for configuration and space allocation.

  3. Create the server database accounts for the Siebel Tableowner and Siebel Administrator, and then grant them the necessary privileges.

    To create these users and to grant their privileges, you can use the application RDBMS tool. For example:

    • For an Oracle RDBMS, you can grant connect, resource, and database administrator privileges for each account.
    • For MS SQL, you can grant the Tableowner Security Administrator privilege on regional nodes.
    • For DB2, you can grant the Tableowner database administrator privilege.

      For more information, see Implementing Srvrinit on the Regional Node.

Implementing Srvrinit on the Regional Node

To successfully implement srvrinit on an Oracle regional node, the table owner must possess the required privileges. You can grant these privileges without granting database administrator privileges to the table owner. This topic describes how to enable srvrinit to work in Oracle without granting database administrator privileges to the table owner.

To implement srvrinit on the regional node

  1. Start SQL*Plus.
  2. Log in as the system user, sys, or a database administrator user.
  3. Run the following command:

    grant sse_role, connect, alter user, create user, create table, create session to table owner with admin option

    If you only grant sse_role, then SQL*Plus displays an error message.

Options for Installing the Server Database Configuration Utilities on the Regional Node

For a regional node that supports a smaller number of Remote or connected users, you can install the server Database Configuration Utilities on the regional node on the same physical server that supports the Siebel Server on the regional node. You must use the same version on the regional Siebel Server and on the parent of the regional Siebel Server.

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