Installing Hyperion 11.1.2.1.0 on Windows Server 2008 R2 x64 (64Bit):

Pre-requisites:

Oracle client software must be installed, with tnsnames configured to point to database in 2)
Database used must be in UTF-8 character set
IIS on Server 2008 need to be installed
The files below must all be in one directory, and unzipped into the same directory, not each zip file into it's own directory:

Below Software from: Oracle Enterprise Performance Management (11.1.2.1.0) Media Pack for Microsoft Windows x64 (64-Bit) B64244-01 v4

V14803-01 - Data Integrator 10g (10.1.3.5.0).zip

V20858-01 - Smart Search Command Line Utility.zip

V24338-01 - WebLogic Server 11gr1 10.3.4.zip

V25459-01 - Hyperion Foundation Services 5 of 7.zip

V25460-01 - Hyperion Foundation Services 6 of 7.zip

V25461-01 - Hyperion Foundation Services 7 of 7.zip

V25462-01 - Calculation manager 11.1.2.1.0.zip

V25463-01 - Performance Manager Architect.zip

V25464-01 - EssBase 11.1.2.1.0 1 of 2.zip

V25466-01 - EssBase Clients 11.1.2.1.0.zip

V25467-01 - Spreadsheet Add-in.zip

V25468-01 - Financial Reporting Fusion Edition.zip

V25469-01 - Reporting Studio And Print Server Fus Ed.zip

V25470-01 - Reporting and Analysis Core Components.zip

V25471-01 - Interactive Reporting 11.1.2.1.0 - 1 of 2.zip

V25473-01 - SQR Prod Reporting 1 of 2.zip

V25475-01 - Web Analysis.zip

V25476-01 - Financial management Fus Ed.zip

V25477-01 - Hyperion Planning.zip

V25478-01 - Hyperion Planning Fus Ed Offline.zip

V25479-01 - Financial Data Quality Mang Fus Ed.zip

V25480-01 - Financial Data Quality Mang Adapter Suite Fus Ed.zip

V25481-01 - Financial Data Quality Mang Adapter for Fin Management.zip

V25482-01 - Financial Data Quality Mang ERP Src Adapter For SAP Fus Ed.zip

V25483-01 - Profitability And Cost Managements Fus Ed.zip

V25487-01 - Smart View For Office Fus Ed.zip

V25488-01 - Performance Scorecard Fus Ed.zip

V25489-01 - Strategic Finance.zip

V25490-01 - Strategic Finance For Banking.zip

V25491-01 - Disclosure Management.zip

V25492-01 - Disclosure Management Client.zip

V25493-01 - Financial Close Management.zip

V25494-01 - Enterprise Perf Management System Additional Content.zip

V25495-01 - Performance Management System installer, Fusion Edition.zip

V25496-01 - Hyperion Foundation Services 1 of 7.zip

V25497-01 - Hyperion Foundation Services 2 of 7.zip

V25498-01 - Hyperion Foundation Services 3 of 7.zip

V25499-01 - Hyperion Foundation Services 4 of 7.zip

V25500-01 - EssBase 11.1.2.1.0 2 of 2.zip

V25501-01 - Interactive Reporting 11.1.2.1.0 - 2 of 2.zip

V25502-01 - SQR Prod Reporting 2 of 2.zip

V26655-01 - EssBase Analytics Link.zip

V27189-01 - Integrated Operational Planning.zip

V27190-01 - Integrated Margin Planning.zip

V27255-01 - Data Relationship management Fus Ed.zip

I had to modify the installTools.cmd as follows, because it did not detect my system as Windows X64:

From:

@echo off

setlocal

set dirname=%~dp0

set arg=%1

set POSTED_JAVA=%dirname%\jre\win32\1.6.0

set VERSION=11.1.2.0

set TIMEU=%time:~0,8%

set TIMEF=%TIMEU::=.%

set DATEU=%date:/=.%

set DATEF=%DATEU: =-%

set DATE_TIME=%DATEF%-%TIMEF%

if "%PROCESSOR_ARCHITECTURE%" == "IA64" (

set POSTED_JAVA=%dirname%\jre\winIA64\1.5.0

)

if "%PROCESSOR_ARCHITECTURE%" == "AMD64" (

set POSTED_JAVA=%dirname%\jre\winAMD64\1.6.0

) else if "%PROCESSOR_ARCHITEW6432%" == "AMD64" (

set POSTED_JAVA=%dirname%\jre\winAMD64\1.6.0

) else if "%PROCESSOR_ARCHITEW6432%" == "IA64" (

set POSTED_JAVA=%dirname%\jre\winAMD64\1.6.0

)

if "%PROCESSOR_ARCHITECTURE%" == "x86" (

set POSTED_JAVA=%dirname%\jre\win32\1.6.0

)

if exist %POSTED_JAVA% set JAVA_HOME=%POSTED_JAVA%

if "%arg%" == "" (

start "EPM System Installer" "%POSTED_JAVA%\bin\java" -javaagent:"%dirname%\installTool.jar" -Xmx768M -DRELEASE_VERSION=%VERSION% -DINSTALL_TOOL_DIR=%dirname% -Djava.library.path="%TMP%" -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file="%dirname%\installTool-logging.xml" -DDATE_TIME="%DATE_TIME%" -jar "%dirname%\installTool.jar %*"

) else (

title EPM System Installer

"%POSTED_JAVA%"\bin\java -javaagent:"%POSTED_JAVA%"\..\..\..\installTool.jar -Xmx768M -Djava.library.path="%TMP%" -DRELEASE_VERSION=%VERSION% -DINSTALL_TOOL_DIR=%dirname% -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file="%dirname%\installTool-logging.xml" -DDATE_TIME="%DATE_TIME%" -jar "%POSTED_JAVA%"\..\..\..\installTool.jar %*

)

endlocal

To:

@echo off

setlocal

set dirname=c:\tmp\new

set arg=%1

set POSTED_JAVA=c:\tmp\new\jre\winAMD64\1.6.0

set VERSION=11.1.2.0

set TIMEU=%time:~0,8%

set TIMEF=%TIMEU::=.%

set DATEU=%date:/=.%

set DATEF=%DATEU: =-%

set DATE_TIME=%DATEF%-%TIMEF%

if "%PROCESSOR_ARCHITECTURE%" == "IA64" (

set POSTED_JAVA=%dirname%\jre\winIA64\1.5.0

)

if "%PROCESSOR_ARCHITECTURE%" == "AMD64" (

set POSTED_JAVA=%dirname%\jre\winAMD64\1.6.0

) else if "%PROCESSOR_ARCHITEW6432%" == "AMD64" (

set POSTED_JAVA=%dirname%\jre\winAMD64\1.6.0

) else if "%PROCESSOR_ARCHITEW6432%" == "IA64" (

set POSTED_JAVA=%dirname%\jre\winAMD64\1.6.0

)

if "%PROCESSOR_ARCHITECTURE%" == "x86" (

set POSTED_JAVA=%dirname%\jre\winAMD64\1.6.0

)

if exist %POSTED_JAVA% set JAVA_HOME=%POSTED_JAVA%

if "%arg%" == "" (

) else (

title EPM System Installer

)

endlocal

Start the installer by double-clicking on installTool.cmd

http://learn.iis.net/page.aspx/29/installing-iis-7-on-windows-server-2008-or-windows-server-2008-r2/

You will get the below error when Prerequisite 2) as mentioned above is not in place

You will get the below errors should the prerequisites from 1) and 2) in the beginning not be in place.

Change character set of the existing database:

SQL> alter system set cluster_database=false scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup restrict;

ORACLE instance started.

Total System Global Area 764121088 bytes

Fixed Size 2217264 bytes

Variable Size 557845200 bytes

Database Buffers 197132288 bytes

Redo Buffers 6926336 bytes

Database mounted.

Database opened.

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;

Database altered.

SQL> alter system set cluster_database=true scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 764121088 bytes

Fixed Size 2217264 bytes

Variable Size 557845200 bytes

Database Buffers 197132288 bytes

Redo Buffers 6926336 bytes

Database mounted.

Database opened.

SQL> show parameter cluster;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cluster_database boolean TRUE

cluster_database_instances integer 1

cluster_interconnects string

SQL>

Just on Continuing, my installer crashed with the below message:

Restarted the Configurator from :

Start the “EPM System Configurator” (available on the Windows Start Menu under All Programs / Oracle EPM System / Foundation Services / EPMSystem Configurator ).

Select YES on the below error, which is due to the installer which crashed in the above update