OBIEE 11g - Oracle Business Intelligence 11.1 Simple installation steps on Windows and OEL Linux 32 bit
About
This article covers the installation of Oracle Business Intelligence 11.1.
The term:
- Oracle Business Intelligence Enterprise Edition refers to Answers, Dashboards, Delivers, Repository Administration Tool, Office, and Oracle Business Intelligence Publisher)
- Oracle Business Intelligence refer to Oracle Business Intelligence Enterprise Edition, Oracle Real-Time Decisions, and Oracle Business Intelligence Publisher.
You can choose to install one, two, or all three of these products, using Oracle Business Intelligence Installer. Oracle Business Intelligence Installer creates all the runtime components and the infrastructure for the products you choose to install. After running Oracle Business Intelligence Installer, the installed products share the same Oracle Fusion Middleware infrastructure in a single WebLogic domain.
Articles Related
If you have already OBIEE 11g installed and that you don't to loose your configuration, you can do an in-place upgrade:
Good to know
Knowledge of:
By default, the Oracle Business Intelligence components are installed in a cluster configuration and are scalable.
You cannot add Oracle Business Intelligence to an existing domain created by Oracle WebLogic Server or another Oracle Fusion Middleware product.
After running Oracle Business Intelligence 11g Installer, the installed products share the same Oracle Fusion Middleware infrastructure in a single WebLogic domain.
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.
Installation
Type of installation
Type of installation
|
Purpose
|
Definition
|
Simple Install
|
Demonstration and Evaluation
Single-User Development |
Installation with the default settings on a single computer in the minimum number of steps
|
Enterprise Install
|
Enterprise Deployment
for Hosted Development and Production |
Enterprise Install type enables you to specify several more configuration settings than the simple
|
Software Only Install
|
Enterprise Deployment
for Highest Levels of Availability and Security |
Installation of the binary without configuration
|
System Requirement and certification
Before performing any installation, you should read the system requirements and certification documentation to ensure that your environment meets the minimum installation requirements:
- system requirements for hardware and software requirements (minimum disk space and memory requirements, required system libraries, packages, or patches)
- certification document for supported installation types, platforms, operating systems, databases, JDKs, and third-party products
RCU is available only on 32-bit Linux and Windows platforms.
Below are the recommended hardware and system configuration requirements for an Oracle Business Intelligence installation on Linux and 32-bit Windows operating systems:
- Disk Space: 20GB or more
- Available Memory: 4GB or more
- Temp Space: 950MB or more
- Swap Space: 3GB or more
- CPU: dual-core Pentium, 1.5GHz or greater
Prerequisites
Database
The database 11gR2 is required if you want to run the Oracle Business Intelligence Enterprise Edition Plus Samples
Oracle Fusion Middleware only supports schemas in a byte-mode database. The nls_length_semantics initialization parameter on the database must be set to BYTE; setting this parameter to CHAR is not supported.
Operating System
On Windows
If you are installing Oracle Fusion Middleware on a Windows system, and that system already contains your Oracle Database, then you may encounter issues where the ORACLE_HOME global environment variable used by the database is overwritten by the Oracle Fusion Middleware product installation. As workaround, suppress it or set the value of ORACLE_HOME to the BI location in a DOS command.
On Linux
Creation of the installer user
On Linux, running Oracle Business Intelligence 11g Installer as the root user is not supported.
- Creation of the orinstall group
[root@oel11g ~]# groupadd oinstall
- Creation of the OBI User
[root@oel11g ~]# /usr/sbin/useradd obi -g oinstall
[root@oel11g ~]# passwd obi
Changing password for user obi.
New UNIX password:
BAD PASSWORD: it is WAY too short
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
Creation of the Middleware Home directory
mkdir -p /MiddlewareHome
chown -R obi:oinstall /MiddlewareHome
chmod -R 775 /MiddlewareHome
where
- Linux - chown: Change owner to the user obi
- chmod 775: Everything is allowed for the owner and read and execute access are allowed for everyone
Package
The prerequis verification of the installer will check all package. With an Oracle Database 11g installed, you need only to install one package (compat-db-4.1.25-9) that you can get from yum of from the installation DVD.
On yum, I found the package compat-db-4.2.52-5.1.i386.rpm that I have copied and installed from the tmp directory.
[root@oel11g tmp]# rpm -Uvh compat-db-4.2*
Preparing... ########################################### [100%]
1:compat-db ########################################### [100%]
Set the File Handle Limit parameter
Set the hard and soft limit to the OBI user by modifying the file limits.conf such as for a database installation:
obi soft nofile 4096
obi hard nofile 65536
- To discover the file-descriptor settings, run the command ulimit -a
[root@oel11g dev]# ulimit -a|grep open
open files (-n) 4096
Environment Variable
# 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
DHCP Computer
If you attempt to install on a machine that is using DHCP, does not have a primary DNS suffix, and does not have a loopback adapter configured, then the Oracle BI installer will stop at the screen prompting for the Administrator user details. This appears as a red cross in the tree on the left hand side of the installer. This issue is caused by the installer not being able to resolve the IP address to a hostname.
The workaround is to configure a loopback adapter or primary DNS suffix.
To configure a loopback adapter:
- On windows: Windows - Installing a Loopback Adapter
Get the installation files
Get the installation files from the Oracle Business Intelligence (11.1.1.x) Downloads OTN page Alternatively you can get them from edelivery :
- for Oracle Business Intelligence
On Windows systems, ensure that you do not extract the .zip file to a directory name containing spaces.
Remarks that you get the list of the software included
Creation of the metadata repository (with RCU)
Two metadata repositories are needed for:
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).
This requirement does not apply when you scale out an Oracle Business Intelligence system. In a scaled out (clustered) system, you only run RCU and install the database schemas once, before installing the primary node of the Oracle Business Intelligence cluster (the BI domain for the cluster gets created at that time). Additional Oracle Business Intelligence nodes that you install during the scale-out process become members of that domain and, therefore, use the same set of schemas.
Steps
- Go to RCU_HOME/bin
- Start RCU:
- Linux and UNIX: ./rcu
- Windows: rcu.bat
- Welcome > Next
- Step 1 of 7: Create Repository > Create > Next
- Step 2 of 7: Database Connection Detail > Fill in the connection detail > Next (Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID))
- 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.
- 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.
- Step 5 of 7: Map TableSpaces > Next. Validation. Ok.
- Step 6 of 7: Summary > Next.
- Step 7 of 7: Completion Summary > Close. The log files are in the directory RCU_HOME\log.
Installer
On Linux, running Oracle Business Intelligence 11g Installer as the root user is not supported.
To start the installer launch on the directory bishiphome/Disk1/ the file below:
- setup.exe for Windows
- ./runInstaller for Linux (without the sh extension)
On Windows, if you have downloaded the setup.exe installer in the C:\Document and Settings directory, and there is also the C:\Documents directory already present on your system, the installer will not start as it will attempt to locate files in C:\Documents. The work around is to either remove or rename the C:\Documents directory.
The Enterprise install type is not supported when installing on an AIX operating system or with a 64-bit JVM, such as on a supported 64-bit operating system. Instead, use the Software Only Install type.
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. However, if installing Oracle Business Intelligence into a shared Fusion Middleware home where Node Manager is installed, Oracle Business Intelligence Platform Installer uses the existing Node Manager and its port number.
- Step 1 of 12: Welcome > Next
- Step 2 of 12: Type Install: Simple Install > Next
- Step 3 of 12: Pre-requisite Check > Next
Windows: Minimum Memory: 1024 Mb, Service Pack 2, System: 5.1, 5.2, 6.0, 6.1 Linux: package: compat-db-4.1.25-9, kernel parameters (hard nofiles 4096, soft nofiles 4096)
- Step 4 of 12: Middleware Home > Enter the directory path without trailing space. Ex:\ C:\MiddelwareHome
In a Windows environment, do not specify a Middleware home (MW_HOME) that is at the root of a drive (for example, C: or D:). Instead, install Oracle Business Intelligence into a path that is at least one directory level below the root drive (for example, C:\Oracle).
- 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. (in my case, 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 in the Step 4 of 7 of the creation of the metadata repository (with RCU) > Next
- Step 10 of 12: Installation Progress
- Step 11 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 12 of 12: Summary
Windows:
Type: Simple Install
Installation Details
Middleware Home: E:\MiddelwareHome
BI Oracle Home: E:\MiddelwareHome\Oracle_BI1
WebLogic Server Home: E:\MiddelwareHome\wlserver_10.3
BI Domain Home: E:\MiddelwareHome\user_projects\domains\bifoundation_domain
BI Domain Name: bifoundation_domain
Instance Home: E:\MiddelwareHome\instances\instance1
Instance Name: instance1
Configure Components
WebLogic Console
http://WINDOWS11G:7001/console
Oracle Enterprise Manager
http://WINDOWS11G:7001/em
Business Intelligence Enterprise Edition
http://WINDOWS11G:9704/analytics
Business Intelligence Publisher
http://WINDOWS11G:9704/xmlpserver
Real-Time Decisions
http://WINDOWS11G:9704/ui
Linux:
Type: Simple Install
Installation Details
Middleware Home: /MiddlewareHome
BI Oracle Home: /MiddlewareHome/Oracle_BI1
WebLogic Server Home: /MiddlewareHome/wlserver_10.3
BI Domain Home: /MiddlewareHome/user_projects/domains/bifoundation_domain
BI Domain Name: bifoundation_domain
Instance Home: /MiddlewareHome/instances/instance1
Instance Name: instance1
Configure Components
WebLogic Console
http://oel11g.localdomain:7001/console
Oracle Enterprise Manager
http://oel11g.localdomain:7001/em
Business Intelligence Enterprise Edition
http://oel11g.localdomain:9704/analytics
Business Intelligence Publisher
http://oel11g.localdomain:9704/xmlpserver
Real-Time Decisions
http://oel11g.localdomain:9704/ui
Connection to the components
When a Simple Install concludes, the WebLogic Server and Oracle BI Server start, and a browser window opens to the home page for your Oracle Business Intelligence instance and you are able to connect with the administrator account (Weblogic/Weblogic12)
The default Oracle Business Intelligence URLs are the following (you can see them in the installation Summary step):
Component
|
Default URL
|
Default Port
|
9704
| ||
7001
| ||
7001
| ||
9704
| ||
Real-Time Decisions
|
9704
|
Next Steps
- Explore the sample application lite made with an XML datasource.
The administrator password of the repository is Admin123
- Install the complete sample application to explore the nieuw possibilites of OBIEE 11G: OBIEE 11G - Installation Sample Application version 825
