Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Remote and Replication Manager Administration Guide > Implementing Siebel Replication Manager > Installing a New Enterprise Server >
Installing the Siebel Database Server
For Regional Nodes that support smaller numbers of mobile or connected users, the Regional Database Server may be installed on the same physical server that will support the Regional Siebel Server.
NOTE: The Regional database server must be the same version as its parent database server.
Before you initialize the Regional Database, you must install the RDBMS software on the Regional Database Server to create an empty database with adequate space for data and index storage areas. Do this in accordance with the RDBMS vendor's documentation and the guidelines for configuration and space allocation. For more information, see the Siebel Server installation guide for the operating system you are using.
You must also create the database accounts for the Siebel Tableowner and Siebel Administrator and grant them the necessary privileges. Use the Application RDBMS Tool to create these users and to grant their privileges. For example, for an Oracle RDBMS, grant these accounts connect, resource, and DBA privileges. For MS SQL, the Tableowner needs to have Security Administrator privileges on regional nodes. For DB2, the Tableowner needs to have DBA privileges. For more information, see the Siebel Server installation guide for the operating system you are using.
NOTE: In order to successfully implement a srvrinit on an Oracle Regional Node, the table owner has to have certain privileges. This can be done without granting DBA privileges to the table owner. The procedure that follows describes how to enable srvrinit to work in Oracle without granting DBA privileges to the table owner.
To enable srvrinit in Oracle without granting DBA privileges to the table owner
- Start SQL*Plus and log in as the user system or sys or a DBA user and then execute the following command:
grant sse_role, connect, alter user, create user, create table, create session to
<table owner> with admin option
If only sse_role is granted, an error message will be displayed.
After the RDBMS has been installed and configured and you have created the accounts for the Siebel tableowner and Siebel administrator, installation of the Regional Database Server is complete. The database objects, such as tables and indexes, are automatically created when you extract and initialize the database. These procedures are described in Extracting the Regional Database and Initializing the Regional Database.
NOTE: The Regional Database Initialization utility uses the default storage parameters for the data and index tablespaces. Oracle database administrators should set storage parameters appropriately before installing the Regional Database. For information on setting storage parameters, see the Siebel Server installation guide for the operating system you are using. For larger tables, you can modify the storage parameters after the tables are created.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Remote and Replication Manager Administration Guide Published: 19 November 2003 |