OBIEE 11g Installation and Configuration Steps

Oracle Business Intelligence11g System Requirement

This section contains important information for the system on which you are installing Oracle Business Intelligence11g and the database (MS SQL Server) containing the schemas.requirements: requirements:

Hardware

Disk Space: 20GB or more

Physical Memory: 4GB or more

Available Memory: 1GB or more

Temp Space: 950MB or more

Swap Space: 3GB or more

CPU & Processor: dual-core Intel 32/64 Bit, 2.10GHz or greater

Monitor Display : requires 1024 x 768 minimum resolution
Software Operating System: Windows Xp/Vista/Server 2003/ above with SP2 or higher version
Microsoft Internet Explorer 8.0 above
Microsoft .Net Framework 4.5 SP2 or above version
Static IP Address Required (i.e.: DHCP to access network install Look Back Adopter)
JDK 1.6 or above version
MS SQL Server 2005/2008 Enterprise Edition 32/64 bit
OBIEE 11g (11.1.1.3.0) Version
RCU 11.1.1.3.0 (Repository Creation Utility ) database schema creation

Note By default, TCP/IP properties are configured to use DHCP.

　
　OBIEE 11g Download Link:
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls


Note: Make sure database repository must be created before installation of the components with the Repository Creation Utility (RCU) tool

Database Requirement

Below are the recommended disk space requirements for the database containing the Oracle Business Intelligence Scheduler database tables

500MB Microsoft SQL Server databases for standalone and Business Intelligence applications and deployments

OBIEE 11g and Weblogic Disk Space Requirement

The following list identifies memory requirements for various components.

Use the list as a guideline for determining the memory requirements specific to your

deployment:

WebLogic Administration Server: 750 MB

WebLogic Managed Server running Oracle Directory Integration Platform and

Oracle Directory Services Manager: 720 MB

WebLogic Managed Server running Oracle Identity Federation: 650 MB

Oracle Internet Directory: 75 MB

Oracle Virtual Directory: 105 MB

Oracle Enterprise Manager (EM) Agent: 25 MB

Oracle Process Manager and Notification Server (OPMN): 5 MB

Oracle Identity Management requires 2,200 MB of disk space if you are only installing the software (you select the Install Software - Do Not Configure installation type). If you configure the software, an additional 150 MB of space are required if all components are selected for configuration.

RCU Supported Platforms:

RCU is available only on 32-bit x86 Linux and 32-bit Microsoft Windows operating system platforms. You can run RCU from these machines to connect to any certified versions of Oracle, IBM DB2, or Microsoft SQL Server database in order to create the schemas required by Fusion Middleware components. The database server can be running on any platform that is supported by its respective database.

RCU Schema Creation through MSSQL Server Script :

Note: don’t create short cut database/table creation because you can’t able to succeeded on Metadata configuration in your RCU DB Schema

USE [master]CREATE DATABASE [OracleBI] ON PRIMARY (NAME = N’OracleBI’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\OracleBI.mdf’ , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )LOG ON ( NAME = N’OracleBI_log’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\OracleBI_log.ldf’ , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)COLLATE
GO SQL_Latin1_General_CP1_CI_ASEXEC
GO dbo.sp_dbcmptlevel @dbname=N’OracleBI’, @new_cmptlevel=90IF (1 = FULLTEXTSERVICEPROPERTY(‘IsFullTextInstalled’))begin
EXEC [OracleBI].[dbo].[sp_fulltext_database] @action = ‘disable’endGOALTER
GO DATABASE [OracleBI] SET ANSI_NULL_DEFAULT OFF ALTER
GO DATABASE [OracleBI] SET ANSI_NULLS OFF ALTER
GO DATABASE [OracleBI] SET ANSI_PADDING OFF ALTER
GO DATABASE [OracleBI] SET ANSI_WARNINGS OFF ALTER
GO DATABASE [OracleBI] SET ARITHABORT OFF ALTER
GO DATABASE [OracleBI] SET AUTO_CLOSE OFF ALTER
GO DATABASE [OracleBI] SET AUTO_CREATE_STATISTICS ON ALTER
GO DATABASE [OracleBI] SET AUTO_SHRINK OFF ALTER
GO
ALTER
GO DATABASE [OracleBI] SET CURSOR_CLOSE_ON_COMMIT OFF ALTER
GO DATABASE [OracleBI] SET CURSOR_DEFAULT GLOBAL ALTER
GO DATABASE [OracleBI] SET CONCAT_NULL_YIELDS_NULL OFF ALTER
GO DATABASE [OracleBI] SET NUMERIC_ROUNDABORT OFF ALTER
GO DATABASE [OracleBI] SET QUOTED_IDENTIFIER OFF ALTER
GO DATABASE [OracleBI] SET RECURSIVE_TRIGGERS OFF ALTER
GO DATABASE [OracleBI] SET DISABLE_BROKER ALTER
GO DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ALTER
GO DATABASE [OracleBI] SET DATE_CORRELATION_OPTIMIZATION OFF ALTER
GO DATABASE [OracleBI] SET TRUSTWORTHY OFF ALTER
GO DATABASE [OracleBI] SET ALLOW_SNAPSHOT_ISOLATION OFF ALTER
GO DATABASE [OracleBI] SET PARAMETERIZATION SIMPLE ALTER
GO DATABASE [OracleBI] SET READ_WRITE ALTER
GO DATABASE [OracleBI] SET RECOVERY FULL ALTER
GO DATABASE [OracleBI] SET MULTI_USER ALTER
GO DATABASE [OracleBI] SET PAGE_VERIFY CHECKSUM ALTER
GO DATABASE [OracleBI] SET DB_CHAINING OFF ALTER

GO
DECLARE
SELECT @collate sysname @collate = convert(sysname, serverproperty(‘COLLATION’))IF ( charindex(N’_CI’, @collate) > 0 )BEGIN
select @collate = replace(@collate, N’_CI’, N’_CS’)exec (‘ALTER database OracleBI COLLATE ‘ + @collate)ENDGO

Go to path like this C:\Deva\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome\BIN

\RCU.MS-DOS Batch File type

II) Unzip the RCU zip file into some directory and run the rcu.bat under BIN directory. Make sure your database is up before running the RCU; this will install the BI and Metadata schema. database [OracleBI] SET READ_COMMITTED_SNAPSHOT ON DATABASE [OracleBI] SET AUTO_UPDATE_STATISTICS ON
GO