✍ Kashif M
Trends

Saturday, 24 August 2013


OBIA - Pre-installation Tasks for Oracle Business Intelligence Application


By on August 24, 2013




Download Softwares

• Download Java JDK for Sun and Windows operating system

• Download Hibernate Libraries

• Download OBIEE and BI Applications Software

Create Databases

Before you install Oracle Business Intelligence Applications and Informatica PowerCenter, create database tablespaces for:

• BAWDEV (Data Warehouse tables)
• DACDEV (DAC Metadata tables)
• INFADEV (Informatica Repository Metadata tables)
• INFADMDEV (Informatica Domain tables)

Create a database role named SSE_ROLE and granted insert, update, delete, select and basic DBA privileges.

CREATE ROLE "SSE_ROLE" NOT IDENTIFIED; GRANT CREATE CLUSTER TO "SSE_ROLE"

GRANT CREATE DATABASE LINK TO "SSE_ROLE"
GRANT CREATE DIMENSION TO "SSE_ROLE"
GRANT CREATE MATERIALIZED VIEW TO "SSE_ROLE"
GRANT CREATE PROCEDURE TO "SSE_ROLE"
GRANT CREATE ROLE TO "SSE_ROLE"
GRANT CREATE SEQUENCE TO "SSE_ROLE"
GRANT CREATE SESSION TO "SSE_ROLE" GRANT CREATE SYNONYM TO "SSE_ROLE"
GRANT CREATE TABLE TO "SSE_ROLE"
GRANT CREATE TRIGGER TO "SSE_ROLE"
GRANT CREATE TYPE TO "SSE_ROLE" GRANT CREATE VIEW TO "SSE_ROLE"
GRANT "SELECT_CATALOG_ROLE" TO "SSE_ROLE";


Assign this role to the database user BAWDEV, DACDEV, INFADEV and INFADMDEV


Kashif
mkashu: OBIA - Pre-installation Tasks for Oracle Business Intelligence Application
Review : Kashif | Kashif
Update: August 24, 2013 | Rating: 4.5

Comment for "OBIA - Pre-installation Tasks for Oracle Business Intelligence Application"

0 comments

Post a Comment

Blog Archive