Oracle Business Intelligence Enterprise Edition (OBIEE) Product Information Center (PIC) [ID 1267009.1]
RCU Fails With Non-AL32UTF8 Character Set [ID 1063712.1]
OBIEE 11g: AL32UTF8 NLS Character Set Warning While Installing Repository [ID 1306746.1]
OBIEE 11g Hardware Sizing Information [ID 1290365.1]
OBIEE 11g: How To Check the Log Files [ID 1262647.1]
What are all the logs and configuration files for OBIEE 11G and where to find them? [ID 1275087.1]
FAQ: How To Find OBIEE 11g System Requirements And Platform / Operating System Prerequisites [ID 1323652.1]
Issue With Repository Creation Utility (RCU) - Failed to connect database [ID 1463175.1]
How To Stop OBIEE 11.1.1.1.5.0. on Unix or Linux. [ID 1415581.1]
OBIEE 11.1.1.6: Installation On Linux 64 Bit Fails With 'Error In invoking Target 'ntcontab.o' Make File' [ID 1442492.1]
OBIEE 11g: How to Apply Patches Using Opatch [ID 1220799.1]
CLONE OBIEE APPS [ID 953794.1]
OBIEE stands for Oracle Business Intelligence Enterprise edition (Formerly known as Siebel analytics). In old fashion language Siebel Analytics is a Data Warehouse that were coming out of the box with pre configured ETL mappings from source (Siebel CRM) to target (DW) with its reporting component DASHBOARD (Siebel Answers, Disconnect analytics and Administration tool to build dashboard reports => .rpd file) When Oracle Corp. has acquired Siebel System and decided to make Siebel analytics their flagship analytic engine and renamed it OBIEE (OBIEE server + ETL engine+ Reporting). Now this product is coming with preconfigured ETL mappings and DW schema available for Siebel CRM, Oracle E Business Suite (Financials, HR etc.), JD Edwards, and SAP. So keep in mind OBIEE is a complete Data Warehouse technology (Server+ application+ ETL+ Report).
"Difference between Discoverer and OBIEE? Think of Discoverer as like a Generation 1 business intelligence product. Think of OBIEE as like a Generation 2 business intelligence product. My suspicion is that Oracle will no longer put much time and money into enhancing Discoverer going forward. What you see today with Discoverer is probably what you will get. OBIEE is Oracle's stated direction for business intelligence. So if you are looking long term, OBIEE is the way to go. It is much more complex than Discoverer. It is much more expensive than Discoverer. It takes a lot longer to implement than Discoverer. There may be more Oracle customers today running Discoverer than OBIEE (I don't know for sure - just speculation on my part), but long term Discoverer is going to fade away and OBIEE will become the dominant Oracle BI solution."
Oracle Business Intelligence is a comprehensive set of integrated tools and technologies and includes :
1) Oracle Business Intelligence Enterprise Edition
-Oracle BI Answers
-Oracle BI Interactive Dashboards
-Oracle BI Delivers
-Oracle BI Administration Tool
-Oracle BI Job Manager
-Oracle BI Catalog Manager
-Oracle BI Add-in for Microsoft Office,
-Oracle BI Publisher
2) Oracle Real-Time Decisions
3) Oracle Business Intelligence Publisher
You can install Oracle Business Intelligence Enterprise Edition and Oracle Business Intelligence Publisher, or choose between separately installing Oracle Business Intelligence Publisher and Oracle Real-Time Decisions, or you can install all three of these products using Oracle Business Intelligence 11g Installer.
All Oracle Business Intelligence products intended for a WebLogic domain must be installed and configured at the same time. You cannot install some products now and then install others to the same WebLogic domain later. For example, if you choose to install and configure Oracle Business Intelligence Enterprise Edition but not Oracle Real-Time Decisions, you cannot later add Oracle Real-Time Decisions to the WebLogic domain. Similarly, any WebLogic domains that contain Oracle Business Intelligence 11g products should not be extended later to include other Oracle Fusion Middleware
products.
Oracle Business Intelligence Directory Structure :
A typical Oracle Business Intelligence installation consists of a Fusion Middleware home(user defined) and the following main subdirectories:
■ wlserver_10.3: The WebLogic Server home, which contains Java components.
■ user_projects: The User Projects directory, which contains product domains (including one or more Oracle Business Intelligence domains), the Administration Server, and one or more Managed Servers.
■ Oracle_BI1: The Oracle home, which contains all the binary files (read-only) that
are specific to Oracle Business Intelligence.
Installation steps :
1) jrockit-jdk1.6.0_29-R28.1.5-4.0.1-linux-x64.bin
2) Install database 11g
3) RCU (Repository Creation Utility)
4) OBIEE 11G (11.1.6) install
5) Informatica Installation
Oracle BI Suite EE 11gR1 (11.1.1.6.0) is certified with WebLogic Server 10.3.5 and WebLogic Server 10.3.6
a) REQUIRED PACKAGES
All packages which are required for the oracle 11g database isntallation
compat-db-4.1.25-9
b) MODIFY OS PARAMETERS
a) edit limits.conf
Set the hard and soft limit to the OBI user by modifying the file limits.conf such as for a database installation:
obidev soft nofile 4096 obidev hard nofile 65536
b) The maximum File-descriptor must be at least 4096
To discover the file-descriptor settings, run the command ulimit -a
Or set file-descriptor using the command ulimit -n 4096
[root@oel11g dev]# ulimit -a|grep open open files (-n) 4096
c) Environment Variable
You can add them in the .profile shell startup script of the obi user.
# File Descriptor Limit ulimit -n 10240 # Database Parameters ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 export ORACLE_HOME TNS_ADMIN=$ORACLE_HOME/network/admin export TNS_ADMIN PATH=$ORACLE_HOME/bin:/opt/bin:$PATH export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH export LD_LIBRARY_PATH
1) CREATE OS GROUP
Creation of the oinstall group
[root@oel11g ~]# groupadd oinstall
2) CREATE OS USER
create a OS user named obidev using
useradd obidev -c "Super User for OBIEE DEV" -s "/bin/bash" -p password -g oinstall
3) CREATE DIRECTORIES
mkdir -p /MiddlewareHome chown -R obidev:oinstall /MiddlewareHome chmod -R 775 /MiddlewareHome
jrockit-jdk Installation
Install 11g database
IMPORTANT: Remember to take AL32UTF8 as characterset
export ORACLE_HOME=/
export ORACLE_SID=
export TNS_ADMIN=$ORACLE_HOME/network/admin
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export PATH
Creation of the metadata repository (with RCU)
Before installing Oracle Business Intelligence, use RCU to create the Metadata Services (MDS) and Business Intelligence Platform (BIPLATFORM) schemas in your database.
Two metadata repositories are needed:
a) the Metadata Services (MDS)
b) and Business Intelligence Platform (BIPLATFORM) .
> To run RCU, you must possess the DBA privilege and logged in as SYSDBA (for example, as user SYS).
> When you run RCU, you are creating databases schemas and tablespaces using CREATE ANY SCHEMA, ALTER ANY SCHEMA, CREATE TABLE, CREATE TABLESPACE, and so on.
> RCU updates the schema_version_registry by writing entries to the system.schema_version_registry$ system table.
> Each Oracle Business Intelligence system (BI domain) requires its own set of database schemas. Two or more systems cannot share the same set of schemas (repository).
> The following privileges are granted to users created by RCU:
a) resource
b) connect
c) create sequence
RCU is available on 32-bit and 64-bit Linux and Windows platforms.
RCU INSTALL STEPS:
1) Go to RCU_HOME/bin
Start RCU:
Linux and UNIX: ./rcu
Welcome > Next
2) Step 1 of 7:
Create Repository > Create > Next
3) Step 2 of 7:
Database Connection Detail > Fill in the connection detail > Next
Click Next. The Checking Prerequisites screen opens. After the checks conclude with no errors, click OK to dismiss the screen and proceed to the Select
Components screen.
4) Step 3 of 7:
Component Detail > Select the Oracle Business Intelligence Compoment.
This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group), which is also required by Oracle Business Intelligence.
In the Select Components screen, near the top of the screen, select Create a new Prefix. The default prefix is DEV. You can provide another prefix, if preferred.
Click the plus sign (+) next to the Business Intelligence component group. Then, click Business Intelligence Platform so that a check appears next to it. This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group), which is also required by Oracle Business Intelligence.
Click Next. The Checking Prerequisites screen opens. After the checking is complete with no errors, click OK to dismiss the screen and proceed to the Schema Passwords screen.
5) Step 4 of 7:
Schema Passwords > Use Same Password for all schemas (pwd)
From the documentation: If you do not select the Use same password for all schemas option and provide a single password for both schemas to share, issues might occur with your Oracle Business Intelligence installation.
select Use same password for all schemas, and provide and confirm a password for the schemas.
Click Next to proceed to the Map Tablespaces screen.
6) Step 5 of 7:
Map TableSpaces > Next. Validation. Ok.
7) Step 6 of 7:
Summary > Next.
In the Summary screen, click Create. The Create screen opens and the RCU creates the schemas. After the schemas are created with no errors, the Completion Summary screen opens.
8) Step 7 of 7:
Completion Summary > Close. The log files are in the directory RCU_HOME\log.
Start the OBIEE Installer
On Linux, running Oracle Business Intelligence 11g Installer as the root user is not supported.
Oracle Business Intelligence 11g Installer automatically assigns the Node Manager port (default = 9556), unless you specify your Oracle Business Intelligence ports manually using a configuration file such as staticports.ini.
cd bishiphome/Disk1/
For UNIX:
./runInstaller.sh
Step 1 of 12:
Welcome > Next
Step 2 of 12:
Type Install: Enterprise Install > Next
Step 3 of 12:
Pre-requisite Check > Next
Linux: package: compat-db-4.1.25-9, kernel parameters (hard nofiles 4096, soft nofiles 4096)
Click Create New BI System and specify the following:
■ The user name and password of the system administrator
■ The domain name for the new Oracle Business Intelligence system
Click Next to continue
Step 4 of 12:
Oracle Middleware Home > Enter the directory path without trailing space. Ex:\ C:\MiddelwareHome
Specify the absolute path to the directory where you want the installer to create the new Oracle Middleware home.
If the directory does not exist, the installer creates it for you automatically.
Oracle Home > The Oracle home directory is where your products are installed. All software binary files reside in this directory, and no run-time process can write to this directory.
Specify the directory inside the Oracle Middleware home where you want to install your products, but note the following:
■ If you specify a new directory, it is created inside the Oracle Middleware home.
■ If you specify a directory that exists (for example, you are reinstalling due to an incomplete previous installation), then an error message
appears and the installation does not allow you to proceed.
WebLogic Server Directory > The directory name for your WebLogic Server. The installer automatically creates this directory inside the Oracle Middleware home. The default name for this directory is "wlserver_" followed by the version number. For example, wlserver_10.3.
Domain Home Location > The home directory for the domain associated with your Oracle Business Intelligence system. The directory you specify must not exist.
Oracle Instance Location > The absolute path to the location where you want to create the Oracle Instance directory. The installer creates the Oracle Instance directory using the location you specify in this field. You can enter the path of an existing directory, but the directory must be empty.
The directory that you identify for the Oracle Instance can be located anywhere on your system, and does not need to be inside
the Oracle Middleware home.
Oracle Instance Name > Instance names are important because Oracle Fusion Middleware uses them to uniquely identify instances. If you install multiple Oracle Fusion Middleware instances on the same computer, for example, an Oracle Business Intelligence instance and an Oracle WebLogic Server instance, you must give them different names.
The name you enter for the Oracle Instance directory must:
■ Contain only alphanumeric and underscore (_) characters
■ Begin with an alphabetic character (a-z or A-Z)
■ Consist of 4-30 characters
■ Not contain the host name or IP address of the computer
Step 5 of 12:
Administrator Details. This account is use for the administration of the Weblogic Server and also for Enterprise Manager.
Enter a user name and password. (example weblogic/weblogic12)
Step 6 of 12:
Configure Components. All > Next
Step 7 of 12:
Database Details. Enter the details of your database with the credentials that you have specified earlier > Next
Step 8 of 12:
Configure ports
select "auto port configuration"
Step 9 of 12:
Skip security update screen.
Installation Progress
Step 10 of 12:
Configuration Progress
Configuration Log Location for Linux with an previous Database Installation: /u01/app/oraInventory/logs/install2010-10-12_11-59-20PM.log
Step 11 of 12:
After the configuration part is over, 'Summary' screen will come.
Verify that you have :
> 4 gb minimum of RAM
> 4 gb minimum of empty disk space
> valid license key
A) Create required user and tablespace
Tablespace creation >>
SQL> create tablespace Infaadm
datafile '/d03/oraobiee/EKYOBIP/oradata/EKYOBIP/infra_01.dbf' size 2000M
AUTOEXTEND ON
next 50M
MAXSIZE 4000M;
SQL> SHOW PARAMETER sec_case_sensitive_logon
If output of below command is TRUE, then run below command >>
SQL> alter system set sec_case_sensitive_logon=false scope=spfile;
System altered.
User Creation >>
SQL> CREATE USER infa_admin IDENTIFIED BY infa_admin DEFAULT tablespace infaadm TEMPORARY tablespace temp
quota unlimited ON Infaadm;
SQL>GRANT CONNECT, resource, CREATE VIEW TO infa_admin;
B) Start the Installation
go to <software source>/Informatica/i9Pi
sh i9Pi.bin
a) Pre-install system checks will run now.
b) After that two option will come :
Choose option 1 >> Install Infomatica 9.0.1 ....
c) Choose (G)UI mode installation
The default Oracle Business Intelligence URLs are the following (you can see them in the installation Summary step):
Internet Explorer 6 not supported