Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5

HI,

Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5.

Issue: 1
while installing obiee11.1.1.5.0 (software only install ) on win7 64 bit SP1 version i am getting Executing:opmnctl start coreapplication_obisch1 error at the last step

Issue 2:
OBIEE 11g Install On Windows 7 Hangs At Creating Domain Step (Doc ID 1209259.1)
Refer:http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.xls

Solution:
Please kindly refer to the Certification matrix available from :
http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.xls

Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5.

Install OBIEE 11.1.1.5 only on certified platform
ie. Windows 2003 with SP2/R2+
or Windows Server 2008 with SP1+
Window 7 is only certified as an OBIEE client.

For more Refe:SR 3-4684846891: Executing:opmnctl start coreapplication_obisch1 while installing obiee11g (11.1.1.5.0) win64bit

Thanks

Deva

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

Unable To Create Session Variable Using Obiee 11.1.1.5 Admin Tool issue

Hi,
   

An interesting thing happen, when I was trying to choose a connection pool for creating a Session variable Init Block , connection pool Select button was disabled. This functionality worked in 11.1.1.3. Just to avoid any doubt I restarted admin tool, followed by machine restart, but end result didn’t change. After looking around, I remembered that in one of the metalink they talked about “Allow First Connection for init block”. I tried that option and it work . Below are the details ::

Issue :

Select button is disabled when trying to choose a connection pool for creating a Session variable Init Block

Solution:

Check “Allow First Connection for init block” to true

For setting “Allow First Connection for init block”  follow below steps :

1. In the Administration Tool, select Tools, then select Options to display the Options dialog.

2. On the General tab, select ”Allow First Connection for init block. (this option is not a best practice and might cause performance issues.)

THanks

DEva

Unable To Export All Rows from a Request to csv, pdf Or Excel In Obiee 11g

Hi,


To implement the solution, please do:

1. Change instanceconfig.xml file in <biee11g_install>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 as following
<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Table>

</Table>
</Views>

3. Note the new elements added are the following to both <Pivot> and <Table>, the Pivot part controls Pivot view, and Table part controls Table View, my testing was done with Table View.
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

4. Restart Presentation Server from EM, then run your request, do pdf export to verify.

Note:

When a table or pivot table includes a large number of rows, a set of buttons can be displayed under the view. You can use the following buttons to page through the rows in the view:

•First 25 Rows — Displays the first 25 rows of data for the view. The number that is used for the First, Previous, and Next buttons is specified by the Rows per Page field in the "Table Properties dialog: Style tab".

•Previous 25 Rows — Displays the previous 25 rows of data for the view.

•Next 25 Rows — Displays the next 25 rows of data for the view.

•Display maximum (500) rows per page — Allows you to display as many as the maximum number of rows per page at one time temporarily. The default is 500. The administrator can specify a different maximum value that is displayed on the tooltip for the button using the MaxVisibleRows element in the configuration file.


THanks

DEva