Manzana - Siebel CRM - All Day Every Day!

Siebel CRM - All Day Every Day!

NAVIGATION - SEARCH

Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 4

Hi,

 

Welcome to Installing Siebel 8.2.2.4 on Windows 2008R2 Server Part 4 of the series

"Doing a Complete install of Siebel 8.2.2.4 on Oracle 11 r2, Win 2008R2. All from Scratch"

In this part we will install and configure the Siebel Database server Software.

To Install a Siebel Development Server we will go through the following steps
  1. Install the Prerequisite Software - this was completed in part 2 (here)
  2. Install and Configure the Siebel Enterprise Server - this was completed in part 3 (here)
  3. Install and Configure the Siebel Database Server (this step)
  4. Install and Configure the Siebel Server
  5. Install and Configure the Siebel Web Server
  6. Patching and Postinstallation Tasks
  7. Installing Siebel Charts
  8. Enabling OpenUI
To Install the Siebel Database server we will go through the following steps:
  1. Create tablespaces, datafiles, roles and users on the Database
  2. Run Siebel Database Server Configuration

Fist step, Run SQL to create Tablespaces, Datafiles, Roles, Grants and Users. parts of this script is similar to what you would find in the grantusr.sql file in the Siebel Databaser server Directory.

Connect to the Siebel Database as System using SQLDeveloper, TOAD or sqlplus. (any tool will do).
I prefer manual management of datafiles. So I create them all by myself, also I max them out at 2GB each.
Use this Script to create your Database, change paths and passwords where appropriate.
[code]
--create siebel tabelspace
CREATE TABLESPACE SIEB8DEV_DATA DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_DATA01.DBF' SIZE 2048M;

ALTER TABLESPACE SIEB8DEV_DATA ADD DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_DATA02.DBF' SIZE 2048M;

ALTER TABLESPACE SIEB8DEV_DATA ADD DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_DATA03.DBF' SIZE 100M AUTOEXTEND ON
    NEXT 1M
    MAXSIZE 2048M;

ALTER TABLESPACE SIEB8DEV_DATA ADD DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_DATA04.DBF' SIZE 100M AUTOEXTEND ON
    NEXT 1M
    MAXSIZE 2048M;

--create siebel indexspace
CREATE TABLESPACE SIEB8DEV_INDX DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_INDX01.DBF' SIZE 2048M;
 
ALTER TABLESPACE SIEB8DEV_INDX ADD DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_INDX02.DBF' SIZE 2048M;

ALTER TABLESPACE SIEB8DEV_INDX ADD DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_INDX03.DBF' SIZE 100M AUTOEXTEND ON
    NEXT 1M
    MAXSIZE 2048M;

ALTER TABLESPACE SIEB8DEV_INDX ADD DATAFILE 'E:\ORACLE\ORADATA\SIEB8DEVDB\SIEB8DEVDB_INDX04.DBF' SIZE 100M AUTOEXTEND ON
    NEXT 1M
    MAXSIZE 2048M;

--Create Base Roles & Users
CREATE ROLE SSE_ROLE;

GRANT CREATE SESSION TO SSE_ROLE;

CREATE ROLE TBLO;

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;

CREATE USER SIEBEL IDENTIFIED BY password_defined_earlier;
GRANT SSE_ROLE,TBLO TO SIEBEL;
ALTER USER SIEBEL QUOTA UNLIMITED ON SIEB8DEV_DATA QUOTA UNLIMITED ON SIEB8DEV_INDX;
ALTER USER SIEBEL DEFAULT TABLESPACE SIEB8DEV_DATA;

CREATE USER SADMIN IDENTIFIED BY password_defined_earlier;
GRANT SSE_ROLE TO SADMIN;

CREATE USER LDAPUSER IDENTIFIED BY password;
GRANT SSE_ROLE TO LDAPUSER;

-- employee facing anon user (used in eapps.cfg)
CREATE USER GUESTERM IDENTIFIED BY password;
GRANT SSE_ROLE TO GUESTERM;

--customer facing anon user (used in eapps.cfg)
CREATE USER GUESTCST IDENTIFIED BY password;
GRANT SSE_ROLE TO GUESTCST;

--check created users
SELECT * FROM DBA_USERS;
[/code]

Execute and verify the outputs of the execution. remember to save the passwords for LDAPUSER, GUESTERM, GUESTCST users, we will need them later.
Verify that you can login as SIEBEL and SADMIN on the database now.

Next we need to run the Siebel Database Server Configuration
Run the "Database Server Configuration" Option from the Start>Programs>Siebel Folder Name


The path to the Siebel server, it should be picked up correctly from the registry.

Hit Next

The Path to the Siebel Database Server, It should be picked up correct from the registry too.

Hit Next

We Use Oracle

Hit Next

We Will Install a Database!

Hit Next

Yes I really mean it, I want to install a database!

Hit Next

Hmm - Again ?? Yes I would really, really like to install a database!

Hit Next

We ran something equivalent to grantusr.sql just before.

Hit Next

When I Created the Database I choose AL32UTF8, so It's unicode.

Hit Next

If you installed more than one langiage choose your primary. (This step may not show if you only install one language.)

Hit Next

Enter the Default DSN Name, you can find it with the x32 version of odbcad32.exe.

The default Name is the enterprise name suffixed with _DSN.
While you are here you can test the DSN entry, if it does not work when testing, do not continue - figure out the error first.