OBIEE Online Training

Friday, September 23, 2011

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

1 comment:

  1. Bluehost is ultimately the best hosting company with plans for all of your hosting needs.

    ReplyDelete