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

Installing the Database Configuration Utilities and the Regional Siebel Database on the Regional Node


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

To install the 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 RDBMS software. Do this in accordance with the documentation of the RDBMS vendor and the guidelines for configuration and space allocation.

  3. Create the Siebel database accounts for the Siebel Table Owner 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 Database, you can grant connect, resource, and database administrator privileges for each account.
    • For Microsoft SQL Server, you can grant the Table Owner Security Administrator privilege on regional nodes.
    • For IBM DB2, you can grant the Table Owner 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 Database 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 Database 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 Siebel Database on the Regional Node

For a regional node that supports a smaller number of remote or connected users, you can install the Siebel database 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 © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.