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.

--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;

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 language 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.

Hit Next

Specify the SADMIN user created and specified before.

Hit Next

Enter the SADMIN users Password as defined earlier. Note that the passwords are case sensitive, and the username is not.. Go figure..

As a good rule, allways write the usernames UPPERCASE, and the passwords CaseSensitive.
Hit Next

Identify the SIEBEL user.

Hit Next

And the Case Sensitive password defined earlier for this user.

Hit Next

Enter the Index tablespace name used when the index datafiles were created.

Hit Next

And the Tables tablespace name too.

Hit Next

Choose to enter Licence Keys Now or Later.

For development and testing purposes you can find keys here:
http://www.oracle.com/us/support/licensecodes/siebel/index.html
Hit Next

Indicate if you set up for parallel (we did not).

Hit Next

Provide the Name of the SSE_ROLE created with the SQL Script earlier

Hit Next

We want the log file!, Yes Please!

Hit Next

Yes, lets Apply this now!

Hit Next

Review Configuration Choices

Hit Next

Ah that’s classic Siebel – complete with the old logo from way back in Siebel 6 and before 😉

Hit OK

Watch the Progress

And wait for completion….

Completed with Success!

Hit OK

And we are done.

There is a database postinstallation task:
copy all *.saf files in the dbsrvr\FILES directory to the Siebel File System’s att directory.

Now we are ready to Configure the Siebel Server. Read on in the next part in the series “Install and Configure the Siebel Server” 


 

Enjoy!

 

/Henrik

Leave a Reply

Your email address will not be published. Required fields are marked *