Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for Oracle Business Intelligence Enterprise Edition and Exalytics

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics

OBIEE 11.1.1.7.150120 comes as patch 20124371.

For the details of the list of patches you may apply in addition to OBIEE 11.1.1.7.150120, please refer to this post. 

Before applying the patch, please ensure you have a good cold backup to restore from if needed.

• On the OBIEE MT server, backup the following: 

<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/server/<SID>/admin/instances/
<SID>/<BIHOST>/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository 
<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/jee/mapviewer.ear/web.war/WEB-INF/conf/mapViewerConfig.xml

• Stop the services.
• cd /<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/web/catalogmanager/configuration/  and remove the following files if exist:

- org.eclipse.osgi

-org.eclipse.equinox.app

• Set the environment variables, go to staging area & apply the patches as below:

1) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

  Make sure the patch is applied by running:   opatch lsinventory| grep 16569379

2) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

   Make sure the patch is applied by running: opatch lsinventory| grep 16913445

3) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep 19823874

4) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep 19822893

5) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep 16997936

6) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  20022695

7) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  19825503

8) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  19822826

9) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  19822857

10) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  17019008

11) opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc -jre $ORACLE_HOME/jdk/jre

Make sure the patch is applied by running: opatch lsinventory| grep  16984654

• Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files

Source: /<SID>/oraclebi/mwh/Oracle_BI1/clients/bipublisher/repository/Tools

Target: /<SID>/admin/user_projects/domains/bi_<SID>/config/bipublisher/repository/Tools

• Copy msmdacc64.dll :

Source: /<SID>/oraclebi/mwh/Oracle_BI1/clients/bipublisher/repository/Admin/DataSource 

Target:/<SID>/admin/user_projects/domains/bi_<SID</config/bipublisher/repository/Admin/DataSource

• Remove the jsp_servlet subdirectory associated with Oracle BI Publisher (if it exists):

/<SID>/admin/user_projects/domains/bi_<SID>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1 and remove any jsp_servlet subdirectory that you find.

• Look in each directory below 

<Middleware home>/<Domain home>/servers/bi_server1/tmp/_WL_user/bipublisher_11.1.1, and remove any jsp_servlet subdirectory that you find.

• If you backed up the mapViewerConfig.xml because it had been modified, then copy the backed-up file to its original location at

/<SID>/oraclebi/mwh/Oracle_BI1/bifoundation/jee/mapviewer.ear/web.war/WEB-INF/conf/

• Admin tool client upgrade:

- Go to the windows box and uninstall current version of BI Admin tool

        - Install the new version of BI Admin Tool using the installer

• Backup & configure config.xml and xdo.cfg files

Go to /<SID>/admin/instances/SID_host/config/OracleBIJavaHostComponent/coreapplication_obijh1 and backup the files config.xml and xdo.cfg.

In the config.xml file, configure the XMLP tag for large data as follows:

<XMLP>< InputStreamLimitInKB>0</InputStreamLimitInKB>

<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing></XMLP>

In the xdo.cfg file, add the following parameter inside the properties tag:

<property name="xlsx-keep-values-in-same-column">true</property>

• Backup & configure opmn.xml

Go to /SID/admin/instances/SID_host/config/OPMN/opmn and backup opmn.xml

Add OBIEE_COMPILER_LOCK_OPTIMIZATION_LEVEL variable for BI Server as 

following.

•<ias-component id="coreapplication_obis1" inherit-environment="true"> 

<environment> 

<variable id="OBIEE_COMPILER_LOCK_OPTIMIZATION_LEVEL" value="2"/> 

</environment>

• Start the services
• Refresh the catalogs

Related Posts:

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini.

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe