Siebel IP2016 – Siebel Enterprise Server Installation Part 2

Siebel IP2016 – Siebel Enterprise Server Installation Part 1

Step 5: Siebel Database Installation

To install Siebel database, we need to follow some prerequisites.

Oracle client needs to be installed on that machine on which siebel server is going to be installed.

Once client is installed, TNS entry need to be added in proper path
After adding TNS entry, test whether the siebel application servers are able to access database by using sqlplus [for ex: sadmin/sadmin@SBLTST]

Create Tablespace

create tablespace SIA_DATA datafile '/oracle/oradata/data.dbf' size 5G autoextend on;
create tablespace SIA_INDEX datafile '/oracle/oradata/index.dbf' size 5G autoextend on;

Creating Roles and Users in Database

Open the Oracle SQL Plus
Type the Login Name and Password and login to the Oracle SQL Plus

Create SSE Role

create role sse_role;
grant create session to sse_role;

Create TBLO Role

create role tblo_role;
grant ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE INDEXTYPE,CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION,CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW,SELECT_CATALOG_ROLE, EXECUTE_CATALOG_ROLE, ADVISOR, CREATE DIMENSION,CREATE MATERIALIZED VIEW, QUERY REWRITE, ON COMMIT REFRESH,CREATE ANY SYNONYM to tblo_role;

Create SIEBEL User

create user SIEBEL identified by SIEBEL;
grant tblo_role to SIEBEL;
alter user SIEBEL quota 0 on SYSTEM;
alter user SIEBEL default tablespace SIA_DATA;
alter user SIEBEL temporary tablespace temp;
alter user SIEBEL quota unlimited on SIA_DATA;
alter user SIEBEL quota unlimited on SIA_INDEX;

Create SADMIN User

create user SADMIN identified by SADMIN;
grant sse_role to SADMIN;
alter user SADMIN default tablespace SIA_DATA;
alter user SADMIN temporary tablespace temp;

Step 5.1: Check Database Connectivity

Source the siebenv.sh file and test the odbc connectivity by running the following command

cd /oraclesiebel/siebsrvr
. ./siebenv.sh
cd bin
$ ./odbcsql /s SBA_81_DSN /u SADMIN /p *******

A successful connection suggests that all the steps are correct and we can proceed further.

Step 5.2: Creating dbenv Script

Steps to follow to succeed in using odbc connection from siebel server directory:

Copy the odbc.ini file from gtwysrvr/sys directory to siebsrvr/sys directory
Copy the siebenv.sh file gtwysrvr directory to siebsrvr directory
Substitute in both files “gtwysrvr” by “siebsrvr” in all paths.
Run CreateDbSrvrEnvScript from $SIEBSRVR_ROOT/install_script/install.
```
./CreateDbSrvrEnvScript /u01/SBA_81 enu Oracle
```
Check if dbenv.sh created or not on location $SIEBSRVR_ROOT

Step 5.3: Installing Siebel Database

Navigate to $SIEBEL_HOME/siebsrvr directory
Run . ./dbenv.sh
Navigate to $SIEBEL_HOME/config directory
For gateway use command ./config.sh -mode dbsrvr
Select appropriate Siebel server and Database server directory

[su_slider source=”media: 1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120″ link=”lightbox” target=”blank” width=”1220″ height=”600″ autoplay=”0″]

Once the Db server Configuration is successful we need to execute the following command-

$<SIEBEL_ROOT> ./srvrupgwiz /m master_install.ucf
Once this task is complete the following screen will be displayed

NOTE: It will take some 1/5 to 2 Hrs for the entire Siebel seed data to get imported. After this process completes successfully you can test the Siebel Database objects by logging into Siebel Server Tools. For first time it will now prompt the user to enter the License before logging into the Siebel Tools. This is where we can enter the license keys.

Siebel IP2016 – Siebel Enterprise Server Installation Part 3

[su_divider]

@AskmeSiebel