Sudheer Reddy Sankaramaddi

Thursday, July 7, 2016

Install Java 8 in Linux 64bit

Install Java 8 in Linux:

1. Before installing Java, make sure to first verify the version of installed Java.
[obiee@obiee12c oracle]$java -version
java version "1.7.0_75"
OpenJDK Runtime Environment (IcedTea 2.5.4) (7u75-2.5.4-2)
OpenJDK 64-Bit Server VM (build 24.75-b04, mixed mode)

It’s clear from the output above that the installed version of Java is OpenJDK 1.7.0_75.

2. Make a directory where you want to install Java. For global access (for all users) install it preferably in the directory /opt/java.
[obiee@obiee12c oracle]$ su
password
[root@obiee12c oracle]# mkdir /opt/java
[root@obiee12c oracle]# cd /opt/java

3. Now it’s time to download Java (JDK) 8u91 source tarball files for your system architecture by going to official Java download page.
For reference, we have provided the source tarball file-names, please select and download these below mentioned files only.
- jdk-8u91-linux-x64.tar.gz        [For 64-bit Systems]

[root@obiee12c oracle]# cd /opt/java
[root@obiee12c oracle]# wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/8u91-b14/jdk-8u91-linux-x64.tar.gz"

4. Once file has been downloaded, you may extract downloaded file
[root@obiee12c oracle]# tar -zxvf jdk-8u91-linux-x64.tar.gz

5. Next, move to the extracted directory and use command update-alternatives to tell system where java and its executables are installed.
[root@obiee12c oracle]# cd jdk1.8.0_91/
[root@obiee12c oracle]# update-alternatives --install /usr/bin/java java /opt/java/jdk1.8.0_91/bin/java 100
[root@obiee12c oracle]# update-alternatives --config java

There are 3 programs which provide 'java'.

Selection    Command
-----------------------------------------------
* 1           /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java
   2           /usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java
+ 3           /usr/java/jdk1.8.0_91/jre/bin/java

Enter to keep the current selection[+], or type selection number:

6. Tell system to update javac alternatives as:
[root@obiee12c oracle]# update-alternatives --install /usr/bin/javac javac /opt/java/jdk1.8.0_91/bin/javac 100
[root@obiee12c oracle]# update-alternatives --config javac

There are 2 programs which provide 'javac'.

Selection    Command
-----------------------------------------------
*+ 1           /usr/java/jdk1.8.0_91/bin/javac
   2           /opt/java/jdk1.8.0_45/bin/javac

Enter to keep the current selection[+], or type selection number:

7. Similarly, update jar alternatives as:
[root@obiee12c oracle]# update-alternatives --install /usr/bin/jar jar /opt/java/jdk1.8.0_91/bin/jar 100
[root@obiee12c oracle]# update-alternatives --config jar

There is 1 program that provides 'jar'.

Selection    Command
-----------------------------------------------
*+ 1           /usr/java/jdk1.8.0_91/bin/jar

Enter to keep the current selection[+], or type selection number: 1
[root@obiee12c oracle]#

8. Now You may verify the Java version again, to confirm.
[root@obiee12c oracle]# java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)
[root@obiee12c oracle]#

Optional:
Setting up Java Environment Variables.

# export JAVA_HOME=/opt/java/jdk1.8.0_91/
# export JRE_HOME=/opt/java/jdk1.8.0._91/jre
# export PATH=$PATH:/opt/java/jdk1.8.0_91/bin:/opt/java/jdk1.8.0_91/jre/bin

If you are not using OpenJDK (open source implementation of java), you may remove it as:
# apt-get remove openjdk-*

Oracle Database 12cR1 install step by step on Oracle Linux 6.8

Oracle Database 12cR1 Install

How to Install Oracle Database 12cR1 on Oracle Linux 6.8 – 64bit

Environment:

Oracle Linux 6.7 64bit, 6 GB RAM

150 GB Disk Space

Download:

1. V38500-01_1of2.zip
2. V38500-01_2of2.zip

· Download from OTN

Unix Required:

· Directories

$su # enter the password for root access

[root@obiee12c /]# mkdir oracle

[root@obiee12c /]# chown oracle:dba /oracle

[root@obiee12c /]# chmod -r 775 oracle

[root@obiee12c /]# exit

[obiee@obiee12c ~]$ cd /oracle

[obiee@obiee12c oracle]$ mkdir database

[obiee@obiee12c oracle]$ mkdir orainventory

· Inventory Setup

[oracle@obiee12c oracle]$ su

Password:

[root@obiee12c oracle]# cd /etc

[root@obiee12c etc]# vi oraInst.loc

Add following lines

inventory_loc=/oracle/database/orainventory

inst_group=dba

Save and exit

· Host Name Setup

Check the host name

[root@obiee12c etc]# vi hostname

#add bellow line at host file, if host name not exist

192.168.64.13 obiee12c.oracle oracle

"IP Address might be differ"

Oracle Pre Install RPM:

· To Install Oracle Database 12cR1 on a Linux system, need to pre-configure the operating environment since the database requires certain software packages, package versions, and tweaks to kernel parameters.

Using the Oracle RDBMS Server 12cR1 Pre-install RPM, you can complete most of the pre-installation configuration tasks

· Install RPM

[obiee@obiee oracle]$ su

Password:

[root@obiee oracle]# yum install oracle-rdbms-server-12cR1-preinstall

Restart the server

Manual Install and Configurations:

· Limits:

Add following values to /etc/security/limits.conf

obiee soft nofile 1024

obiee hard nofile 65536

obiee soft nproc 16384

obiee hard nproc 16384

obiee soft stack 10240

obiee hard stack 32768

obiee hard memlock 134217728

obiee soft memlock 134217728

· System Controls:

Add following Values /etc/sysctl.confto

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

/etc/security/limits.d/90-nproc.conf:

* - nproc 16384

· Users and groups:

groupadd -g 501 oinstall

groupadd -g 502 dba

groupadd -g 503 oper

groupadd -g 504 asmadmin

groupadd -g 506 asmdba

groupadd -g 505 asmoper

Creating Users and Groups:

useradd -u 502 -g oinstall -G dba,asmdba,oper oracle

passwd oracle

· Required RPMS:

Following RPM’s are required for Oracle linux 6 64 bit

binutils-2.20.51.0.2-5.11.el6 (x86_64)

compat-libcap1-1.10-1 (x86_64)

compat-libstdc++-33-3.2.3-69.el6 (x86_64)

gcc-4.4.4-13.el6 (x86_64)

gcc-c++-4.4.4-13.el6 (x86_64)

glibc-2.12-1.7.el6 (x86_64)

glibc-devel-2.12-1.7.el6 (x86_64)

ksh

libgcc-4.4.4-13.el6 (x86_64)

libstdc++-4.4.4-13.el6 (x86_64)

libstdc++-devel-4.4.4-13.el6 (x86_64)

libaio-0.3.107-10.el6 (x86_64)

libaio-devel-0.3.107-10.el6 (x86_64)

make-3.81-19.el6

sysstat-9.0.4-11.el6 (x86_64)

unixODBC-2.2.14-11.el6 (x86_64) or later

unixODBC-devel-2.2.14-11.el6 (x86_64) or later

· Restart Server:

After Installation and configuration, needs to be restart to effect the new changes

Environment Variables:

· Execute following variables before installing

# Oracle Settings

TMP=/oracle/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=obiee.oracle; export ORACLE_HOSTNAME

ORACLE_UNQNAME=OBIEE12C; export ORACLE_UNQNAME

ORACLE_BASE=/oracle/database/obase; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db; export ORACLE_HOME

ORACLE_SID=OBIEE12C; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

Database Install:
[oracle@obiee12c oracle]$ cd /oracle/software/database12c
[oracle@obiee12c oracle]$ ./runInstaller

1. Our Installer has been launched here. For every steps we need to move forward by Clicking Next or OK

2. Configure Security Updates:
I’m going to skip this step as I don’t want security updates. Un-check the check box and mark the checkbox that says “Wish to receive security updates via My Oracle Support“.
Click on Next, you will get a error saying that you’ve not provided and email address click Yes to continue.

3. Software Updates:
While we skiped the email step by default it will choose skip software updates Click next to continue.

4. Installation Option:
Next, choose the type of installation, I’m choosing the first option to Create and configure a database.

5.System Class:
I’m going to choose Server Class here. If we need to install in any Desktop machines we can choose the above Option as Desktop Class.

6.Grid Installation Options:
We are going to setup only single instance database installation here. So, select the first option.

7.Install Type:
Choose the Advance install option to get more option while going through Installation steps.

8.Product Languages:
By Default Language will be chooses as English. If you need to change according to your language, choose from the below list.

9.Database Edition:
Time to choose which edition of database installation we looking for. For large scale Productions we can use Enterprise or if we need standard edition or we can choose the options as mentioned there. We need more than 6.5 GB space for Enterprise installation because database Population will grow soon/increase.

10.Installation Location:
Enter the Oracle base installation location, here all installed configurations files will be stored. Here you need to define the location of oracle installation path, as we created the location above in the second part of this article.

11.Creating Inventory:
For the first time installation, every Inventory files will be created under ‘/oracle/database/oralnventory‘ directory. We have created the group oracle for installation. So now the oracle group has permission to access Inventory Directory. Let us choose the Oracle as the Group for Operating system group.

12.Configuration Type:
Select the type of database, you want to create. Since, we are using for General purpose, so choosing general from the below options and click Next.

13.Database identifiers:
Specify the Global Database name for uniquely identified and un-check the Create as Container database, as here we are not going to create multiple databases.

14.Configuration Options:
In my installation, I have assigned 6GB of Memory to my virtual machine, but this is not enough for Oracle. Here we need to Enable allocate memory automatically for the use of system global Area.
Check the box that says Enable Automatic Memory Management and keep the default allocate memory. If we need some sample schema’s we can check and continue for installation.

Change Character Set to AL32UTF8

15.Database Storage:
We need to choose the location to store the database storage. Here I’m going to assign ‘/oracle/database/obase/oradata‘ location to save the databases and Click Next to continue to installer steps.

16.Management Options:
I don’t have a Cloud control manager credentials from oracle, so I have to skip this step.

17.Recovery Options:
If we have to Enable recovery options, then we have to check the Enable Recovery. In real environment these options are Compulsory to setup. Here to enable this option we need to add separate group and we need to define one of the file system location rather than default location where our database save.

18.Schema Passwords:
We need to define the password for starter database which is all pre-loaded while the installations. Password must contain alphanumeric, upper_case and lower_case. For example, my password is Oracle123. This password we will use in web interface login too.

19.Operating system Groups:
We need to provide system privileges to create database for that we need to choose the "dba" group. Choose oracle for every options.

20.Summary:
At last we can review every settings before database population. If we need any changes we can edit the settings.

21.Install Product:
Installation started to Preparation and copying files. This will take long time to complete according to our Hardware Resource.

22. During setup process, it will ask to run two scripts as a root user

[oracle@obiee12c oracle]$ su
Password:
[root@obiee12c oracle]# cd /
[root@obiee12c oracle]# ./oracle/database/oralnventory/orainstRoot.sh
[root@obiee12c oracle]# ./oracle/database/obase/product/12.1.0/db_1/root.sh

After successfully execution of above two scripts, we need to move forward by clicking on OK.
After finishing all the above tasks successfully, we will receive the Database Configuration Assistant window with the all the details and it will show you the EM Database Express URL. Click OK to move forward.

Finally Oracle Database installation was successfully completed. Click on Close to quit the Oracle Installer.

Verify Install:

· Start and Stop

[oracle@obiee12c oracle]$ sqlplus / as sysdba

SQL> Shutdown immediate

SQL> exit

[obiee@obiee12c oracle]$ sqlplus / as sysdba

SQL> startup

SQL> exit

· Listeners Start and Stop

[oracle@obiee12c oracle]$ lsnrctl stop

[oracle@obiee12c oracle]$ lsnrctl start

· DB EM Express:

Open following link in browser

http://obiee12c.oracle:5500/em/
When EM Express prompts you for your username and password, Use to log in as a user with DBA privilege such as SYS or SYSTEM and use the password which we used for Schema password.After login into the Oracle panel, you can see the main interface as Database Home and few screen shot as shown below.

Monday, February 8, 2016

OBIEE 11g 11.1.1.7.X Install on Oracle Linx 6

OBIEE 11.1.1.7.150120 on Oracle Linux 6.7 64 bit:

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”

http://sankaramaddi.blogspot.com/2015/12/how-to-install-oracle-linux-67-64-bit.html

Linux Requirements:

· To change the open file limits:

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

$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”

http://sankaramaddi.blogspot.com/2015/12/oracle-database-11204-install-linux-67.html

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: