OBIEE 11.1.1.7.X Install
1. Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7 - Common Issues Encountered with Installation (Doc ID 1572680.1)
2. http://docs.oracle.com/cd/E28280_01/bi.1111/e10539/toc.htm
3. Patch 20124371 Read me
Environment:
Oracle
Linux EL 6.7 64bit (6 GB Mem, 120 GB Storage)
Database
– 11gR4 – 11.2.0.4
/software
NFS Mount – 120 GB
Process:
- 1. Oracle Linux 6.7 64 bit Install
- 2. Oracle Database Install – 11.2.0.4
- 3. OBIEE Repository RCU Install
- 4. OBIEE 11.1.1.7.0 Install
- 5. OBIEE Patch 20124371 Application
Software Download:
·
Oracle Linux 6.7 64 bit
Download from Oracle Edelivery or OTN
·
Oracle Database – 11gR4
– 11.2.0.4
Form OTN,
or support.oracle.com
·
OBIEE
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1923016.html
·
Required Patch for
OBIEE
Patch – 20124371
Install Linux:
·
Install Oracle Linux
Follow the link for “How to Install Linux 6.7
64 bit”
Linux Requirements:
·
To change the open file limits:
Log in as the root user.
Locate and open the following operating system
configuration file:
/etc/security/limits.conf
Look for or modify the following lines in the
limits.conf file:
* soft
nofile 4096
* hard
nofile 65536
* soft
nproc 2047
* hard
nproc 16384
Save your changes and close the limits.conf
file.
If you are running Oracle Enterprise Linux 6 or
Red Hat Linux 6, locate the following operating
system configuration file:
/etc/security/limits.d/90-nproc.conf
Make sure the same values are added to the
90-nproc.conf file; otherwise, the values in the 90-nproc.conf file can
override the values in the limits.conf file.
Reboot the machine.
·
Required RPM’s
- binutils-2.20.51.0.2-5.28.el6
- compat-libcap1-1.10-1
- compat-libstdc++-33-3.2.3-69.el6 for x86_64
- compat-libstdc++-33-3.2.3-69.el6 for i686
- gcc-4.4.4-13.el6
- gcc-c++-4.4.4-13.el6
- glibc-2.12-1.7.el6 for x86_64
- glibc-2.12-1.7.el6 for i686
- glibc-devel-2.12-1.7.el6 for i686
- libaio-0.3.107-10.el6
- libaio-devel-0.3.107-10.el6
- libgcc-4.4.4-13.el6
- libstdc++-4.4.4-13.el6 for x86_64
- libstdc++-4.4.4-13.el6 for i686
- libstdc++-devel-4.4.4-13.el6
- libXext for i386
- libXtst for i386
- libXi for i386
- openmotif-2.2.3 for x86_64
- openmotif22-2.2.3 for x86_64
- redhat-lsb-4.0-3.el6 for x86_64
- sysstat-9.0.4-11.el6
- zlib for i386
·
Change the value of
SHMMAX to 4294967295 by including the following line in /etc/sysctl.conf:
kernel.shmmax = 4294967295
Activate the new SHMMAX setting by running the
command:
/sbin/sysctl –p
Start the Oracle Universal Installer and
install your software.
·
Required Locations
Login as root user
$mkdir oracle
$chown obiee:dba /oracle
$chmod 775 –R /oracle
$exit #to obiee user
$mkdir /oracle/oraInvenotry
$mkdir /oracle/middleware
Install Database 11gR4:
·
Install Oracle Data
base
Follow the Link for “How to Install Oracle 11gR4 Database”
Repository RCU Install:
·
Before installing
Oracle Business Intelligence, RCU to create the Metadata Services (MDS) and
Business Intelligence Platform (BIPLATFORM) schemas in the database.
·
Database should be up
and running
$cd /mnt/software/obiee/rcu/bin
./rcu.sh
Welcome
screen, click Next. The Create
Repository screen opens.
Create
Repository screen, select Create and
then click Next.
Database Connection Details screen, select the type of database on the system. This is the
database in which you create the Oracle Business Intelligence schemas. Provide
the necessary credentials for RCU to connect to the database.
Click Next.
Checking
Prerequisites screen, After the checks
conclude with no errors, click OK to dismiss the screen and proceed to the
Select Components screen.
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.
Oracle Business Intelligence
11g Installer automatically creates schema names in the format
prefix_schemaname. For example, if you provide the prefix BI, RCU creates a
schema named BI_BIPLATFORM.
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.
Do not select the Oracle AS Repository
Components option, as this configures RCU to install many other schemas that
are not required by Oracle Business Intelligence. Click Next
Checking
Prerequisites screen, After the checking is
complete with no errors, click OK to dismiss the screen and proceed to the
Schema Passwords screen.
Passwords
screen, select Use same password for
all schemas, and provide and confirm a password for the schemas. Click Next
Map
Tablespaces screen, confirm the schema
names. Click Next
Create
the tablespaces for the schemas,
After the tablespaces
are created with no errors, click OK to dismiss the screen and proceed to
the Summary screen.
Summary
screen, click Create. The Create
screen opens and RCU creates the schemas. After the schemas are created with no
errors, the Completion Summary screen opens.
Completion Summary
screen, click Close.
Validate Install:
·
Execute bellow command
./runInstaller –validate
·
For Silent Validate
./runInstaller -silentvalidate -response response_file_path
OBIEE INSTALL
OBIEE Architecture:
OBIEE 11.1.1.7.0 Install:
·
Welcome:
Click Next to continue.
·
Install Software Updates: Specify your My Oracle Support account
information and software update preferences.
Click Next to continue.
·
Select Installation Type:Click Enterprise Install.
Click Next to continue.
·
Prerequisite Checks:
Click Next to continue.
·
Create or Scale Out BI System:
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.
·
Specify Installation Location:
Specify the Oracle Middleware home
location.
Optionally, change the following
settings:
Domain home location
Oracle instance location
Oracle instance name
Click Next to continue.
·
Configure Components:
Deselect the boxes next to the
components that you do not want to install and configure.
Click Next to continue.
·
BIPLATFORM Schema:
Specify the database type, the database
connection string, and the user name and password for the Business Intelligence
Platform schema.
Click Next to continue.
· MDSSchema:
Specify the database type, the database
connection string, and the user name and password for the MDS schema.
Click Next to continue.
·
Configure Ports:
Click one of the following options:
Auto Port Configuration: Oracle Business
Intelligence 11g Installer configures the ports automatically.
Specify Ports Using Configuration File:
Configure the ports using a configuration file that you specify. Click Browse
to navigate to the configuration file and click View/Edit to view and edit it.
If you edit the file, click Save to save your changes.
Click Next to continue.
·
Specify Security Updates:
Specify your My Oracle Support account
information and security update preferences.
Click Next to continue.
·
Summary:
Verify the information on this screen.
Click Back to change the information in
a previous screen.
Click Save to save the settings for the
installation in a response file.
Click Install to begin the installation.
·
Installation Progress:
When the installation is 100% complete,
Oracle Business Intelligence 11g Installer automatically proceeds to the
Configuration Progress screen.
·
Configuration Progress:
When the configuration is 100% complete,
click Next to continue.
·
Complete:
Click Finish to exit Oracle Business
Intelligence 11g Installer.
Validate Install:
·
Validate all links
Screens:
20124371 – Oracle BI EE Suite Bundle
Patch 11.1.1.7.150120:
Patch Stage:
·
Patch
20124371 is the top-level patch and it contains all of the cumulative component
patches. This provides a single patch to download from My Oracle Support,
although there are several component patches that must be installed in the
Oracle BI Home directory.
·
Unzip patch
$unzip –o
p20124371_111170_Linux-x86-64.zip
Following files will be extracted:
p16913445_111170_Generic.zip
p19823874_111170_Generic.zip
p16997936_111170_Generic.zip
p20022695_111170_Generic.zip
p19825503_111170_Linux-x86-64.zip
p19822826_111170_Linux-x86-64.zip
p19822857_111170_Linux-x86-64.zip
p19822893_111170_Generic.zip
·
Patchs details
16913445-Oracle Business Intelligence
Installer (BIINST)
19822893-Oracle Business Intelligence
Publisher (BIP)
19825503-Enterprise Performance
Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
19822857-Oracle Business Intelligence
Server (BISERVER)
19822826-Oracle Business Intelligence
Presentation Services (BIPS)
19823874-Oracle Real-Time Decisions
(RTD)
16997936-Oracle Business Intelligence
ADF Components (BIADFCOMPS)
20022695-Oracle Business Intelligence
Platform Client Installers and MapViewer
·
Unzip all
sub patches, Patches will ber extracted ../ 20124371/19822857
Environment Values:
·
Set
follwing variables
-
Middleware
Home Locations - /oracle/middleware/Oracle_BI1
TMP=/oracle/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOME=/oracle/middleware/Oracle_BI1;
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
JAVA_HOME=$ORACLE_HOME/jdk; export
JAVA_HOME
PATH=$JAVA_HOME/bin:$PATH; export PATH
PATH=$ORACLE_HOME/OPatch:$PATH; export
PATH
Patch Conflicts:
·
Check for
patch conflicts by entering the following command:
opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
·
Examples:
[obiee@obiee Oracle_BI1]$ cd
/mnt/software/OBIEE117_Linux64/20124371/16913445
[obiee@obiee 16913445]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 16913445]$ cd
/mnt/software/OBIEE117_Linux64/20124371/19823874
[obiee@obiee 19823874]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 19823874]$ cd
/mnt/software/OBIEE117_Linux64/20124371/19822893
[obiee@obiee 19822893]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 19822893]$ cd
/mnt/software/OBIEE117_Linux64/20124371/16997936
[obiee@obiee 16997936]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 16997936]$ cd
/mnt/software/OBIEE117_Linux64/20124371/20022695
[obiee@obiee 20022695]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 20022695]$ cd
/mnt/software/OBIEE117_Linux64/20124371/19825503
[obiee@obiee 19825503]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 19825503]$ cd
/mnt/software/OBIEE117_Linux64/20124371/19822826
[obiee@obiee 19822826]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 19822826]$ cd
/mnt/software/OBIEE117_Linux64/20124371/19822857
[obiee@obiee 19822857]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
[obiee@obiee 19822857]$ cd
/mnt/software/OBIEE117_Linux64/16569379
[obiee@obiee 16569379]$ opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
·
Review
the OPatch prerequisite report to view patches that conflict with the Oracle
Business Intelligence component patch and the patches for which the Oracle
Business Intelligence component patch is a superset.
Patch Installation:
·
Back up the Oracle BI system:
The \bifoundation\server directory.
The
\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
directory.
The \bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml
file
·
Dynamic Monitoring Service patch
16569379
Opatch apply
·
Stop the Oracle BI system
Oracle BI system components:
./opmnctl stopall
WebLogic Managed Server(s):
cd
mwhome/user_projects/domains//bin
./stopManagedWebLogic.sh bi_server1
WebLogic Administration Server:
cd
mwhome/user_projects/domains//bin
./stopWebLogic.sh
·
Execute environment variables
·
Apply Oracle BI EE Suite Bundle Patches
11.1.1.7.150120
Make sure all of the Oracle BI EE
components have been installed and configured in your existing Oracle BI
system, apply all eight patches together as follows:
$cd
/mnt/software/OBIEE117_Linux64/20124371
$opatch napply –skip_duplicate
If not confired in existing Oracle BI
system
$ cd /mnt/software/OBIEE117_Linux64/20124371/16913445
$ opatch apply
Complete rest of the patches
Patch Install Screen:
·
Validate Instalation details
$ opatch lsinventory
·
BIPublisherDesktop64.exe and
BIPublisherDesktop32.exe Files
$ cp $ORACLE_HOME/clients/bipublisher/repository/Tools/BIPublisherDesktop64.exe
/oracle/middleware/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools
cp
$ORACLE_HOME/clients/bipublisher/repository/Tools/BIPublisherDesktop32.exe
/oracle/middleware/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools
·
Remove the jsp_servlet
Remove the jsp_servlet subdirectory
associated with Oracle BI Publisher (if it exists)
$ cd /oracle/middleware /user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1
$ rm –r jsp_servlet
·
Start Services
Starting WebLogic Administration Server:
$ cd
/oracle/middleware/user_projects/domains/bifoundation_domain/bin
./startWebLogic.sh
·
Starting Managed Server:
$ cd
/oracle/middleware/user_projects/domains/bifoundation_domain/bin
./startManagedWebLogic.sh bi_server1
·
start the Oracle BI system components:
/oracle/middleware/instances/instance1/bin
./opmnctl startall
Validations:
