Siebel DataBase Server Installation

Database Server 7.8.2 Installation:

1 "Make sure the following elements are defined for your Siebel Database:

■ Oracle SQLNet alias connect string. You need this to connect to your Oracle database.

■ Table owner account (schema) name and password. Oracle requires that you assign a user

name and password to any database tables you create. The term table owner refers to the

schema that owns the database objects, such as tables, indexes, views, and triggers. Prior to

installing the Siebel Database components, you need to edit the grantusr.sql script and enter

this information. SIEBEL is the default Table Owner Account user name and password for Siebel

applications.

■ Siebel data table space. The name of the default table space on the Oracle server where the

Siebel data tables are stored.

■ Siebel index table space. The name of the default table space on the Oracle server where the

Siebel indexes are stored.

■ Install Oracle database client software onto the machine where you will install the Siebel

Database Server."

2 Navigate to SIEBEL_INSTALL_IMAGE_782\7.8.2.0\Windows\Server\Siebel_Enterprise_Server.

3 Double-click setup.exe.

4 Click Next.

5 "To install a new instance of the Siebel Database Server, select None as the default and click

Next."

6 "Select the displayed default directory for file installation or use the Browse button to select a

different drive or directory, then click Next."

7 Select the Siebel Database Server for installation and configuration.

8 "Choose the type of Siebel Database Server installation to execute from the following options,

then click Next:"

9 "Click Next to copy the files for the selected products into the installation location. Alternatively,

to change any settings, click Back, adjust your selections, and click Next to return to this screen.

The installer proceeds to install the specified files.

A message appears, stating that language files are being installed.

After all server files specified have been installed, the installer displays the message:

The InstallShield Wizard has successfully installed the Siebel Enterprise Server.

Click Finish to exit the Wizard."

10 Click Finish.

11 "Before executing grantusr.sql, the database administrator should copy the following command in

the script, so it is defined once for each table space (for data or indexes) in your Siebel

implementation:

alter user SIEBEL quota unlimited on table_space_name;"

12 "Run the grantusr.sql script from SQL*Plus, using an account with DBA privileges, and using the

following command:

@c:\SIEBEL_ROOT\dbsrvr\oracle\grantusr.sql"

Launch the Database Server Configuration Wizard.

Enter Gateway Name Server Address., and Enterprise Server Name. and click Next.

"Accept the default value displayed in the Siebel Server Directory field. (This is the

SIEBSRVR_ROOT directory, for example, D:\sea7x\siebsrvr.) and Click Next"

"Accept the default path displayed in the Siebel Database Server Directory field. (This is the

DBSRVR_ROOT directory, for example, D:\sea7x\dbsrvr.) and Click Next"

"Select the appropriate RDBMS platform and click Next.

Oracle Database Enterprise Edition"

Select Install Database and click Next.

"Indicate whether or not you have already run the grantusr.sql script to set up table owner and

administrator accounts."

"On the Select Installation Operation screen, click Install Siebel Database, and then click Next.

"

"On the Database Encoding screen, identify the appropriate database encoding method:

■ UNICODE

■ Non-UNICODE"

"On the Language Selection screen, choose the language in which you want to run your database

(for an install database operation), or choose the language you want to add (for an add language

operation). Click Next."

Indicate the name for the ODBC data source, such as SiebSrvr_Sieb78, and then click Next.

"On the Database User Name screen, indicate the following about your database and click Next:

Database User Name. Type the user name of the Siebel administrator; for example, sadmin.

Database Password. Type the password for the Siebel administrator.

Database Password (confirm). Retype the password to confirm it."

"On the Database Table Owner screen, indicate the following about your database, and then click

Next:

Database Table Owner. Type the name of the Siebel Database table owner, or the account that

will own the Siebel objects; for example, ora*** for Oracle and siebel for DB2 UDB and MS SQL

Server.

Database Table Owner Password. Type the password for the Siebel Database table owner.

Database Table Owner Password (confirm). Retype the password to confirm it."

"On the Index Table Space Name screen, indicate the following values, and click

Next to continue:

Index Table Space Name. Type the name for your index table space; for example, DATA01.

Table Space Name. Type the name for your table space; for example, DATA0"

"In the Oracle Parallel Index screen, specify the appropriate environment for your

installation, and click Next to continue:

■ I am not running with Parallel Indexing On

■ I am running with Parallel Indexing On

If you have a single-CPU environment, choose the first option. If you have a multiple-CPU

environment, choose the first or second option, depending on whether you are running with

parallel indexing on."

"In the Log Output Directory screen, accept the default log directory, or enter a new directory

name, and click OK.

By default, logging will occur in the SIEBSRVR_ROOT\log\operation\output directory, where

operation corresponds to the operation you are performing, such as install for Install Database

or install_lang for Add language.

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

SIEBEL_ROOT\siebsrvr\bin\siebupg.exe /m master_operation.ucf

where, for this procedure, operation may be install or install_lang."

Respond to the above prompt in one of the following ways: Cancel or OK

"Review the configuration values you entered on the previous screens in the Database Server

Configuration Wizard:

When you have verified the configuration values, click Finish. Doing so generates SQL files that

you will then apply to the database. When all SQL has been generated, a message appears,

stating “The configuration changes were applied successfully.” Click OK."