海波龙 11.1.2.4安装指南// hyperion install

参考信息

https://www.oracle.com/webfolder/technetwork/cn/obe/hyp_epm/kennedy_install/kennedy_obe.htm#t1s2

 

介绍 

在安装oracle企业绩效管理套件（Hyperion）之前，首先您必须了解所有EPM产品。

List of EPM products:

Oracle Hyperion Foundation Services

 Foundation Services

·Optionally, Oracle HTTP Server

·Oracle WebLogic Server

·Oracle Hyperion EPM Architect

·Oracle Hyperion Calculation Manager

·Oracle Smart View for Office

Oracle Essbase

·    Oracle Essbase

·Oracle Essbase Administration Services

·Oracle Hyperion Provider Services

·Oracle Essbase Studio

Oracle Reporting Analysis and Framework

·         Oracle Hyperion Reporting and Analysis Framework

·         Oracle Hyperion Interactive Reporting

·         Oracle Hyperion Financial Reporting

·         Oracle Hyperion SQR Production Reporting

·         Oracle Hyperion Web Analysis

Oracle Hyperion Planning

·         Hyperion Planning  Web Application

·         Hyperion RMI Registry

 

安装

用途	主机名	IP地址	操作系统
HP应用服务器	WIN	172.16.2.186	Win2008 Ent X64
Oracle数据库服务器	DXJ	172.16.2.187	CENTOS X64
Essbase数据库服务器	WIN	172.16.2.187	Win2008 Ent X64

前提：我数据库安装在了Linux中，所以在windows中装一个客户端就可以了

 

数据库配置

--表空间

CREATE TABLESPACE sdt1

DATAFILE '/home/oracle/app/oracle/product/sdt1.dbf' size 800M

         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

--索引表空间

CREATE TABLESPACE sdt1_Index

DATAFILE '/home/oracle/app/oracle/product/sdt1_Index.dbf' size 512M        

         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;    

 

--2.建用户

create user hp identified by hp

default tablespace sdt1;

 

--3.赋权

grant connect,resource to hp;

grant create any sequence to hp;

grant create any table to hp;

grant delete any table to hp;

grant insert any table to hp;

grant select any table to hp;

grant unlimited tablespace to hp;

grant execute any procedure to hp;

grant update any table to hp;

grant create any view to hp;

 

--4 （这个是因为我安装完成后诊断发现权限不够，执行赋权成功）

GRANT "CONNECT" TO hp;

GRANT "RESOURCE" TO hp;

GRANT create view TO hp;

GRANT create session TO hp;

ALTER USER hp DEFAULT ROLE "RESOURCE";

 

 

Window2008r2配置

 

 

下载并解压到同一文件夹下（询问是否替换，选择替换即可）

设置IP，主机名称

关闭系统更新

关闭防火墙

修改host信息

下载安装jre-6u45-windows-x64.exe

安装Oracle client

 

配置用户权限

本地安全策略，确定拥有权限

 

已安装并配置了 Microsoft Internet Information Server (IIS) 6.0，包括 ASP

运行installTool.cmd，一直下一步，如果遇到配置数据库连接的地方，配置自己的数据库连接即可

 

 

诊断

安装完成后，诊断，查看是否有问题

 

 

看是否都是正常的