Oracle Database Installation - Oracle 11g R2 (Windows)

Installing the Oracle 11g R2 database Using OUI in Windows

There are two methods that you can use to install the Oracle software: basic and advanced. Choose the basic installation method to quickly the install the software with minimal user input. The advanced installation method enables you to perform a custom installation.

A.	Basic Installation
B.	Advanced Installation

Follow the steps below to install the Oracle software and create a database using the advanced installation method,

1. At the Configure Security Updates window, enter your e-mail address and Oracle Support password and click Next.

If you choose to not supply your email address and Oracle Support password, uncheck the check box, leave both text boxes empty, and then click Next. When prompted, click Yes.

At the Installation Option window, select Create and configure a database and click Next. 

At the System Class window (Select according to requirements), select Server Class and click Next.

At the Grid Options window, select Single instance database installation and click Next.

At the Install Type window, select Advanced install and click Next.

At the Product Languages window, select the required languages and then click Next.

At the Database Edition window, make sure that Enterprise Edition is selected and click Next.

At the Installation Location window, accept the defaults (Can be modified according to requirements) and click Next.

At the Configuration Type window, make sure the type of database is set to General Purpose / Transaction Processing for normal Siebel server requirements and click Next.

At the Database Identifier window, the Default SID will be “orcl” and can be chanced.

At the Configuration Options window, for the memory tab, you can accept the defaults. Click the Character sets tab.

Change the setting to Use Unicode (AL32UTF8) and then click Next.

At the Management Options window, accept the defaults and click Next.

At the Database Storage window, accept the defaults and click Next

At the Backup and Recovery window, accept the defaults and click Next.

At the Schema Passwords window, Provide same or different Oracle Recommended password for all accounts and confirm the password.  Click Next.

In the Next step, the OUI will check the system requirements and prerequisites

.

Click the Finish button to start configuration of database and listener.

Check the Services to make sure the database and listener is started and running.

Siebel Web Architecture - Overview

The Siebel Web Architecture

At a high level, the Siebel Web architecture consists of:

•  Siebel Web Clients that access and display the business data
• A Gateway Name Server that stores configuration information
• A Web server that handles interactions with the Web Clients and distributes requests to the Siebel Servers
• Servers that manage the business data and provide batch and interactive services for clients
• A relational database and file system that store business data

Web Usage Login Scenario

Siebel Web Client (browser) sends the URL to the Web server

 URL specifies:

• Either HTTP or HTTPS protocol
• Web server machine name
• Application and language

 URL initially connects to a Siebel-specific virtual directory on the Web server

·         Virtual directories are created as part of the Siebel installation

·         Virtual directory forwards request to the Siebel Web Server Extension (SWSE) installed on the Web server

·         SWSE uses the eapps.cfg configuration file to obtain connection parameters

Eapps.cfg specifies the location of the server, server connection broker port, Enterprise, and Object Manager information for initial connection

•  For multi-server installations provides load balancing information
• Also provides generic login information for initial “anonymous” access to database

Siebel Gateway Name Server

Stores component definitions and assignments, operational parameters, and connectivity information

•  For example, connect strings to query servers for server/component availability
•  Information stored in siebns.dat file on Gateway Name Server

Siebel Enterprise

• Is a logical collection of Siebel Servers that support users and access a single database server and the Siebel file system
• Logically groups Siebel Servers for common administration via Siebel Server Manager
• Supports sharing of common configuration information

Siebel Servers

Execute tasks to manage the business data

• Programs known as server components perform specific functions or jobs for the server
•  For example:
•  Importing and exporting data
• Configuring the database to monitor for user-defined conditions
•  Processing of client requests

•  Tasks may run interactively, in the background, or as batch jobs

Siebel File System

Is one or more shared directories that store files used by Siebel applications

•  Files are compressed in a proprietary format to save space and provide security
•  Examples: Product literature, sales tools, presentations, user profiles

Database Server

• Stores data used by Siebel applications in a predefined database schema
• Single database for Enterprise provides data consistency for users
•  Data is accessed by components through a data manager layer

• Supports a variety of third-party relational database management systems (RDBMS)